function CountSQL(ASql : String) : Cardinal;

Class IKDBConnection

Execute a Count SQL Statement and return the value returned. Use an SQL Statement of the following form:

  select count(KeyField) from Table where conditions

The first column of the first set of data is returned as an integer. It's also possible to use sql such as

  Select max(KeyField) from Table


© Kestral Computing P/L 2000 - 2003. HL7Connect v2.00-063 generated on 30-Nov 2015.
Keywords: CountSQL