re. triggers Raid, I could not agree with Phil more. Well said.
Come on, Rocket!
On 7/19/2013 1:32 AM, Phil Walker wrote:
Ken,
I am glad you raised the issue about debugging a program with a file which has
a trigger attached. I have been on to UV (Vmark/Ardent/IBM/Rocket for ages
about
I won't be holding my breath Charles ;-)
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charles Stevenson
Sent: Friday, 26 July 2013 9:22 p.m.
To: U2 Users List
Subject: Re: [U2] Universe Triggers
re. triggers
This is all very interesting to hear. I have a customer who has
occasional instances when they complain that a supply receipt has failed
to update the last receipt fields. This is the code:
0092:
***
0093: 7000:* UPDATE
It is worth noting that lines 107 - 110 are all doing an INSERT. The lines
before and after do not.
I'm not sure what that may or may not point to, but it is worth noting. Any
chance that what they are inserting is the problem (i.e. POLREC and VNDKEY are
null or something other than what you
If this occasional problem is consistently the same lines then just
validate the insert afterwards:
0106.1 MV.CNT = DCOUNT(SUPREC2,@VM)
0107: SUPREC = INSERT(SUPREC,2,1,0,POLREC6)
0107.1 IF SUPREC2,1 NE POLREC6 THEN
0107.2MV.CNT2 = DCOUNT(SUPREC2,@VM)
0107.3IF MV.CNT = MV.CNT2 THEN GOSUB
Thanks Bob,
I'll try that validation, maybe even write SUPREC and read it back for
another validation. (It's a low intensity system.) At least that way I
could be telling them rather than them telling me!
dale
___
U2-Users mailing list
Intermittent data issues can be one of the hardest to debug. One way that
has helped me out is to create a log file to log the transaction
information, then verify the data and when it is incorrect, send off an
email with the log file key to investigate.
David A. Green
(480) 813-1725
DAG
From: Woodward, Bob
If this occasional problem is consistently the same lines then just
validate the insert afterwards...
Dale, don't accept that solution. (Sorry Bob)
Note, we're still not really Sure yet that this is a good definition
of the problem, just a working theory...
Overall, the
I have a proc building several SORT reports and they are all going into a
Spooler. (For later and special processing.)
I have added a different kind of report (via code), but I need to have a
page break before and after it.
Is this possible?
PCL codes don't work. When dumped to PDF they just
Did you try char(12)? ^L
George
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of randyleesmith
Sent: Friday, July 26, 2013 2:52 PM
To: u2-users@listserver.u2ug.org
Subject: [U2] How can I Insert a Page Break in a
Char 12 is the old school formfeed which has existed long before these young
whipper snappers created PCL.
In addition, there is the BASIC command PAGE which you could probably execute
at the top of your report that runs in code
-Original Message-
From: randyleesmith
The page might output that ^H^J or some combination like that - like @(-1) does.
George
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson
Sent: Friday, July 26, 2013 3:09 PM
To: u2-users@listserver.u2ug.org
How many people avoid using triggers BECAUSE of the virtual
impossibility of using RAID with Triggers?
On 7/26/2013 12:33 PM, Phil Walker wrote:
I won't be holding my breath Charles ;-)
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
I've been coding for years and don’t think I ever used PAGE before. Or it’s
more like I've never needed to, or use it for a long time and well, you know
how that is. ;)
I've just got such an unusual situation I've been fighting for a while and
this might just be the last thing I needed.
Thanks!!
Not a problem, Tony. I never want someone to just blindly accept a
quick fix. It would be great if manufacturer's would commit the kind of
resources you mention when I submit an intermittent/can't
replicate/seems to only be on my system type of problem, but my
experience is with this kind of
I know we use them, but whenever one of the programmers wants to debug a
program they take them off, which causes us other problems as we have processes
which rely on the trigger output.
This would be my biggest beef with UV at the moment.
-Original Message-
From:
Tony made a key qualification in his suggestion, paying customer. In
this case, the system has been unupgraded for 7 and unsupported for 6
years. (With this exception UniVerse is just so dependable!) I've
noticed that hard to track problems just become albatrosses around the
customer
If you use the SETPTR command you can use STARTPAGE and EJECT as options
to add a form-feed before and after a report.
SETPTR ,, STARTPAGE 2, EJECT
set it back to your standard when finished with the unusual situation.
SETPTR ,, STARTPAGE 0, NEJECT
Date: Fri, 26 Jul 2013 12:36:43
Tony,
I think Bob may have a good troubleshooting technique here. It would be
simple to eliminate causes. Line 107 has a couple of potential problems:
0107: SUPREC = INSERT(SUPREC,2,1,0,POLREC6)
I have seen these 3 situations in more than 1 MV implementation/flavor -
1. If POLREC6 is null,
On 07/26/2013 04:37 PM, Charlie Noah wrote:
Tony,
I think Bob may have a good troubleshooting technique here. It would
be simple to eliminate causes. Line 107 has a couple of potential
problems:
0107: SUPREC = INSERT(SUPREC,2,1,0,POLREC6)
I have seen these 3 situations in more than 1 MV
Could you post the entire program in case there are the frame boundary
issues that Tony talked about?
Thanks,
Robert Norman
ROBERT NORMAN AND ASSOCIATES
23441 Golden Springs Dr., #289, Diamond Bar, CA 91765
(951) 541-1668
i...@keyway.net mailto:i...@keyway.net
http://users.keyway.net/~ice/
21 matches
Mail list logo