Smart Systems Software

Smart tools for smart developers

SmartData Data Dictionary ActiveX control description

When you add the SmartData control to your Visual Basic programming environment it is automatically added to the Objec Browser, where each and every routine in every object class is completely defined, along with custom data types and enumerations.

The SmartData object class consists of 1 property and 4 methods.

*

Property DatabaseDefinition

The DatabaseDefinition property is itself an object consisting of ADODB table, column and index collections (including primary key). It is readable and writable at run-time and supports standard ADODB methods and properties like Add, Remove, Count and Item.

*

Function CreateDatabase([SchemaFile], [SaveAsFile As String]) As ADODB.Connection

This method creates a database from either the DatabaseDefinition object or an optional schema text file.

SchemaFile - Either the name of a schema text file or TextStream object containg a valid database schema. If the SchemaFile argument is missing a database is created from the DatabaseDefinition property object.

SaveAsFile - Optional. Default file address is the database name and current directory

*

Sub CreateSchemaFile([DatabaseFile As String], [SaveAsFile As String])

This method creates a schema text file from a given DatabaseDefinition object or optional database file.

DatabaseFile - Optional. Name of an ADODB database file.

SaveAsFile - Optional. Default file address is the database title and current directory.

*

Function LoadDatabase(DatabaseFile As String) As DatabaseDefinition

This method loads the definition of a database into a DatabaseDefinition object.

DatabaseFile - The file name of the database to load.

*

Function LoadSchemaFile(SchemaFile) As DatabaseDefinition

This method loads the definition of a database schema text file into a DatabaseDefinition object.

SchemaFile - Either the name of a schema text file or TextStream object containing a valid database schema.