Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
CURSORSETPROP tables problem.
Message
 
 
À
06/05/2001 20:58:58
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00504046
Message ID:
00504057
Vues:
21
>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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform