Hi,

I have had the error Cannot insert an empty row from a view into its base tables a number of times. The reason in my case was that one of the tables in my view had its updatename property populated even though this table was only in the view for descriptive purposes.

To check this out, use GENDBCX and look at your view definition. Clear the updatename property with.

=DBSetProp('RV_PLSREP.field_nm', 'Field', 'UpdateName', '')

There is even a mention of this error in the readme.txt for the gendbcx program.

Paul


>I have 2 questions on views:
>
>1. Sometimes I get a message,
> Cannot insert an empty row from a view into its base tables
>
>Now, this is probably because of some problem in my code, but is there some command to get out of this...clear all,close all etc does not work, keeps coming up with error and I have to BOMB out of VFP
>
>
>2. I have a from which uses a parameterized updateable view.
> I am not using the data Environment (instaed I open all files on a startup routine) , but message keeps coming up to enter a value in the parameter field (?lcField)
>Now, I know if I was using DE, I wouls set the NODATAONLOAD , but is there an equivalent if i am not using DE ?
>
>regards,
>
>Gerard