Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Cannot insert empty row (CA problem)
Message
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:
01159096
Views:
35
>>>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?
>
>Interestingly, I have the same code in Address Biz object and Phones Biz Object. However, I'm only able to reproduce the problem with Phones. Somehow it inserts two records into the CA cursor.

Sorry, I couldn't be in help here :o( I don't know your biz objects.
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