tables field in temp tables in reports in GP 8.0

[BHAT100]

Is there any way to know what table fields are used in temp tables and script used to populate the temp table to generate report

Thanks

-bhat

 

[winthropdc]

Only by looking at the Dexterity Source code or sometimes a stored procedure, if one is used.

You can try creating a DEXSQL.LOG to see the commands, but that will not work if the TEMP table is a local ctree table. You can check the type of TEMP by opening the table definition in Report Writer and look at the Database Type field. Default or SQL will be created on SQL server, ctree will be created in the local Workstations TEMP folder.

David Musgrave [MSFT]
Senior Development Consultant
Escalation Engineer
MBS Support - Asia Pacific

Microsoft Business Solutions

http://www.microsoft.com/BusinessSolutions

Any views contained within are my personal views and
not necessarily Microsoft Business Solutions policy.
This posting is provided "AS IS" with no warranties,
and confers no rights.