OCIreadreal

Purpose

Read a real value from a database.

Synopsis

function OCIreadreal(s:string|text):real

Argument

s	SQL command for selecting the value to be read

Return value

Real value read or 0.

Example

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

r:=OCIreadreal("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.