>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