OCIreadinteger


Purpose
Read an integer value from a database.
Synopsis
function OCIreadinteger(s:string|text):integer
Argument
SQL command for selecting the value to be read
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:=OCIreadinteger(
       "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.
Related topics
OCIexecute, OCIreadreal, OCIreadstring.
Module
mmoci


If you have any comments or suggestions about these pages, please send mail to support@fico.com.

© Copyright 2001-2013 Fair Isaac Corporation. All rights reserved.