xf_ScripterSQL Script Generation and Processing

Offer script generation for schema and data, and extend native JET DDL to make it useful
- script table schemas, queries, data INSERTs and UPDATEs
- add the missing features to JET DDL by pre-processing commands
- useful library functions for schema operations

Module Sections:

• Core Properties
• Enhanced SQL command processing
• Enhanced SQL script generation
• Type Conversions
• Useful schema related functions

Alphabetical List of Methods:

• AllowZeroLengthMode(Core Properties)
• ConstraintIsRelation(Useful schema related functions)
• CreateBinaryUpdateStatement(Enhanced SQL script generation)
• CreateDummyInsertStatement(Enhanced SQL script generation)
• CreateInsertStatement(Enhanced SQL script generation)
• CreateTableCreateScript(Enhanced SQL script generation)
• CreateUpdateStatement(Enhanced SQL script generation)
• DbTableDelete(Useful schema related functions)
• DeleteTableIndexesContainingColumn(Useful schema related functions)
• ErrorString(Core Properties)
• FieldHasFkRelation(Useful schema related functions)
• FixAutonumberCol(Useful schema related functions)
• GetAutonumberColName(Useful schema related functions)
• GetFieldDDLTypeName(Type Conversions)
• GetFieldStatsFromDDLTypeName(Type Conversions)
• GetFieldValidDefaultVal(Type Conversions)
• GetTableColList(Useful schema related functions)
• GetTablePrimaryKeyColNameCollection(Useful schema related functions)
• GetTablePrimaryKeyColNameList(Useful schema related functions)
• IndexContainsField(Useful schema related functions)
• IndexFieldList(Useful schema related functions)
• IsFieldTextType(Type Conversions)
• LogString(Core Properties)
• PreProcessModeOn(Core Properties)
• PrintTabledefs(Enhanced SQL script generation)
• ProcessScript(Enhanced SQL command processing)
• ProcessSQLCommand(Enhanced SQL command processing)
• RelationContainsField(Useful schema related functions)
• RelationFieldList(Useful schema related functions)
• RunODBCSql(Enhanced SQL command processing)
• ScriptZeroModeSetting(Enhanced SQL script generation)
• SqlFormatFieldVal(Enhanced SQL script generation)
• SummaryLog(Core Properties)
• TableColumnInPrimaryKey(Useful schema related functions)
• TableIsAccessLinked(Useful schema related functions)
• TurnOffSubDataSheets(Useful schema related functions)
• ZeroLengthStringKeyword(Core Properties)