>>Is there a way to have a value that increments by one in a SQL statement?
>>
>>

>>SELECT *, IncrementThisValueByOne FROM MyTable
>>

>>
>>To get:
>>
>>

>>MyFieldOne MyFieldTwo IncrementThisValueByOne
>>
>>Bobby      Jones      1
>>Jamie      Lee        2
>>Terry      Hatcher    3
>>

>
>Yes.
>

>select MyField1, myField2, recno() from (select myField1, myField2 from myTable...)

>
>That was a tip by Tamar Granor on the last NY User Group meeting.

Did Tamar show this exact code for this exact purpose? Is the use of RECNO() in SELECT - SQL guaranteed to work in this manner in VFP9?

In earlier versions of VFP I got burned with some very hard-to-track bugs when using RECNO() in SELECTs. There were significant SQL engine enhancements in VFP9; maybe it's now safe to use it that way. However, VFP9 also supports more complex queries in general, and without a lot of testing, how can we be assured that RECNO() will work as expected in these scenarios?

Another consideration is that using RECNO() in a query is not ANSI-compliant. So, you couldn't use it to pull data off a non-VFP backend.