Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
1-M-M Grid problem. Please Help!
Message
From
10/10/1996 22:45:25
John Baird
Coatesville, Pennsylvania, United States
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Other
Title:
1-M-M Grid problem. Please Help!
Miscellaneous
Thread ID:
00009808
Message ID:
00009808
Views:
78
Help!


I am in the midst of developing a rather large C/S application using remote
views. On one form, I have placed a pageframe with 4 pages. Page 4
contains another pageframe with 6 pages. I am using Access 7.0 as the back
end for development with 32bit ODBC driver. The flow is this:

1st pageframe has parent Field Serive Repair Record with/pertinent data on
pages 1-3. Page 4 contains another pageframe with the 1-M child: Request
for service on page 1 and the other 5 tabs are 1:M children of the Request
for service table.

What we have in essence is 1:M:M.

The problem: If I update the request for service grid on page 1 of the 2nd
pageframe, and use tableupdate() or tableupdate(.t.) the update fails with
an ODBC error. I can tablerevert() with no problem.

When I move the grid to page 4 of the 1st pageframe and deleted the 2nd
pageframe all works well.

Any clues?
Reply
Map
View

Click here to load this message in the networking platform