Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Modifying a cursor
Message
From
17/06/2014 17:39:18
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Modifying a cursor
Environment versions
Visual FoxPro:
VFP 5
OS:
Windows Server 2012
Network:
Windows 2008 Server
Database:
MS SQL Server
Application:
Web
Miscellaneous
Thread ID:
01602016
Message ID:
01602016
Views:
73
Hi All:

What is the best way to add to more columns to a cursor and still remain with the same name?

i.e. is this legal:
Sele custno, fieldb ;
from Table1 ;
Into Cursor cursor1

sele cursor1.*, nvl(cursor2.sales, 0) ;
 from cursor1 c1 ;
left outer join cursor2 c2 ;
on c1.custno = c2.custno ;
into cursor <b><i>cursor1</i></b>   &&  <==Same Name
I'm in VFP5, but that should no make any difference; I'll test that.

Thanks,

Yossi
Next
Reply
Map
View

Click here to load this message in the networking platform