Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Updatting multiple tables at once
Message
From
01/11/1996 17:42:35
 
 
To
01/11/1996 16:23:52
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00011277
Message ID:
00011289
Views:
30
>I'm writting an application, but i can't pass this point. One of my forms uses a document id that must be the some in other table. After the user confirm all the data the program must write the new record in the first table and write the new value in the other table. This seems very simple but in fact i can't make it over. Can someone give-me a hint ?? TIA.

It looks like job for INSERT trigger. Set insert trigger stored procedure which will change values in second table. Also if you have explicit relationship between tables you can use UPDATE-SQL command.
Edward Pikman
Independent Consultant
Previous
Reply
Map
View

Click here to load this message in the networking platform