I would like to extract data from certain foxpro tables. I have created a DBC and within the DBC I have added a table from my application called modacad. On the modacad table I have inserted 3 triggers for INSERT, UPDATE & DELETE in the following way:
addmodacadtoapp("INSERT",mainkey)
addmodacadtoapp("UPDATE",mainkey)
addmodacadtoapp("DELETE",mainkey)
Therefore when I go into my application and press save or new. The trigger is fired and using a stored procedure on the DBC fires the data across to another foxpro table. I then have an SQL database with a DTS packages that picks up the data. This works absolutely great!!!
I then tried to do this on another table called specific. So using the same syntax I create triggers:
addspecifictoapp("INSERT",mainkey)
addspecifictoapp("UPDATE",mainkey)
addspecifictoapp("DELETE",mainkey)
I then have a stored procedure etc etc. But when I click save or new nothing happens. I dont even get an error message. I moved the stored procedure so it should fail but still nothing.
I was wondering has anybody expereinced a table whereby the triggers just dont work or they dont get any error messages. I am completely baffled by this. Is there something that I can do to the table? Many Thanks
Neil Lewis
IT R&D Manager
Velmore Ltd