General information
Category:
Coding, syntax & commands
Title:
Grid problem in a one to many form
In a One to Many form, I have 2 tables. Supplier and Products. There's a relation on the SuppNo.
Parent Table is Optimistic Row Buffering. Child Table is Optimistic Table buffering.
Referential Integrity is Cascade for Update, Restrict for Delete and Restrict for Insert.
I add the products for a Supplier in the grid.
In VFP 5.0 I use the new property AllowAddNew and put it to .T..
In VFP 3.0 I use a Command Button adding the record.
In both case, when I add many products, enough to force the grid to scroll, when I save with TABLEUPDATE(.T., .F.), it returns .F. for the update of the products. After that, the back color of the grid come all grey.
It seems like the grid lost the trace of the appended records.
I remark in VFP 5.0 that when I press the down arrow to add a new record, when I'm at the bottom of the grid, it is a record upper in the grid that is highlighted. If I press again the down arrow until adding a new record again, the appended record is then highlighted.
Please help me find what is my problem or how to work around. I'm in trouble
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