| |
Database has native DB3NF methods Find and All and several generic methods for database access
that can be used to run custom stored procedures and SQL statements where the use of DB3NF methods is not efficient.
| Database |
|---|
 | All(Class) |
 | CommandTimeout |
| Execute(SQL) |
| Find(Class, PropertyName,Value) |
| Procedure(StoredProcedure, [Parameters()]) |
| ProcedureNoRec(StoredProcedure, [Parameters()]) |
| SchemaObj |
Properties
| Name |
Data Type |
Parameters |
Comments |
| CommandTimeout |
Long |
NA |
Command Timeout as in ADO |
| SchemaObj |
Schema |
NA |
|
Methods
| Name |
Return Value |
Parameters |
Comments |
| All |
ItemCollection |
Class (name) |
Return Collection of all Items of the specified class. |
| Find |
see Comments |
Class (name), PropertyName, Value (of the property) |
Returns Item if the property the search is for has been specified in
Schema as unique.
Otherwise, ItemCollection is returned. |
| Execute |
ADODB.Recordset |
SQL (statement) |
Executes any T-SQL statement for the "Data" database. |
| Procedure |
ADODB.Recordset |
StoredProcedure, optional list of Parameters |
Executes any stored procedure in the "Data" database that returns a recordset. |
| ProcedureNoRec |
Long |
StoredProcedure, optional list of Parameters |
Executes any stored procedure in the "Data" database that returns no recordsets.
Method returns procedure return value. |
|
