RE: PREFIX RECORD NO: IN A SELECT STATEMENT

> >
> > No, I assumed that's a field name in your table since you included this column in the table in your original question.
> > --
> > Eric den Doop
> > www.foxite.com - The Home Of The Visual FoxPro Experts
>
>
> Can the

RECNO()

be used in a

select

statement?

Yes and no.
Yes you can use it as long as the select is done from a single table.
No, you can't when there are joins and the VFP version is 6. In that case you might first do individual selects per table in the join adding recno() as a field. ie:

select recno() as CustRow, * from customer into cursor rowCustomer nofilter
select recno() as OrderRow, * from orders into cursor rowOrders nofilter
select * from rowCustomer inner join rowOrders on rowCustomer.cust_id = rowOrder.cust_id

Cetin Basoz