OCIreadstring

Purpose

Read a string from a database.

Synopsis

function OCIreadstring(s:string|text):string

Argument

s	SQL command for selecting the string to be read

Return value

String read or empty string.

Example

The following retrieves the color of the (first) data item in table pricelist with article number 1004:

s:=OCIreadstring(
       "select color from pricelist where articlenum=1004")

Further information

1. The empty string is returned if no real value can be found.

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