Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Grid problem in a one to many form
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Grid problem in a one to many form
Miscellaneous
Thread ID:
00010639
Message ID:
00010639
Views:
88
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
Map
View

Click here to load this message in the networking platform