Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
CURSORSETPROP tables problem.
Message
 
 
À
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:
00504216
Vues:
19
>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?

The schema name is the user ID the tables are created under. Your problem with creating a cursor from a remote source is specifying the connection to use. AFAIK, you can not specify this. You either have to create a remote view or use SQLExec() to send your updates back to the server. This is really what VFP does with remote views behind the scenes. I suggest looking at GetNextModified() and GetFldState() functions in VFP help as well. You would use those to build your SQL string, then use SQLExec() to pass that update, insert or delete string.
Mark McCasland
Midlothian, TX USA
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform