Do not let any software impress you!

Only let it convince your intellect.
Slider img 1
Do not look for a business paradise!

It is a waste of time.
Slider img 2
Only yourself can push you uphill.

There is no easy road to prizes.
Slider img 3
Productivity is the name of the game.

And you have to conquer it.
Slider img 4
As long as you understand it,

you will start to build your know-how.
Slider img 5
We can help with that.

We have the tools and the method.
Slider img 6

Enumearte Tables in another Database



Here is an example of AutoScript about enumerating the tables that exist in another database.

con_str = “Provider=Microsoft.Jet......“ {....define the connection string}
con = OpenDBConnection(con_str) {....connect to database and return handler}
tlist = GetDBConnTableNames(con) {....load the table names into a list}
tcount = GetLstCount(tlist) {....enumerate the items in the list (tables)}
for i = 0 to tcount-1
     tname = GetLstItem(tlist,i)                     {....get table name of (i)th list item}
     call trace(“tname=“,tname)                     {....write to kosmos*.log for latter inspection}
next
call CloseDBConnection(con) {....close and free the database connection}
call FreeLst(tlist) {....free the list with table names}