Field type BIT
Posted: Tue 30 Nov 2004 08:13
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.
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.