SiMX Help‎ > ‎The Target Platform‎ > ‎Objects‎ > ‎

DBCreator Object


Platform Objects


Data Object Creator - provides the same functionality as the data object (follow the link for the methods) along with additional user interfaces to define a structure for the new table.  Use this object to output your conversion results to multiple tables.  Use the main output data source for the first table then make Data Object Creator variables for each additional table.  If you have sufficient rights to the database, this object will create the required tables if they do not already exist.  New data is appended unless you select the option to truncate the table before each output. 

The DBCreator object is made in the script panel: right click -> Data properties -> DBCreator. Typing "DBCreator." will reveal the following fly menu:

Please select a property or method below to learn more about it:

DBCreator.DS
alias
clsid
csv_col_separator
csv_include_column_names
csv_positional
csv_text_qualifier
database
dsn
extension
password
schema
table
user
valid
CallFunction
CallProcedure
Create
Drop
Execute
Format
GetAsString
GetCustomSelect
GetFieldNames
GetFrom
GetRelation
GetTableNames
LoadFields
ReplaceTable
SetCustomSelect
SetDS
SetParam
TableExists

DBCreator.group
summary
Get
Remove
Set
ShowTotals

DBCreator.scope
distinct
Get
HasSyntaxCheck
Join
MakeCondition1
MakeCondition2
Modify
Set

DBCreator.sort
Add
Flush
Get
Modify
Remove
Replace
Set

DBCreator.AddField
DBCreator.AppendFinish
DBCreator.AppendStart
DBCreator.Clone
DBCreator.Close
DBCreator.CopyRecord
DBCreator.CopyTo
DBCreator.Create
DBCreator.DeleteRecords
DBCreator.Find
DBCreator.FlushFields
DBCreator.GetFieldComment
DBCreator.GetFieldCount
DBCreator.GetFieldDefinition
DBCreator.GetFieldName
DBCreator.GetFieldNames
DBCreator.GetFieldType
DBCreator.GetFieldValue
DBCreator.GetRecordCount
DBCreator.GetRecordNumber
DBCreator.GetStatistics
DBCreator.GetTopN
DBCreator.GetValues
DBCreator.GetVisible
DBCreator.GoBottom
DBCreator.GoNext
DBCreator.GoPrevious
DBCreator.GoRandom
DBCreator.GoTop
DBCreator.IsFieldEmpty
DBCreator.Select
DBCreator.SetFieldDefinition
DBCreator.SetFieldFormat
DBCreator.SetFieldLen
DBCreator.SetFieldName
DBCreator.SetFieldValue
DBCreator.SetRecordID
DBCreator.SetTopN
DBCreator.SetVisible
DBCreator.TransactionFinish
DBCreator.TransactionStart
DBCreator.UpdateFinish
DBCreator.UpdateFinishASync
DBCreator.UpdateStart

Back (DB Object) | Next (DS Object) 



Back (Objects and Methods)