Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
View
Message
From
11/04/1999 14:18:29
 
 
To
11/04/1999 11:31:41
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Re: View
Miscellaneous
Thread ID:
00207284
Message ID:
00207302
Views:
13
>I have view based on two tables. Sometimes I need to update one the tables. I tried cursorsetprop('tables', 'firsttablename') then tableupdate(). Not working for me. Error message is something abount update tables.
>Thanks Mark

There are several view properties that need to be set before a view can be updateable. In the view designer, check the "Send SQL Updates" box on the "Update Criteria" tab. OYu also have to select which fields ae updateable and specify one as your primary key.

Usually, you don't have to do anything with CURSORSETPROP to get a view to update.
Erik Moore
Clientelligence
Previous
Reply
Map
View

Click here to load this message in the networking platform