We are using the following line


FOR i = 1 to ADBOBJECTS(laTables, "Table")
....
EndFor

This is called for three separate Databases, and works fine for two of them. however when it hits the third, it fails.

I wrote the following to try to figure out whats going on:

Local T_list[1], x
cdb = DBC()
x=ADBOBJECTS(T_list, "Table")

Wait Window "In DB "+ cdb+ "alen T_list is "+ STR(Alen(T_list))+" X="+STR(x)

The Wait window shows me this

IN DB master alen T_list is 1 X=0

Now it's in the correct database, but after the adbobjects line
alen(t_list) and x should both equal 11, the number of tables I have in the master database. The main differnce between the Master.dbc, and the other two dbc files is that master containes both views and tables, were the other two only contain tables.

Has anyone else seen a problem like this or have suggestions on how to get around it?

Thanks in advance.
Nancy