Not all ODBC tables in for-each tabledef loop

[Phil5673]

Here's the situation - I am looping through the tabledefs in a database and re-linking tables. I have 2 ODBC linked tables in the database. The "For each td in database.tabledefs" loop is only showing me the 1st ODBC table.

Just for grins, I linked another ODBC table in and guess what? I get the first two now, but not the third.

This is where it gets weird: If I do a debug.Assert to stop the loop on my ODBC tables, it stops on all three.

Any suggestions?

 

[stix4t2]

Maybe you should revisit the code, even set debug.print statements in critical areas to trace the path. You must be doing some sort of test to see if the table is linked and not a system table. Is this code validation working properly?

 

[abaldwin]

Also what is the backend db type and who provided the odbc kit for them. Just curious at the moment.


Andy Baldwin

"Testing is the most overlooked programming language on the books!

 

[Phil5673]

I solved the problem. Refreshing the tabledefs in the loop keeps the problem from occuring.