Skip to main content

Number of records in sql table

  • June 7, 2013
  • 1 reply
  • 0 views

Andreas Weinand
Forum|alt.badge.img+2

Hi,

we are working with AcuSQL and to show a progress bar we need to know how many records a sql table contains.

Any ideas ?

1 reply

Hi,

we are working with AcuSQL and to show a progress bar we need to know how many records a sql table contains.

Any ideas ?

You should be able to use the COUNT(*) function in an SQL query:

       EXEC SQL
           select count(*) into :row-count from table_name
       END-EXEC