General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Add Record to Table-Buffered View
This is a real newbie question ...
I've always used child TABLES (this is my first stab at using views instead). Want to use a view for the "many" side of a one-to-many. Table buffer it. Want to wrap the TABLEUPDATE in a transaction (along with the tableupdate for the parent and other related tables) in the FORM save() method.
I will be adding, updating and deleting records in this view. I understand that to add a record in a local view, you must first "blank" out the view. To do this I change the view parameter to zero and requery. I get a new view (with no records). What happens to any updates that may have been made previously in this session (and have not yet been TABLEUPDATED). This is a classic invoice/detail situation, so nothing gets tableupdated until the invoice is done.
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