(CVAL('ROWCOUNT'))
Assigns line numbers for SELECT command output.
Example:
SELECT (INT(CVAL('ROWCOUNT'))) AS LineNo,Company=40 FROM Customer
LineNo Company
---------- ----------------------------------------
1 RAM Data Systems, Inc.
2 Johnson Technologies
3 MIS by Design
4 Barton & Associates
5 The Data Shop
6 Microcomputer Distribution
7 Bytes & Words
8 Lanufacturers Discount Computers
9 Modular Software, Inc.
10 Open Systems I/O
11 Data Solutions
12 Compumasters Computer Supply
13 Datacrafters Infosystems
14 Olympic Sales
15 State University
16 Computer Medical Ctr.
17 Microtech University - II
18 Softech Database Design
19 Compdat Computer Consulting
20 Nordan Distributors, Inc.
21 Midtown Computer Co.
22 Computer Warehouse - II
23 PC Consultation And Design
24 Industrial Concepts Inc.
25 Computer Mountain Inc.
26 Industrial Computers Inc.
27 Microtech University - I
28 Computer Warehouse - I