Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Simple SQL
Message
From
13/02/2003 16:44:33
Esparta Palma
PortalFox
Acapulco, Mexico
 
 
To
13/02/2003 16:32:06
Aafzal Khan
Troy, Michigan, United States
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Re: Simple SQL
Miscellaneous
Thread ID:
00752908
Message ID:
00752922
Views:
20
Try with this:
lnCounter=0
SELECT Inc(@lnCounter), Start, End from Counter
FUNCTION Inc(tnIncremental)
tnIncremental = tnIncremental + 1
RETURN (tnIncremental-1)
>Hello all

>I want to get this kind of output from a sql statement,
select start,end from counter
>in counter.dbf it had this data

>start end
>1 5
>6 7
>8 10

>but what i want is to add a column block with continious numbers.

>block start end
>1 1 5
>2 6 7
>3 8 10

Apoya a Visual FoxPro usandolo legalmente
--
¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º
Espartaco Palma Martínez
SysOp PortalFox
http://www.portalfox.com
esparta@portalfox.com
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform