Please enable JavaScript to view this site.

R:BASE 11 Help

Navigation: Function Index > C > CVAL

ROWCOUNT

Scroll Prev Top Next More

(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