Re: Changing of Item Numbers

Stephen,

We have an entire library dedicated to just this task. I'm ashamed,
however, of how we do it. We do the research with a package like Hawkeye.
Then we write a program for each file and a CL to call each program. It's
been that way for 10 years.

Now, I'm thinking that if you did the research up front and created a DB
file containing the file,library,fieldname to be changed and looped through
that file and dynamically created and executed an SQL statement based on
the data in the file. That would make it a little more dynamic.

Good Luck,

Mark



Mark Walter
Sr. Programmer/Analyst
Hanover Wire Cloth a div of CCX, Inc.
mwalter@hanoverwire.com
http://www.hanoverwire.com
717.637.3795 Ext.3040


                                                                                
                                       
                    "Shurge, Stephen                                            
                                       
                    (MTL)"                   To:     "'MAPICS-L@midrange.com'" 
<MAPICS-L@midrange.com>                 
                    <sshurge@recochem        cc:     "Shurge, Stephen (MTL)" 
<sshurge@recochem.com>                    
                    .com>                    Subject:     Changing of Item 
Numbers                                     
                    Sent by:                                                    
                                       
                    owner-mapics-l@mi                                           
                                       
                    drange.com                                                  
                                       
                                                                                
                                       
                                                                                
                                       
                    07/13/01 01:09 PM                                           
                                       
                    Please respond to                                           
                                       
                    MAPICS-L                                                    
                                       
                                                                                
                                       
                                                                                
                                       





I am looking to see if anyone has developed a way of changing one item
number to another item number throughout the entire
Mapics database.

If anyone has a list of all the fields and files that need to be changed
would be a good starting point.

I have a cross referencing utility (Hawkeye) that I can use to help me but
would sooner use a proven method if available.


Steve Shurge
Recochem Inc.
850 Montee de Liese
Montreal, Quebec
H4T 1P4
Phone # 514 341 3550 ext 2655
Fax #     514 341 1292
Email :  sshurge@recochem.com

+---
| This is the MAPICS Mailing List!
| To submit a new message, send your mail to MAPICS-L@midrange.com.
| To subscribe to this list send email to MAPICS-L-SUB@midrange.com.
| To unsubscribe from this list send email to MAPICS-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator:
daveshaw@bellsouth.net
+---




+---
| This is the MAPICS Mailing List!
| To submit a new message, send your mail to MAPICS-L@midrange.com.
| To subscribe to this list send email to MAPICS-L-SUB@midrange.com.
| To unsubscribe from this list send email to MAPICS-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: 
|daveshaw@bellsouth.net
+---