Platforms to show: All Mac Windows Linux Cross-Platform
RecordSet class
- method CloneMBS as RecordSet
This class has no sub classes.
See also in the Xojo Language Reference
Some useful global functions for this class:
- BuildRecordSetMBS(fieldNames() as string, values() as string) as RecordSet
- CloneRecordSetMBS(rec as RecordSet) as RecordSet
Some methods using this class:
- Database.SQLSelect(SelectString as string) as RecordSet
- SQLCommandMBS.AsRecordSet as RecordSet
- SQLConnectionMBS.SQLSelectAsRecordSet(command as string, CommandType as Integer = 0) as RecordSet
- SQLConnectionMBS.SQLSelectAsRecordSetMT(command as string, CommandType as Integer = 0) as RecordSet
- SQLDatabaseMBS.SQLSelect(SelectString as string, CommandType as Integer) as RecordSet
- SQLDatabaseMBS.SQLSelectMT(SelectString as string, CommandType as Integer = 0) as RecordSet
- SQLPreparedStatementMBS.SQLSelect(ParamArray bindItems as Variant) As RecordSet
- SQLPreparedStatementMBS.SQLSelectMT(ParamArray bindItems as Variant) As RecordSet
Release notes
- Version 24.0
- Added automatic rerun of SQL SELECT if you call MoveFirst on a RowSet/RecordSet, which doesn't support moving because it is not cached or scrollable.
- Version 21.1
- Added Edit/Update support for RecordSet for SQLDatabaseMBS class.
- Fixed issue with MoveFirst with RecordSet in our SQL Plugin when used with PostgreSQL.
- Version 20.2
- Changed SQLDatabaseMBS RecordSet to pass time, date and timestamp to Xojo with the right type, so Xojo can handle them correctly.
- Version 19.5
- Fixed a crash with empty RecordSet from CubeSQL crashing in debugger.
- Version 18.5
- Changed SQLDatabaseMBS to return RecordSet where you can query names of columns even if you have no rows.
- Version 18.3
- Improved SQLPreparedStatementMBS.SQLSelect to not return invalid RecordSet when SQL is invalid.
The items on this page are in the following plugins: MBS SQL Plugin.