HXTT JDBC Products: MS Access JDBC, Cobol JDBC, DBF JDBC, MS Excel JDBC,CSV JDBC, Text JDBC, Corel Paradox JDBC, PDF JDBC, Word JDBC, XML JDBC

where clause with and predicate doesn't return any row	Huu-Dong Quach	2007-12-30 13:07:16
Hi, The following request doesn't return anything: select no_region , no_riviere, no_amenagement, nom_amenagement from amenagement where no_region=0 and no_riviere=1 But if I run the same request in MS Access directly, the request returns about 14 rows from our database which is correct. Do you have any clue?
Re:where clause with and predicate doesn't return any row	HXTT Support	2007-12-30 19:16:57
Try to reindex your table. Maybe there's an index issue.
Re:Re:where clause with and predicate doesn't return any row	Huu-Dong Quach	2007-12-31 08:05:18
Hi, It doesn't work. I reindex the whole database. It seems that I have trouble only with the AND predicate. If I use the OR predicate, it works very well.

Email: