Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Select recno() from table1, table2 (which table??)
Message
From
31/12/2001 08:26:54
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00599330
Message ID:
00599332
Views:
17
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!

Previous
Next
Reply
Map
View

Click here to load this message in the networking platform