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:
00521192
Views:
18
This message has been marked as the solution to the initial question of the thread.
>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).
George

Ubi caritas et amor, deus ibi est
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform