Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How go through a Cursor as Parameter
Message
From
18/11/2005 11:33:43
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01070192
Message ID:
01070250
Views:
12
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.
Previous
Reply
Map
View

Click here to load this message in the networking platform