Yeap, it was a Fast & Dirty solution I though and code without VFP. Of course if could be buggy and improved.
>I like this, because of its simplicity.
>However, I think it will need a small adjustment, to avoid the field being too small (because of the initial 0). Also, an AS clause is appropriate. Something like SELECT Inc(@lnCounter) + 00000 AS IncCount.
>Note: I don't have Visual FoxPro available to test right now.
>>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
>>
>>