General information
Category:
Coding, syntax & commands
Title:
Adbojects doesn't reference Tables properly in a database
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only