Platforms to show: All Mac Windows Linux Cross-Platform
SQLCommandMBS.Value(index as Integer) as SQLValueReadMBS
Function:
Returns the value specified by its position in the result set.
Example:
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.
| Type | Topic | Plugin | Version | macOS | Windows | Linux | Console & Web | iOS |
| method | SQL | MBS SQL Plugin | 16.1 | Yes | Yes | Yes | Yes | No |
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)
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:
SQLCommandMBS.Value(name as string) as SQLValueReadMBS
Function:
Returns the value specified by its name in the result set.
Example:
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.
| Type | Topic | Plugin | Version | macOS | Windows | Linux | Console & Web | iOS |
| method | SQL | MBS SQL Plugin | 16.1 | Yes | Yes | Yes | Yes | No |
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)
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:
The items on this page are in the following plugins: MBS SQL Plugin.
Links
MBS FileMaker blog
