Information générale
Catégorie:
Codage, syntaxe et commandes
This is a kludge but it works. Except in the case of a select from only one table, there is no way to get the correct recno(). Try this, however:
select *,recno() as rn1 from table1 into cursor tabl1
select *,recno() as rn2 from table2 into cursor tabl2
...
...
...
Now do the same multiple table select as you would have only using tabl1, tabl2, etc. rather than the original tables. The resulting cursor/table will have the correct record numbers from the base tables as rn1, rn2, etc.
HTH
>Is there any way to have SELECT selects RECNO()? TO make it harder I have more then one table in this SELECT statement.
>TIA Mark
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement