>Hi:
>I'm wanting to populate a listbox with a SQL query.
>In the result I would like a count of the record (like a RECNO()) in the result..
>such as following result:
>1 record data
>2 record data
>3 record data
>
>How do you generate that record number in the result?
You can't do it in a single step, but you can with a subquery. Something like this, where the query that collects the data is the subquery:
SELECT RECNO() AS nPosition, * ;
FROM ( ;
SELECT * ;
FROM Products ;
ORDER BY ProductName) ProductsAlpha ;
INTO CURSOR ProductList
Tamar