General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>>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.
So If I only define a key field for the table I want to update in the view, that's the only table that gets an appended record? Sounds simple enough.
Should the 'Send SQL Updates' checkbox be marked, or will that scramble my data when just browsing?
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