I just want to know that What's the best method to Set the focus of any Specified Field in DBGrid..
My second Question is I am working in Delphi 3.0 using Local Paradox database and I want to update a table which has a Field called 'TheDate' and the datatype is Date offcourse and I want to issue a UPDATE statement and in Where Clause I want to update the record with the date criteria and I am using this statement;
SET TheDate = :PASSDATE
WHERE members_table.members_code = :anycode
But after executing a query delphi raises an error like 'Error in Creating Cursor'
I dont know why and whats that problem...
And tell me that:
Does SELECT statement automatically change the table state in dsBROWSE and dsEDIT after UPDATE statement or not ?
Ur help in this matter will highly appreciatable...