SQLreadstring


Purpose
Read a string from a database.
Synopsis
function SQLreadstring(s:string|text):string
function SQLreadstring(s:string|text,p:list):string
Arguments
SQL command for selecting the string to be read
A list of SQL parameters
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:=SQLreadstring(
       "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.
3. The second argument can be used to specify SQL parameter values if the SQL query contains parameter markers.
Related topics
SQLexecute, SQLreadinteger, SQLreadreal.
Module
mmodbc


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.