Re: Item Revision: finding the latest / current revision (w/o using MAPICS current revision calculation routines)
"Tom E Stieger" <testieger-7y5+ka1ulstWk0Htik3J/[email protected]>
| Newsgroups | gmane.comp.systems.as400.mapics |
|---|---|
| Message-ID | <[email protected]> |
Peter- Can you use the GETCURRVA function (I'm not sure if that is available in r6)? If you need to get the current revision as it was in 2007 - 2008 then it shouldn't be that hard to use System I Navigator's "explain SQL" on the function to get the source then modify it with a date parameter and rename it something useful. This could then be used in your query tool if allowed or used to create the desire temporary table or view as applicable to your needs. -Tom Stieger IT Manager California Fine Wire -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of [email protected] Sent: Tuesday, March 27, 2012 5:30 AM To: [email protected] Subject: [MAPICS-L] Item Revision: finding the latest / current revision (w/o using MAPICS current revision calculation routines) Good morning / afternoon: Have the need to determine the latest / current revision for the Item Rev A and also B files. However, these are files from 2007 and 2008. Our user needs to use them in query reports. There might be a simple solution but is better to ask the question than never asking the question: what can I do to get a file with unique item revision records in a separate file? TIA, PETER VIDAL PALL CORPORATION SR System Analyst | WH Application Development 10540 Ridge Rd., Suite 203, New Port Richey, FL 34654-5111 UC#: 262-2414 | Direct: 727-844-2414 | Fax: 727-815-3120 | www.pall.com "When a man's knowledge is not in order, the more of it he has the greater will be his confusion." Herbert Spencer (1820 – 1903) -------------------------------------------------------------------------------- Attention: This communication may contain information that is confidential, privileged and/or exempt from disclosure under applicable law. If you are not the intended recipient, please notify the sender immediately and delete the original, all attachments, and all copies of this communication. -------------------------------------------------------------------------------- _______________________________________________ This is the MAPICS ERP System Discussion (MAPICS-L) mailing list To post a message email: [email protected] To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/mapics-l or email: [email protected] Before posting, please take a moment to review the archives at http://archive.midrange.com/mapics-l.