Navigation:  ThinBASIC Modules > ADODB > ADODB Module Classes > ADODB_Connection > ADODB_Connection Methods >

<ADODB_Connection>.LookUp

Previous pageReturn to chapter overviewNext page

 

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

Yes

A valid SQL statement that return a recordset

sFieldName

String

Yes

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