OK I have a whole new frustration now. I have built a conduit which requires me to read and write to an Access database but instead of using a table in the database I am using a Query based on two tables.
Everything works like a charm until I mark a record in the Access Database as Dirty and Deleted. The code runs up to DoDeletePC in pfgPalmSyncComponent and then throws out an ODBC error "Unable to delete record".
I am running Delphi 6, Access 2003, with XP SP2 OS. Is this related to the fact that I'm using a Query instead of a table in Access? Or should I be looking elsewhere?
I find mODBC a necessary evil as there is very little or no help on that. I realise that it's not your code but perhaps you could point me to a useful forum?
Many thanks
Les (in South Africa)
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
It could be the fact that you're using a query. I'm not familiar with the ODBC, but in a basic TQuery component, you need to set the RequestLive property (I think it is) to allow changes made to the Query to be reflected back into the database.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
OK I have a whole new frustration now. I have built a conduit which requires me to read and write to an Access database but instead of using a table in the database I am using a Query based on two tables.
Everything works like a charm until I mark a record in the Access Database as Dirty and Deleted. The code runs up to DoDeletePC in pfgPalmSyncComponent and then throws out an ODBC error "Unable to delete record".
I am running Delphi 6, Access 2003, with XP SP2 OS. Is this related to the fact that I'm using a Query instead of a table in Access? Or should I be looking elsewhere?
I find mODBC a necessary evil as there is very little or no help on that. I realise that it's not your code but perhaps you could point me to a useful forum?
Many thanks
Les (in South Africa)
It could be the fact that you're using a query. I'm not familiar with the ODBC, but in a basic TQuery component, you need to set the RequestLive property (I think it is) to allow changes made to the Query to be reflected back into the database.