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,
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