Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Sequential (row) number as first field in cursor
Message
From
28/09/2005 13:50:42
Gojko Bozic
Ius D.O.O.
Rijeka, Croatia
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Re: Sequential (row) number as first field in cursor
Environment versions
Visual FoxPro:
VFP 6 SP5
OS:
Windows 2000 SP4
Network:
Windows 2000 Pro
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01054066
Message ID:
01054082
Views:
34
So in two steps ?

>SELECT 0000000000 AS SeqNum, &lcFieldList FROM ... into cursor CC WHERE &which

>3. Open cursor R/W and replace SeqNum with RECNO()

>SELECT 0
>USE DBF("cc") AGAIN ALIAS ccsn
>REPLACE ALL SeqNum WITH RECNO()


Thank you, Sergey
Previous
Reply
Map
View

Click here to load this message in the networking platform