Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Error 1547
Message
General information
Forum:
Visual FoxPro
Category:
Troubleshooting
Title:
Miscellaneous
Thread ID:
00521182
Message ID:
00521196
Views:
17
>>Hi everyone,
>>
>>I want to create an empty record, if there is no record in the base table. I use view. I got this error: Cannot insert an empty row from a view into its base table(s) (Error 1547)
>>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.

>>
>>On this code segment:
>>
>>dodefault()
>>lnCustomerID=oJC.CustID
>>select CustomerInfo
>>requery()
>>if reccount()=0
>>   append blank
>>   replace CustomerID with m.lnCustomerID
>>   set step on
>>   thisform.dotableupdate()
>>   requery()
>>endif
>>select RegionsInfo
>>requery()
>>if reccount()>0
>>   lnRegionID=RegionInfo.RegionID
>>   select TownsInfo
>>   requery()
>>endif
>>set status bar on
>>set message to "Create a custom report configuration..."
>>
>>How can I insert a blank record into the view?
>>
>>Thanks in advance.
>
>Use an SQL Insert, populating the necessary field(s).

Thank you. For some reason, I always forgot about it... May be because our framework uses APPEND BLANK...

I found problem. My Table (and view) didn't contain field UserID, but has a Table rule with UpdateUserID()...

Now it works. Thanks again.
If it's not broken, fix it until it is.


My Blog
Previous
Reply
Map
View

Click here to load this message in the networking platform