trevorfuller
13 years agoNew Contributor
Compare a DBTable who's name is stored in a variable
I have a file in my Files store and a DB table in my DBTables store. I have a small test (ODT) that uses an app to import the file and compare it to the database (DBTables object called "storetable1")
The compare works fine if I do:
DBTables.storetable1.compare
I now want to run this routine multiple times, doing an import and compare with different pairs of input file and stored table. I've set up an ODT classes and methods with two variables; one to store the file name and one to store the DBTable name.
I can import the file ok using Files.FileNameByName(This.storesFileName)
But I can't find a way of doing the DBTable compare using a table name that is stored in a variable.
Any suggestions would be appreciated (VBScript)
Cheers,
Trev.
The compare works fine if I do:
DBTables.storetable1.compare
I now want to run this routine multiple times, doing an import and compare with different pairs of input file and stored table. I've set up an ODT classes and methods with two variables; one to store the file name and one to store the DBTable name.
I can import the file ok using Files.FileNameByName(This.storesFileName)
But I can't find a way of doing the DBTable compare using a table name that is stored in a variable.
Any suggestions would be appreciated (VBScript)
Cheers,
Trev.