Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
CURSORSETPROP tables problem.
Message
De
08/05/2001 04:30:21
 
 
À
06/05/2001 23:10:13
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:
00504598
Vues:
20
William,
Try the following against the northwind customers table:
?SQLEXEC(lnSql, "SELECT customerid, companyname FROM customers", "customers")
=CURSORSETPROP("Tables", [dbo."customers"])
=CURSORSETPROP("UpdateNameList", [customerid dbo."customers"."customerid", companyname dbo."customers"."companyname"] )
=CURSORSETPROP("KeyFieldList", "customerid" )
=CURSORSETPROP("UpdatableFieldList", "customerid companyname" )
=CURSORSETPROP("SendUpdates", .t.)
REPLACE companyName WITH UPPER(companyName)
?TABLEUPDATE()
?SQLEXEC(lnSql, "SELECT customerid, companyname FROM customers", "customers")
BROW
>I enterd the cursor properties as you stated and and when I use TABLEUPDATE(1,.t.,"tablename") I still get a return of .F. and aerror() shows once again the error to be 'No update tables are specified. Use the Tables property of the cursor.'
> I am using a remote view, and I set the cursor table property as
>CURSORSETPROP("Tables","owner.table"). This cursor is called using sqlexec()
>You said to use the schema name within the CURSORSETPROP("tables","schema.tablename.field). What would be the schema name?
Daniel
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform