SQLreadinteger

Purpose

Read an integer value from a database.

Synopsis

function SQLreadinteger(s:string|text):integer

function SQLreadinteger(s:string|text,p:list):integer

Arguments

s	SQL command for selecting the value to be read
p	A list of SQL parameters

Return value

Integer value read or 0.

Example

The following gets the article number of the first data item in table pricelist for which the field color is set to blue:

i:=SQLreadinteger(
       "select articlenum from pricelist where color=blue")

Further information

1. 0 is returned if no integer value can be found.

2. If the given SQL selection command does not denote a single value, the first value to which the selection criterion applies is returned.

3. The second argument can be used to specify SQL parameter values if the SQL query contains parameter markers.