>Hi
>
>When you use recno() in select statements, is it reliable?
>
>In some old Fox2.6 apps we have duplicate keys and I need to differentiate between them.
>
>Thanks
>Kev
Kevin,
There is a high level of reliability but not enough to cover all cases (even works with joins provided you really know what you're doing but we are not always carefull in coding to remember slight nuances - so accept unreliable if used with joins).
You can still have your recno() from those tables if you use multiple SQL. ie:
select recno() as t1recno, * from table1 into cursor crs1 nofilter
select recno() as t2recno, * from table2 into cursor crs2 nofilter
* now work with cr1,crs2
However you're saying "keys" and you might not need recno() at all.
Cetin