Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How go through a Cursor as Parameter
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
MS SQL Server
Divers
Thread ID:
01070192
Message ID:
01070250
Vues:
11
Hi Jesus Ramos,

1. make sure the second FORM uses the same data session as the first one.
.Datasesssion = 1 && dafault data session
should do that.

2. pass the cursor alias name, ALIAS() gives the name of the current workarea.

3. receive and work with the alias name this way (some suggestions):
   LPARAMETERS tcAlias

* get a value of a field:
  lnVar = &tcAlias..fieldname

* select the workarea of the cursor:
  Select (tcAlias)

* select from that cursor with SQL:
  Select cur.fieldname from (tcAlias) AS cur

* replace a field in that cursor:
  Replace fieldname WITH newvalue In (tcAlias)
Bye, Olaf.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform