Initializing help system before first use

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.
Related topics
SQLexecute, SQLreadinteger, SQLreadstring.
Module
mmodbc

Parent Topic Procedures and functions

© 2001-2025 Fair Isaac Corporation. All rights reserved. This documentation is the property of Fair Isaac Corporation (“FICO”). Receipt or possession of this documentation does not convey rights to disclose, reproduce, make derivative works, use, or allow others to use it except solely for internal evaluation purposes to determine whether to purchase a license to the software described in this documentation, or as otherwise set forth in a written software license agreement between you and FICO (or a FICO affiliate). Use of this documentation and the software described in it must conform strictly to the foregoing permitted uses, and no other use is permitted.