Online Documentation - Statistics - FAQ - Plugin Parts (All, Dependencies) - Class hierarchy
New in Version 22.2 22.3 22.4 22.5 23.0 23.1 23.2 23.3 23.4 23.5 24.0 24.1
The list of the topics, classes, interfaces, controls, modules, global methods by category, global methods by name, screenshots, licenses and examples.
Platforms to show: All Mac Windows Linux Cross-Platform
Type | Topic | Plugin | Version | macOS | Windows | Linux | iOS | Targets |
class | SQL | MBS SQL Plugin | 9.3 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | All |
The plugin can cache the recordset locally. To enable you can call SQLCommandMBS.Cache or use the Option("AutoCache") = "true" on either command or connection or database objects. The plugin will than fetch all records and store them in memory. After this you can walk over the recordset and use FetchPos, FetchFirst, FetchLast, FetchPrev and FetchNext to locate the rows you need. When you call Field() you always get last row, but to read from cached result set, please use Value() function. When using RecordSet, the values are read via Value() functions automatically.
see also
https://www.sqlapi.com/ApiDoc/class_s_a_command.html
Constant | Value | Description |
---|---|---|
kOptionPreFetchRows | "PreFetchRows" | One of the option constants. Example |
kParamDirTypeInput | 0 |
One of the parameter direction type constants.
Input parameter. |
kParamDirTypeInputOutput | 1 |
One of the parameter direction type constants.
Input/output parameter. |
kParamDirTypeOutput | 2 |
One of the parameter direction type constants.
Output parameter. |
kParamDirTypeReturn | 3 |
One of the parameter direction type constants.
Returning parameter. |
Constant | Value | Description |
---|---|---|
kCommandTypeSQLStatement | 1 |
Command is an SQL statement. |
kCommandTypeSQLStatementRaw | 2 |
Command is an SQL statement that mustn't be interpreted by SQLAPI. |
kCommandTypeStoredProcedure | 3 |
Command is a stored procedure or a function. |
kCommandTypeUnknown | 0 |
Used by default. Library detects command type automatically. |
This class has no sub classes.
The items on this page are in the following plugins: MBS SQL Plugin.