General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Browse but no Modify?
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???
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only