DB Object

The DB Object is a database object that provides the basic database access functionality.

You can create it in the scripting panel by right click -> data properties -> DB. After the DB object is created, typing "DB." Will reveal the following fly menu:

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

DB.DS

alias

clsid

csv_col_separator

csv_include_column_names

DB.GetFieldDefinition

DB.SetFieldDefinition

Examples:

You can set output table using two methods: setting the table name (assuming you are connected to a database) - (a) and setting the entire data source - (b):

If you are writing script outside TextConverter the API looks like this:

Set DS = TextConverter.GetOutputDS()

DS.table = "tablename" ) ‘- (a)

DS.SetDS( "c:\data\output.dbf" ) ‘- (b)

If you are writing script inside TextConverter it looks like this:

This.DSOut.table = "tablename" ) ‘- (a)

This.DSOut.SetDS( "c:\data\output.dbf" ) ‘- (b)

An Excel file is also considered as a database, so you can set the worksheet as:

Set DS = TextConverter.GetOutputDS()

DS.table = "worksheetname" ) ‘- (a)

DS.SetDS( "...\file.mdb:worksheetname" ) ‘- (b)

Back (Value Object) | Next (DBCreator Object)

Back (Objects and Methods)