Hi all,

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