General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>I'd like to know how I can use just database routines i.e a stored procedure or trigger to update a (different) table than the orginal table. In other words I have a table (A) that I add a record or change a field and I want a store procedure or trigger to add a record or update fields in a different table (B) when table (A) is updated. Both tables would be in the same database or not (what ever is required). I would be using VFP 5.0 and not VFP 6.0 to update data.
>TIA
>John
Just create a function that does what you want (in teh SP area of the database)... and then call the function from the Insert/Update trigger. When you modify a table you will find the trigger fields on the TABLE tab.
BOb
Previous
Next
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