Recover SQL string from a previous DatabaseDataSourceSettings

[Janine Rawnsley 4]

Hello

When we useDatabaseDataSourceSettings to create a new DatabaseDataSource, how might we get these settings again in future from the created data table

I need to be able to retrieve the SQL to inject a WHERE / remove the WHERE dynamically.

e.g.

tableName = "theTable"

connString = "Dsn=MyDSN;Uid=111;Pwd=222";

# Dynamic SQL here...

sql = "SELECT * FROM someTablelimit 100;"

dbSettings=DatabaseDataSourceSettings("System.Data.Odbc",connString,sql,True)

ds=DatabaseDataSource(dbSettings)

 

dt = getDataTable(tableName);

if dt != None:

# Table exists already

print "Replacing table..."

dt.ReplaceData(ds)

 

dtds = DataTableDataSource(dt)

print dtds.Name

print dtds.Settings.