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 gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Progression SQL 7.6.3c Changing "C"- Closed POs to "H"- Hist

Status
Not open for further replies.

ultrav

Technical User
Jun 12, 2001
151
US
I would like to mass change the majority of our P.O.s from "C" to "H". I ran a SQL trace but I have only used that one other time so I am having a hard time reading it. Does anyone know what tables and fields are affected by making this change?

Thanks for your help.

Celeste
 
poordhdr, poordlin, pohdraud & polinaud are the only files affected.

There is a very cool tool called SQL Delta which I use instead of SQL trace for this kind of work, very reasonable too at $225 --
Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

"making predictions is tough, especially about the future" - Yogi Berra
 
A simple Crystal report on the sysobjects and syscolumns (in SQL) will list all of the Macola tables/fields. The two tables are linked on 'id'. Table names are in sysobjects.name and field names are in syscolumns.name. Group your report by the table name.

You can use wildcard selection criteria on the field names to find all tables containing that value.

Peter Shirley
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top