Mark -----

You need to specify a view KeyField and ensure that the fields are updateable via Field properties. The fields are probably already marked updateable, but I can almost guarantee that the KeyField is not.

>
>I have created a temporary database witch hold 4 views for 4 temporary tables. These files are all in the c:\temp\ directory and that one is not in the search path.
>I can now open the database and browse the views but I can't modify them. I can't update the views either. In the first case there is a SQL: Cannont locate table (1802) error and in the other case I get an No update tables are specified (1491) error. I create the views as follows:
>
>CREATE SQL VIEW (lcViewName) ;
> REMOTE CONNECTION (lcRemote) ;
> AS 'Select * from TempFileName'
>
>DBSETPROP(lcViewName, 'View', 'SendUpdates', .T.)
>
>I even do the following (wich shouldn't be necessary)
>CURSORSETPROP('Tables', 'TempFileName', lcViewName)
>
>What's going on here???