Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
CURSORSETPROP tables problem.
Message
 
 
To
06/05/2001 20:58:58
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00504046
Message ID:
00504057
Views:
22
>Does anyone know why when I set the CURSORSETPROP("tables","dbo.table") and I do a tableupdate(1,.T.,"tablename") the tableupdate function will return .F.
> The error states that 'no update table is specified, use the tables property of the cursor'
> When I run CURSORGETPROP("Tables") it will return the table I stated above.
>
>Why would I get this error eventhough the cursorgetprop tells me the tables prperty is set.

First, you separate the DBC name from the table name with an exclamation point unless this is a remote view. For remote views it is SchemaName.TableName.ColumnName. Have you also set properties identifying key fields, updatable, update type, etc.? The following is what is needed to make a cursor updatable:
? CursorSetProp("SendUpdates",.t.)
? CursorSetProp("Tables","dbcname!mytable")
? CursorSetProp("KeyFieldList","keyid")
? CursorSetProp("WhereType",1)
? CursorSetProp("UpdatableFieldList","keyid, descript")
? CursorSetProp("UpdateNameList","keyid mytable.keyid, descript mytable.descript")
? CursorSetProp("Buffering", 5)  && optional [my preference]
Mark McCasland
Midlothian, TX USA
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform