Ladies and Gentlemen,
Anyone know if there is a way to copy triggers over to a new table without having to enquire into the DBC container?
I have found that the triggers are held against each table in the DBC in the record with "objectname field" set to the name of the table, being held in the table "Property field" (Memo) so you can get at the contents of the triggers but I don't really want to have to do this if there is a table copy command or equivalent that does it for you. I am not simply being lazy here as copying this memo field over using scatter/gather doesn't always seem to transfer the correct trigger info over into the destination table.
We have recently started making use of triggers to automatically insert records into a M$ table mirror of the VFP Table to aid in converting over from VFP tables to M$ SQL tables and the inability to copy triggers over has bit me in the proverbial "ass". We have a small tag call to a SQL master object that updates the SQL table whenever the VFP base table is updated (Insert/Update and Delete).
Dave