Datatable.select BUG????

  • Thread starter Thread starter Sue
  • Start date Start date
S

Sue

Hi,
I am trying to select rows from datatable using
datatable.select("GLNO='23345' and amount>=200")
GLNO is a STRING and amount double.
each time the method fetched different number of rows. I
have tried giving sort expression & dataviewrowsate
too,but still it BUGS. It fetches 8 rows sometimes but
most of the times fetches 2,6, 4 rows, I am not able to
notice any pattern in the rows also. Has anyone else
experienced this???
Thanks,
Subha.
 
Hi Sue,

A couple of ideas: is amount a reserved word? Also, can you send me the
table in an mdf (I assume this is sql server) so I could test it? Or just
email the table in, say, csv or dbf or xml - I could then replicate the
select and hopefully find the problem.

HTH,

Bernie Yaeger - (e-mail address removed)
 
That's definetely weird.
What happens if you put rowfilter with same conditions on DataView?
 
Back
Top