Re: [U2] UD: Executing small part of subroutine code once from dictionary call

2009-08-20 Thread art
Bill Haskett wrote: I have a UD dictionary that calls a subroutine. The subroutine selects a small file and saves the data into a reformatted array, which is returned as a passed variable. I want to only execute this select code once in the subroutine then continue with the reset of the su

Re: [U2] UD: Executing small part of subroutine code once from dictionary call

2009-08-20 Thread Kebbon Irwin
I used the @ITEM.COUNT to initialize, but had to be careful to perform a SSELECT before doing a LIST to avoid getting an out-of-order result. > Date: Thu, 20 Aug 2009 16:10:02 -0600 > From: rbl...@gmail.com > To: u2-users@listserver.u2ug.org > Subject: Re: [U2] UD: Executing small part of subrou

Re: [U2] UD: Executing small part of subroutine code once from dictionary call

2009-08-20 Thread Jo Lester
@NI = @RECCOUNT "We are the Knights who say @NI", Monty Python > Date: Thu, 20 Aug 2009 22:09:33 + > From: andyb...@yahoo.co.uk > To: u2-users@listserver.u2ug.org > Subject: Re: [U2] UD: Executing small part of subroutine code once from > dictionary call > > Bill, > > > Does Unidata

Re: [U2] UD: Executing small part of subroutine code once from dictionary call

2009-08-20 Thread Richard Lewis
Bill, A little while ago there was a thread about running totals, and the same problem of initialization came up. It's apparently solved by using an additional named commons variable that saves the date and time last initialized compared to the current date and time of 'this' LIST/etc. statement.

Re: [U2] UD: Executing small part of subroutine code once from dictionary call

2009-08-20 Thread andy baum
Bill, Does Unidata have the @NI variable this will be set to 1 for the first record of any new LIST or SELECT so you should be able to change IF comDbiUserArray = NULL$ OR comDbiUserArray = 0 THEN To IF comDbiUserArray = NULL$ OR comDbiUserArray = 0 OR @NI = 1 THEN HTH Andy

[U2] UD: Executing small part of subroutine code once from dictionary call

2009-08-20 Thread Bill Haskett
I have a UD dictionary that calls a subroutine. The subroutine selects a small file and saves the data into a reformatted array, which is returned as a passed variable. I want to only execute this select code once in the subroutine then continue with the reset of the subroutines business ru

Re: [U2] U2 and UPS WorldShip

2009-08-20 Thread John Hester
> -Original Message- > From: u2-users-boun...@listserver.u2ug.org > [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of > Brutzman, Bill > Sent: Wednesday, August 19, 2009 7:37 AM > To: U2 Users List > Subject: [U2] U2 and UPS WorldShip > > > The main thing we need with United Pa

Re: [U2] Triggers AND Q Pointers....[solved]

2009-08-20 Thread George Gallen
never mind...it turned out the trigger called a subroutine, which opened a file, which wasn't defined in the other account Once I created a Q pointer for that file, the trigger ran fine. George > -Original Message- > From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- > boun.

[U2] Triggers AND Q Pointers....

2009-08-20 Thread George Gallen
ok. not sure what is happeneing, except the trigger fails. It has been working great when changes are made from the same account, But if I attempt to make a change from another account that uses a q ponter to that file, the trigger fails. I'm guessing, that it's because you need a filename and