Object Reference

Classes
Command Interface
- xf_Command
External
- xf_External_VB6_32bit
- xf_External_VB7_32_64bit
General
System Core
System Library

xf_ScripterSQL Script Generation and Processing

Public Sub CreateTableCreateScript (
dbs As DAO.Database,
ReturnScript1 As String,
ReturnScript2 As String,
TableName As String,
Optional WithDrop As Boolean = False,
Optional WithIndexes As Boolean = False,
Optional WithRelations As Boolean = False,
Optional WithFieldProps As Boolean = False,
Optional WithTableProps As Boolean = False,
Optional SuppressColWidthProp As Boolean = False
)

Process an individual SQL command or statement This is not recommended for external use - pass the command to ProcessScript

dbs as DAO.Database

The database object to generate the script against

ReturnScript1 as String

The generated script for table, column, index and primary key creation

ReturnScript2 as String

The generated script for relationship creation

TableName as String

The name of the table to create

Optional WithDrop as Boolean = False

Generate a DROP TABLE statement before the CREATE TABLE statement

Optional WithIndexes as Boolean = False

Generate the index creation SQL

Optional WithRelations as Boolean = False

Generate the relationship creation SQL

Optional WithFieldProps as Boolean = False

Generate the column/field properties creation SQL

Optional WithTableProps as Boolean = False

Generate the table-level properties creation SQL

Optional SuppressColWidthProp as Boolean = False

(no description)

Call Template:

xf.Scripter.CreateTableCreateScript dbs, ReturnScript1, ReturnScript2, TableName

xf.Scripter.CreateTableCreateScript dbs, ReturnScript1, ReturnScript2, TableName, WithDrop, WithIndexes, WithRelations, WithFieldProps, WithTableProps, SuppressColWidthProp

Example 1:

Set recs = xf.DbConnect.OpenDAORecordset("xf_tblErrorLogLocal")
WereErrors = Scripter.ProcessScript(sqlStr, dbs, cn, recs, "Test Script")