Field type BIT

[yngve]

dbexpsda.dll v2.00, Delphi 7, MSsqlServer 2000

Showing a TClientDataset (connected to TDatasetProvider->TSqlDataset->TSqlConnection) in a TDBgrid:

Column of type "Bit" shows True/False ok in grid, but locate- and lookup-methods fail (returns NULL) when searching for "True"-values, even though there are many rows with "True" in this column. Searching for "False" works ok.

If I enter "True" in a row in the middle of the grid, the search for "True" now returns this row, effectively ignoring the previous rows.

When I change to Borlands driver, this problem doesn't occur.

[Ikar]

Thank you for information.
We reproduced your problem and fixed it. This fix will be included in the next DbxMda build. It will be available in about two weeks.