SQLreadreal

Purpose

Read a real value from a database.

Synopsis

function SQLreadreal(s:string|text):real

function SQLreadreal(s:string|text,p:list):real

Arguments

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

Return value

Real value read or 0.

Example

The following returns the price of the data item with index 2 in table newtab:

r:=SQLreadreal("select price from newtab where ndx=2")

Further information

1. 0 is returned if no real 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.