General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
VFP ODBC Issues with triggers
Hey folks,
I need some advice from someone with experience accessing VFP data using the VFP ODBC driver (the one from the VFP6 days). In a certain situation, I needed to access some tables using the ODBC driver with REMOTE VIEWS. Everything works fine, no corrupted data, no problems at all, except that now I want to add some trigger rules to the original table.
I created a custom function, and when I call the TABLEUPDATE() function to the Remote View (RV), I always get a "Trigger failed" error from the ODBC driver. I know the ODBC driver has limited commands available, so just for a test, I changed the contents of my "triggerFunction", and now all it has is a "RETURN" command inside, and to my surprise, I still get the "Trigger failed" error.
Notice that the related table does not use any of the new features from VFP9 tables, such as AutoInc, Blob, special Indexes, etc.
Accessing the native data directly, without the RV and ODBC driver, it works perfectly as desired.
Does someone have any hint to make it work?
Thanks in advance for any ideas.
Regards,
Cesar
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only