Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Multi-table view not updating in VFP 3.0b
Message
General information
Forum:
Visual FoxPro
Category:
Troubleshooting
Miscellaneous
Thread ID:
00018919
Message ID:
00019013
Views:
37
>I have a view based on two tables ( A & B).
>
>I allow updates to be sent to table A but not to table B.
>
>When I insert a new record, it gets posted into table A.
>Later when I do a REQUERY on the view, I get the following error message:
>
>Cannot insert an empty row from a view into its base table(s).
>
>How do I get around this problem?
>
>Thanx in advance.

Asif: Does the new record have an ID field that is not being filled in? This could violate a trigger situation. Are you sure the record is really being posted to Table A? It sounds like the posting isn't being done until you do the REQUERY(), and then the error pops up. Check actual field values in the View, Table A and Table B. This might give you some clues.

Barbara
Barbara Paltiel, Paltiel Inc.
Previous
Reply
Map
View

Click here to load this message in the networking platform