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:
01159039
Views:
30
>>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?

Let me double check. In the meantime, how can I specify default value for the field in CA? I'm using Mark McCasland's CA Builder.
If it's not broken, fix it until it is.


My Blog
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform