>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,
Does this error?

close all
clear all
addspecifictoapp("INSERT",'somevalue')

Cetin