Xojo Developer Conference
25/27th April 2018 in Denver.
MBS Xojo Conference
6/7th September 2018 in Munich, Germany.

Platforms to show: All Mac Windows Linux Cross-Platform

Previous items

SQLCommandMBS.Value(index as Integer) as SQLValueReadMBS
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method SQL MBS SQL Plugin 16.1 Yes Yes Yes Yes No
Function: Returns the value specified by its position in the result set.
Example:
dim c as SQLCommandMBS // your command object

// get field by name
dim f1 as SQLValueReadMBS = c.Value("FirstName")

// get field by Index
dim f2 as SQLValueReadMBS = c.Value(1)
Notes:
You can use Value() to get values for normal or cached result sets.

index: A one-based field number in a result set.

Use Value method to access a field by its name or position in the result set.
For Cached result sets, please use Value() function to get values.

Using an index smaller than 1 and greater then the value returned by FieldCount method will result in a failed assertion.

A set of SAField objects creates implicitly after the command execution if the result set exists. SAField object contains full information about a column: name, type, size, value.

See also:

Feedback, Comments & Corrections

SQLCommandMBS.Value(name as string) as SQLValueReadMBS
Type Topic Plugin Version macOS Windows Linux Console & Web iOS
method SQL MBS SQL Plugin 16.1 Yes Yes Yes Yes No
Function: Returns the value specified by its name in the result set.
Example:
dim c as SQLCommandMBS // your command object

// get value by name
dim f1 as SQLValueReadMBS = c.Value("FirstName")

// get value by Index
dim f2 as SQLValueReadMBS = c.Value(1)
Notes:
You can use Value() to get values for normal or cached result sets.

name: A string that represents a name of the requested field.

Returns a reference to a SAValueRead object.

Use Value method to access a field by its name or position in the result set.
Using a non-existent field name will throw an exception.

A set of SAField objects creates implicitly after the command execution if the result set exists.SAField object contains full information about a column: name, type, size, value.

See also:

Feedback, Comments & Corrections

Previous items

The items on this page are in the following plugins: MBS SQL Plugin.




Links
MBS FileMaker Plugins