Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Network:
Windows 2003 Server
>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.
>
It's reliable in queries involving a single table, as long as you don't put the alias inside the function call. It's not reliable in a multi-table query.
Generally, the best solution is to use one query (or a derived table in a larger query) to add the recno to the original data, and then another query (or a containing query) to pull the data you need including the recno into the result.
Tamar
Précédent
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