Subject | FindKey not working anymore? |
---|---|
Author | acathelp |
Post date | 2005-07-27T16:14:04Z |
We are using the TIBOTable components within Delphi 7 Pro and the
Table.FindKey statements which used to work great all of a sudden have
stopped functioning. The use of a FindKey doesn't return an error,
but it doesn't actually find the correct record either. Every time I
use it I set Table.Active:=False then
Table.IndexFieldNames:='FieldList' then Table.Active:=True before I
use it so I'm not sure what else to try. I know the SQL dialect is
set to 3 (for the Date/Time handling) don't know if that makes a
difference. Please help! My program is falling apart! Thanks!
Nick
Table.FindKey statements which used to work great all of a sudden have
stopped functioning. The use of a FindKey doesn't return an error,
but it doesn't actually find the correct record either. Every time I
use it I set Table.Active:=False then
Table.IndexFieldNames:='FieldList' then Table.Active:=True before I
use it so I'm not sure what else to try. I know the SQL dialect is
set to 3 (for the Date/Time handling) don't know if that makes a
difference. Please help! My program is falling apart! Thanks!
Nick