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