× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



Using SQL to do much more than update a field such as ITEM CLASS is a bad idea. I have had customers try it and regret it. It is hard to fully understand what a programmer has set up under the covers and will not get executed by coming in the back door.

Sent from my Verizon Wireless Phone
Richard (Dick) Stover
Guide Technologies
215-499-8530

-----Original message-----
From: Tom E Stieger <testieger@xxxxxxxxxxxx>
To: MAPICS ERP System Discussion <mapics-l@xxxxxxxxxxxx>
Sent: Mon, Feb 6, 2012 20:17:00 GMT+00:00
Subject: Re: [MAPICS-L] LTPUR not recalculated after changing ITEMBL with SQL

I've run into a similar problem with updating files via SQL. The Online
Knowledge base suggested running a XA reorg which would recalculate the
field in question (NOOPS in the FACMST file). For our specific case it
didn't work because it was not updated to recalculate that field in an
EPDM environment. I ended up just calculating the field myself and
updating it through SQL as well.

All the warnings and caveats per Kevin Fox's reply pertain as well.


-Tom Stieger
IT Manager
California Fine Wire



-----Original Message-----
From: mapics-l-bounces@xxxxxxxxxxxx
[mailto:mapics-l-bounces@xxxxxxxxxxxx] On Behalf Of Bryan Burns
Sent: Monday, February 06, 2012 6:02 AM
To: mapics-l@xxxxxxxxxxxx
Subject: [MAPICS-L] LTPUR not recalculated after changing ITEMBL with
SQL

In an XA5.5 test environment, I updated LTVEN and LTSAF using SQL; but
LTPUR has not been re-calculated for those items I updated.

I went into ITEMBL file maintenace on a record and I was able to get it
re-calculated that way.

Two questions:

1. This was my first accomplishment using SQL to do an update and I'd
like to know if I did any damage, and what other file/fields can be
damaged with even the most careful use of SQL?

2. How can I automagically get the LTPUR recalculated for about 130
records?
_______________________________________________
This is the MAPICS ERP System Discussion (MAPICS-L) mailing list To post
a message email: MAPICS-L@xxxxxxxxxxxx To subscribe, unsubscribe, or
change list options,
visit: http://lists.midrange.com/mailman/listinfo/mapics-l
or email: MAPICS-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at
http://archive.midrange.com/mapics-l.

_______________________________________________
This is the MAPICS ERP System Discussion (MAPICS-L) mailing list
To post a message email: MAPICS-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/mapics-l
or email: MAPICS-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/mapics-l.


As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.