Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Cannot insert empty row (CA problem)
Message
From
03/10/2006 14:42:43
 
General information
Forum:
Visual FoxPro
Category:
Troubleshooting
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01159031
Message ID:
01159033
Views:
32
>Hi everybody,
>
>We're getting an intermittent error 1547
>"Cannot insert an empty row from a view or CursorAdapter into its base table(s).". It happens ~ once in 15 or more normal inserts. Where do you think should I look for this problem and what can I do?
>
>Thanks in advance.

Here the description of the error:
While a view is updating, a new empty record (with no modified fields) is being inserted into one of the base tables of the view.

Make sure each record inserted from a view into a base table has at least one field that has been modified in the view prior to
the view update.
Are you sure you don't have somewhere an APPEND BLANK w/o any REPLACE after it?
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform