Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Appending Confusion
Message
 
 
To
17/07/2000 13:29:19
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00393400
Message ID:
00393410
Views:
20
>I have a view open in the DE made up of 3 tables. If I append a new record, but only enter data for one of the tables and issue a tableupdate(), what happens.........?
>1. Just that table gets a record appended
>2. all tables get records appended, two of them blank
>3. update errors occur
>
>Thanks
>JD

If you make all 3 tables updatable and have defined Key field for all three, then all 3 get a new record. So, however many of the tables in the view you have defined a key field for get updated.
Mark McCasland
Midlothian, TX USA
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform