>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)
Mark McCasland
Midlothian, TX USA