>>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