|
<< Click to Display Table of Contents >> Navigation: ThinBASIC Modules > ADODB > ADODB Module Classes > ADODB_Connection > ADODB_Connection Methods > <ADODB_Connection>.LookUp |
Description
Execute an SQL statement that generate a recordset and return value of a specific field.
Syntax
s = <ADODB_Connection>.LookUp (sSQL, sFieldName)
Returns
String.
Parameters
Name |
Type |
Optional |
Meaning |
sSQL |
String |
No |
A valid SQL statement that return a recordset |
sFieldName |
String |
No |
Name of a field generated by sSQL statement parameter |
Remarks
This function is not a standard ADODB function but a personalized thinBasic function.
It was designed because very often, when handling data from a DB, it is necessary to lookup just one value giving a SQL statement.
Instead to instantiate an ADODB_Recordset to just do one lookup, use this function.
Restrictions
See also
Examples