   Item
   DataBase
   Schema
   SchemaLoad

   ClassSchema
   ItemCollection
   PropertyCl
   PropertyCollection
   PropertyRule
   PropertySchema
   RulesCollection

About Us

This site in:
English Spanish Portuguese	German French Italian

NEWS ALERT: Western Australia Police installs 5 Clicks in all its stations! Now 5 Clicks will be helping Police to catch criminals.

Database

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.

Home

Web RAD

Administration Console

Databases

Object Model

Samples

Q&A

Download (Free!)

Screen Capture

@Start page

Session Server

About Us

Database

Properties

Methods