Re: MAPICS-L Digest, Vol 10, Issue 12 - For Bryan Burns from Mike Ellis / ISI

Mike,
Don't trouble yourself. I worked it out and it was simply:
update amflibe/itembl
set ltpur = (LTVEN+LTSAF)
where house = 1
and vndnr = '900155'
(the last two lines not being completely necessary).

Regards,

Bryan




On Tue, Feb 7, 2012 at 8:17 AM, <[email protected]> wrote:

> Mike,
> I'd very much appreciate the syntax for setting the LTPUR.
> Thanks!
> Bryan
>
>
>
> On , Michael Ellis <[email protected]> wrote:
> > Bryan,
> >
> >
> >
> >
> >
> > You learned a valuable lesson without paying much for it.
> >
> >
> >
> >
> >
> > Be VERY cautious about updating MAPICS tables with SQL.   It can be
> done,
> >
> >
> > but only if you are CERTAIN you are performing all the logic that MAPICS
> >
> >
> > would do when you type in a green-screen or browser window and press
> enter.
> >
> >
> >
> >
> >
> >
> >
> >
> > Safe way to do this with a program is with SystemLink (oops - just
> reread
> >
> >
> > you're on 5.5 - no Syslink).  It performs all the logic that MAPICS does
> >
> >
> > (since it IS MAPICS).   If you do something with SQL, you'll need to
> >
> >
> > replicate the logic.
> >
> >
> > In your case, comletely fixable, just update the records by using an
> UPDATE
> >
> >
> > and set LTPUR=LTVEN+LTSAF.
> >
> >
> > Let me know if you need help with the syntax - I have to look it up but
> I
> >
> >
> > have one like it.
> >
> >
> > Mike
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> > > ----------------------------------------------------------------------
> >
> >
> > >
> >
> >
> > > message: 1
> >
> >
> > > date: Mon, 6 Feb 2012 08:02:23 -0600
> >
> >
> > > from: Bryan Burns [email protected]>
> >
> >
> > > 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-Zwy7GipZuJhWk0Htik3J/[email protected]
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/mapics-l
or email: MAPICS-L-request-Zwy7GipZuJhWk0Htik3J/[email protected]
Before posting, please take a moment to review the archives
at http://archive.midrange.com/mapics-l.