General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>>>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.
>>
>>That is correct.
>
>
>That should be the way that it is, but unfortunately, it's not. Tables listed in the view's Tables property will all get a blank record and often this will cause an error to the effect of "cannot insert an empty row..." because none of the fields are set as updatable.
>
>Jimmy, you'll need to use the view's Table property via DBSETPROP to ensure that only one table is listed.
So would this do the trick.......
DBSETPROP("intrancust", "view", "Tables", "inventory")
=TableUpdate(.T.)
Thanks
JD
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