I know this is a silly question, but it's really bugging me. I'm having a problem with FindFirst when used with a TSQLQuery (Delphi 6). It just doesn't want to work.
Here's some code....
EAQuery.SQL.Add('select * from CONTACT');
If EAQuery.FindFirst then ShowMessage('1st Record Found')
else ShowMessage('There was a problem finding the 1st record');
EAQuery has been defined previously and the connection is working fine - I know that because I can retrieve values from the first row and can therefore retrieve the value from a "Select Count(*)" statement and check the value.
I need to use findFirst and findNext to enumerate the rows.
Any thoughts or suggestions?