Hi, I have a problem and no posible solution for it.
I my company we are using Adaptive server enterprise 15.0, and .net 2.0.
Now the problem,
We have a table with time series (first column is datetime and other five columns are floats)
Now the query like:
select table1.id,
table1.value_date,
table1.quality_bits,
table1.open_price,
table1.high_price,
table1.low_price,
table1.close_price,
table1.volume
from table1
where table1.id = <someID> and table1.value_date > CAST('2000-05-05' AS datetime) and table1.value_date < CAST ('2005-05-05' AS datetime)


witch is executed (lat say) 100 time returns corect results, but 101 time return some stupid number of results.
Test example is like:
OleDbConnection connection = new OleDbConnection("Provider=ASEOLEDB;Server=xxxxxx;P ort=xxx;Initial Catalog=xxxxxx;User Id=xxxxxx;Password=xxxxx;");

OleDbCommand command = new OleDbCommand();
command.Connection = connection;
command.CommandText = qyery from above

int count = 0;

DbDataReader reader = null;
try
{
connection.Open();
reader = command.ExecuteReader();
while (reader.Read())
{
count++;
}


}
Those anyone have an idea why is this happening (I tried with AseProvider and its still stupid).