Extract

This function will extract from a recordset the one value at the specified column and row. A specific column and row intersect at a single value.

Group: Database Related Extensions

Syntax:

vValue = DB.Extract(sColumns, sRows, iRecNo, vFieldNo)

vValue (Variant) is the value extracted. (Note: this will always be a string value regardless of the actual field's data type.)

sColumns (String) is the string variable used to hold the list of columns in the DB.Execute command.

sRows (String) is the string variable used to hold the rows of data in the DB.Execute command.

iRecNo (Integer) is the row number within the retrieved recordset to extract data from.

vFieldNo (Variant) is the column number (numeric), or column name (String) within the retrieved recordset to extract data from.

Example:

Dim sSQL As String

Dim sCols As String

Dim sRows As String

Dim sPart As String

sSQL = "select * from ItemMaster"

DB.Execute(sSQL, sCols, sRows)

sPart = DB.Extract(sCols, sRows, 1, "PartNo")