Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
How to update a database via triggers or store procedure
Divers
Thread ID:
00243968
Message ID:
00243968
Vues:
60
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