reading table names from the database.

[arindam2228]

I am currently working on a short project on using Excel macros to automate the universe documentation and population in Business Objects 6.5 . To check the entry of a table name which is not existing in the specified database, i need to read the database table names. this is not a problem if my universe is populated but for an empty universe with only the database connection specified, how is it possible to read the table names ?

Arindam.

[vijaydiwakar]

I am currently working on a short project on using Excel macros to automate the universe documentation and population in Business Objects 6.5 . To check the entry of a table name which is not existing in the specified database, i need to read the database table names. this is not a problem if my universe is populated but for an empty universe with only the database connection specified, how is it possible to read the table names ?

Arindam.

which is thyn back end if it is oracle then select tname from tab check recordset with the name u like to check and proceed

[arindam2228]

which is thyn back end if it is oracle then select tname from tab check recordset with the name u like to check and proceed

not clear as to what property of bo designer will help me write the vba code for the macro.could u elaborate? not just for oracle but even for the others.

[arindam2228]

okay, let me brief on the proceedings. i am trying to feed details such as table, class, object, joins, context, etc. to an empty universe in Business Objects 6.5 which has only it's connection defined. the connection may be to any type of database. what i want is to verify the table name as read from the excel sheet is one which exists in the database.... or else, a false table is created. that is where i need to compare the table name with those in the database.
any way out of this problem?

[Geoff]

I'm not sure if this is what your meaning, but are you using the Data control to link the application and database?

If you are, then can't you just do...

Form1.Caption = Data1.RecordSource

[arindam2228]

I'm not sure if this is what your meaning, but are you using the Data control to link the application and database?

If you are, then can't you just do...

Form1.Caption = Data1.RecordSource

thanks for the help.i'll try it out. thanks again.