Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Select recno() from table1, table2 (which table??)
Message
De
31/12/2001 08:26:54
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00599330
Message ID:
00599332
Vues:
18
From VFP Help:
RECNO([nWorkArea | cTableAlias])
Return Values
Numeric

Parameters
nWorkArea 
Specifies the work area number for a table open in another work area. RECNO( ) returns 0 if a table isn't open in the work area you specify. 
cTableAlias 
Specifies the table alias for a table open in another work area. 
Use cTableAlias parameter, e.g:
recno('receipt')
Better use:
Count(receipt.*) AS ReceiptRecNo
as for it is standart ANSI SQL syntax, and is not VFP specific - you will be able to upsize to other database with no query change.

Happy New Year!
Zlatin Zlatev,
MCSD (VS6)

Make solutions, not programs!

Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform