SetDS

Description

Initializes the data source object from another data source object or from a string.

Syntax

Function SetDS( ds )

Parameters

variant ds  - the datasource prototype

string - a file path to the database resource for file based databases; 

object - an initialized DS object from which to copy the settings

Return Values

none

Examples

You can set output table using two methods:

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)

Additional examples:

'Sample 1

DS.SetDS( ds1 ) 'ds1 - pre initialized data source object

'Sample 2

DS.SetDS( "c:\data\access.mdb" )

DS.table = "Table1"

'Sample 3

DS.SetDS( "c:\data\input.csv" )

See also

GetAsString

DS