Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to Show Table Name

Status
Not open for further replies.

alex20850

Programmer
Mar 28, 2003
83
US
I have created a BO universe.

I want to create a report that will list sample data.

As part of this report, I want to create a variable that will tell which table a field comes from.
 
There is basically no problem with working in the tablename into your object-names, thus doing away with an additional meta-data variable.

So, instead of 'Sales Quantity' define:

'SIL.Sales Quantity'

There are some custommade add-in's that produce a data-dictionary, but creating a variable that stores tablenames of all fields is AFAIK not possible.

Perhaps you can work out something by bringing in the SQL through the DataProviderSQL function.....

T. Blom
Information analyst
tbl@shimano-eu.com
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top