DesignBais does all that too. They've built a framework that is used
by the developer to ensure variables are available between connections
for each session. Very handy! :-)
Bill
DavidJMurray (mvdbs.com) said the foll
phil walker-2 wrote:
>
> The trouble with using common for things is when you get into
> client/server development. You cannot guarantee the common will be
> available to you.
>
>
>
Yes, it can get rather messy keeping track of individual user sessions when
a common background process(s)
Behalf Of DavidJMurray (mvdbs.com)
> Sent: Tuesday, 19 October 2010 2:45 p.m.
> To: u2-users@listserver.u2ug.org
> Subject: Re: [U2] Stumped with TRANS...
>
>
>
>
> phil walker-2 wrote:
> >
> > Universe does some caching around TRANS from memory. So if you want
> to
phil walker-2 wrote:
>
> Universe does some caching around TRANS from memory. So if you want to
> only do lookups your results may indicate a good solution. However, for
> update it will not work, and depending on the number of files being
> accessed, you may find there are issues with the cach
.
> -Original Message-
> From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
> boun...@listserver.u2ug.org] On Behalf Of DavidJMurray (mvdbs.com)
> Sent: Tuesday, 19 October 2010 1:01 p.m.
> To: u2-users@listserver.u2ug.org
> Subject: Re: [U2] Stumped with TRANS...
>
>
FFT2001 wrote:
>
> Has anyone done a timing test to compare a SUBR which uses a common
> section
> to store an opened file variable
>
> vs a TRANS ?
> ___
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://listserver.u2ug.org/mailman/li
Yes, with OPEN/READ setup, there is no issue.
With the TRANS setup, I'm forced to do a double TRANS (since I need
more than just the @ID and <1>), One TRANS for the data, and
another to verify existance if the data is ""
I preferred to use the TRANS over OPEN/READ because it was easier to c
S to clarify.
George
-Original Message-----
From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
boun...@listserver.u2ug.org] On Behalf Of Rick Nuckolls
Sent: Monday, October 11, 2010 4:06 PM
To: U2 Users List
Subject: Re: [U2] Stumped with TRANS...
I do not think that there is a way
It's already a subroutine...not being used by an I-desc
> -Original Message-
> From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
> boun...@listserver.u2ug.org] On Behalf Of Jeff Schasny
> Sent: Monday, October 11, 2010 4:42 PM
> To: U2 Users List
> Su
rge
-Original Message-
From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
boun...@listserver.u2ug.org] On Behalf Of Rick Nuckolls
Sent: Monday, October 11, 2010 4:06 PM
To: U2 Users List
Subject: Re: [U2] Stumped with TRANS...
I do not think that there is a way to test the result
ble TRANS to clarify.
George
> -Original Message-
> From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
> boun...@listserver.u2ug.org] On Behalf Of Rick Nuckolls
> Sent: Monday, October 11, 2010 4:06 PM
> To: U2 Users List
> Subject: Re: [U2] Stumped with TRANS...
-users-boun...@listserver.u2ug.org [mailto:u2-users-
> boun...@listserver.u2ug.org] On Behalf Of Mark Eastwood
> Sent: Monday, October 11, 2010 4:00 PM
> To: U2 Users List
> Subject: Re: [U2] Stumped with TRANS...
>
> I have not been following this thread, so I might be off base...
> But
licating the @ID
> into <1>.
>
>> -Original Message-
>> From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
>> boun...@listserver.u2ug.org] On Behalf Of Kebbon Irwin
>> Sent: Monday, October 11, 2010 1:58 PM
>> To: u2-users@listserver.u2ug.org
>
ile.
Mark
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen
Sent: Monday, October 11, 2010 11:42 AM
To: U2 Users List
Subject: Re: [U2] Stumped with TRANS...
yes, there are times, when the entire record is
ld, so it's not that I'm duplicating the @ID
into <1>.
> -Original Message-
> From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
> boun...@listserver.u2ug.org] On Behalf Of Kebbon Irwin
> Sent: Monday, October 11, 2010 1:58 PM
> To: u2-users@li
You can do something like a DCOUNT to
ensure that if <1> is emplty, there are other attributes in the record
Last post, I promise.
Cheers,
Kebbon
> From: ggal...@wyanokegroup.com
> To: u2-users@listserver.u2ug.org
> Date: Mon, 11 Oct 2010 08:56:49 -0500
> Subject: Re: [U2]
in our case was about a 1:100 chance).
George
> -Original Message-
> From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
> boun...@listserver.u2ug.org] On Behalf Of Kebbon Irwin
> Sent: Friday, October 08, 2010 6:25 PM
> To: u2-users@listserver.u2ug.org
> Subject: Re
8 Oct 2010 10:34:07 -0500
> Subject: Re: [U2] Stumped with TRANS...
>
> When you use the 'C' parameter, Trans will return the record ID if the record
> does not exist,
> and the full record if it does exist (in my case it did, since I used -1 as
> the field).
>
&g
nt: Friday, October 08, 2010 8:34 AM
To: U2 Users List
Subject: Re: [U2] Stumped with TRANS...
When you use the 'C' parameter, Trans will return the record ID if the
record does not exist,
and the full record if it does exist (in my case it did, since I used
-1 as the field).
Problem is tha
t; boun...@listserver.u2ug.org] On Behalf Of Kebbon Irwin
> Sent: Friday, October 08, 2010 11:31 AM
> To: u2-users@listserver.u2ug.org
> Subject: Re: [U2] Stumped with TRANS...
>
>
> Why not read the whole record in with the TRANS and then check <1>
> using EXTRACT?
>
Why not read the whole record in with the TRANS and then check <1> using
EXTRACT?
> From: ggal...@wyanokegroup.com
> To: u2-users@listserver.u2ug.org
> Date: Thu, 7 Oct 2010 16:20:17 -0500
> Subject: [U2] Stumped with TRANS...
>
> ok. I'm using TRANS to read som
Has anyone done a timing test to compare a SUBR which uses a common section
to store an opened file variable
vs a TRANS ?
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
nal Message-
> From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
> boun...@listserver.u2ug.org] On Behalf Of Israel, John R.
> Sent: Friday, October 08, 2010 9:15 AM
> To: 'U2 Users List'
> Subject: Re: [U2] Stumped with TRANS...
>
> Instead of a TRANS wit
g] On Behalf Of Kate Stanton
> Sent: Thursday, October 07, 2010 8:31 PM
> To: U2 Users List
> Subject: Re: [U2] Stumped with TRANS...
>
> How about:
>
> TRANS(filename,recID,@RECORD,'x'); IF @ = "" THEN 'not there' ELSE
> @<1,fieldno>
>
&
...@listserver.u2ug.org] On Behalf Of George Gallen
Sent: Friday, October 08, 2010 9:14 AM
To: U2 Users List
Subject: Re: [U2] Stumped with TRANS...
hmmm. might work. I'll have to try it just to see, but I'll
most likely go with switching field orders, since I'd rather
not do a double
e-
> From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
> boun...@listserver.u2ug.org] On Behalf Of Bob Woodward
> Sent: Thursday, October 07, 2010 7:22 PM
> To: U2 Users List
> Subject: Re: [U2] Stumped with TRANS...
>
> Can you chain two TRANS functions and comp
# @ID
Thanks
George
> -Original Message-
> From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
> boun...@listserver.u2ug.org] On Behalf Of Oaks, Harold
> Sent: Thursday, October 07, 2010 6:01 PM
> To: U2 Users List
> Subject: Re: [U2] Stumped with TRANS...
>
&
re getting is the key value, then the first AND second
> results would be equal, both containing @ID.
>
> BobW
>
> -Original Message-
> From: u2-users-boun...@listserver.u2ug.org
> [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Oaks, Harold
> Sent: Thur
er.u2ug.org] On Behalf Of Oaks, Harold
Sent: Thursday, October 07, 2010 3:01 PM
To: U2 Users List
Subject: Re: [U2] Stumped with TRANS...
George:
Here's something that might work for you, PROVIDED that you always know
that if the target record exists, there is always something in field 1.
It se
nal Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen
Sent: Thursday, October 07, 2010 2:20 PM
To: U2 Users List
Subject: [U2] Stumped with TRANS...
ok. I'm using TRANS to read some data, but I need to be able
ok. I'm using TRANS to read some data, but I need to be able to tell if the
record exists, WITHOUT producing an error message.
ok. So, I use the 'C' command, where it's supposed to return the @ID if it
doesn't exist
BUTI have records where the only data in <1> is the record ID (by
coinced
31 matches
Mail list logo