>You can use local aliases.
> SELECT RECNO("Cust") AS CustRecNO, RECNO("Ord") AS OrdRecNo ;
> FROM customer Cust, order Ord;
> WHERE Cust.custid = "001" AND ;
> Ord.orderid < "999"
>Does that work for you?
Charlie,
Thanks for your reply.
I have not been able to make it work. What is selected as the RECNO() in each case is the record in customer or order what was initially being pointed to when the SELECT command was issued. For instance, if the pointer in customer.dbf was at record 100 and the pointer in order was at record 50 when you issued the SELECT command as above, you would get two columns as follows:
100 50
100 50
100 50
100 50
for as many records as were selected.
I may not be doing it right, but my code seems to be like your example.
regards,
Jim Edgar
Jurix Data Corporation
jmedgar@yahoo.comNo trees were destroyed in sending this message. However, a large number of electrons were diverted from their ordinary activities and terribly inconvenienced.