Record has been modified

Yahoo Archive
1
Try:
"for each ttJobHead where ttJobHead.RowMod = 'A' or ttJobHead.RowMod
= 'U' no-lock:"
or
"find first ttJobHead where ttJobHead.RowMod = 'A' or
ttJobHead.RowMod = 'U' NO-LOCK NO-ERROR."

Also, I notice you don't include "Company" in your join. You should
get into the habit of including this in case you ever create a second
company in your database.

Nigel.


--- In vantage@yahoogroups.com, "Ross Hughes" <ross.hughes@...> wrote:
>
> I may have forgot to mention that it is a 4GL code mod.
>
> -------------
>
> For Each ttJobHead.
> Find PartRev WHERE (PartRev.PartNum = ttJobHead.PartNum AND
> PartRev.RevisionNum = ttJobHead.RevisionNum).
> If Available PartRev Then DO:
> ttJobHead.CheckBox04 = PartRev.CheckBox01.
> End.
> End.
> -----------------
>
> Thanks,
> Ross
>
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
Behalf Of
> Mark Wonsil
> Sent: Tuesday, December 16, 2008 2:39 PM
> To: vantage@yahoogroups.com
> Subject: RE: [Vantage] Record has been modified...
>
> > When I create a Post-BPM rule
>
> Uh, yeah, right. I see...
>
> <doh>
>
>
>
> ------------------------------------
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You
must have
> already linked your email address to a yahoo id to enable access. )
> (1) To access the Files Section of our Yahoo!Group for Report
Builder and
> Crystal Reports and other 'goodies', please goto:
> http://groups.yahoo.com/group/vantage/files/.
> (2) To search through old msg's goto:
> http://groups.yahoo.com/group/vantage/messages
> (3) To view links to Vendors that provide Vantage services goto:
> http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
>
2
When I create a Post-BPM rule it ends up as the last thing I can do in
the interface without pressing refresh. Everytime the BPM fires it
modifies the table and the next client data modification sends the
interface in to its 'record has been modified' exception box because
the BPM has previously fired as the last step.

Is there a way around this via the BPM? A reset change row command or
something?

Thanks,
Ross
3
> When I create a Post-BPM rule it ends up as the last thing I can do in
> the interface without pressing refresh. Everytime the BPM fires it
> modifies the table and the next client data modification sends the
> interface in to its 'record has been modified' exception box because
> the BPM has previously fired as the last step.
>
> Is there a way around this via the BPM? A reset change row command or
> something?

Are you using a Pre or Post processing BPM?

Mark W.
4
> When I create a Post-BPM rule

Uh, yeah, right. I see...

<doh>
5
I may have forgot to mention that it is a 4GL code mod.

-------------

For Each ttJobHead.
Find PartRev WHERE (PartRev.PartNum = ttJobHead.PartNum AND
PartRev.RevisionNum = ttJobHead.RevisionNum).
If Available PartRev Then DO:
ttJobHead.CheckBox04 = PartRev.CheckBox01.
End.
End.
-----------------

Thanks,
Ross


-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Mark Wonsil
Sent: Tuesday, December 16, 2008 2:39 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Record has been modified...

> When I create a Post-BPM rule

Uh, yeah, right. I see...

<doh>



------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links