RE: [U2] OPEN vs TRANS

2005-10-12 Thread Bruce Nichol
Goo'day, At 23:26 11/10/05 -0400, you wrote: I'm still trying to see how this is superior to a READ, which is entirely self-documenting and efficient, and doesn't require you to know about how TRANS behaves. I suspect that most programmers would have to look at the documentation or a help

RE: [U2] OPEN vs TRANS

2005-10-12 Thread George Gallen
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Timothy Snyder Sent: Tuesday, October 11, 2005 11:27 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] OPEN vs TRANS George Gallen [EMAIL PROTECTED] wrote on 10/11/2005 02:01:52 PM: Also, I

RE: [U2] OPEN vs TRANS

2005-10-11 Thread George Gallen
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Timothy Snyder Sent: Friday, October 07, 2005 5:21 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] OPEN vs TRANS Now, as to people who want to code one line instead of two (e.g.: the topic

RE: [U2] OPEN vs TRANS

2005-10-11 Thread Timothy Snyder
George Gallen [EMAIL PROTECTED] wrote on 10/11/2005 02:01:52 PM: Also, I don't use the OCONV() method with corelatives, I use the VAR=RAISE(TRANS(filename,itemname,-1,'x')), which is pretty self commenting, of course, that requires you to know what the TRANS() keyword does. I'm still trying

RE: [U2] OPEN vs TRANS

2005-10-11 Thread phil walker
Sent: Wednesday, 12 October 2005 4:46 p.m. To: u2-users@listserver.u2ug.org Subject: RE: [U2] OPEN vs TRANS George Gallen [EMAIL PROTECTED] wrote on 10/11/2005 02:01:52 PM: Also, I don't use the OCONV() method with corelatives, I use the VAR=RAISE(TRANS(filename,itemname,-1,'x')), which is pretty

RE: [U2] OPEN vs TRANS + Vector

2005-10-10 Thread Stuart . Boydell
Wow, thanks! and caveat heeded. Vectorally (and RTFM) challenged, Stuart -Original Message- From: Stevenson, Charles Vectoring (is 'vector' a verb?) is built into TRANS already. No need to abandon in favour of OCONVS T-correlative. You can specify a dynamic

RE: [U2] OPEN vs TRANS

2005-10-10 Thread Keith W. Roberts
Subject: RE: [U2] OPEN vs TRANS Hey Keith, That's a really great idea, but why not just add it to the LOGIN paragraph? (it's in the VOC on Unidata systems) Then you won't have to stub the LOGTO command! Allen www.tortillafc.com -Original Message- From: [EMAIL PROTECTED] [mailto

RE: [U2] OPEN vs TRANS

2005-10-10 Thread Keith W. Roberts
be.] -Keith Original Message From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Glenn Herbert Sent: Friday, October 07, 2005 2:17 PM To: [EMAIL PROTECTED]; u2-users@listserver.u2ug.org; [EMAIL PROTECTED] Subject: RE: [U2] OPEN vs TRANS Why do you believe doing this (Logto

Re: [U2] OPEN vs TRANS

2005-10-09 Thread Don Kibbey
. the Dalai Lama When buying selling are controlled by legislation, the first thing to be bought sold are the legislators - P.J. O'Rourke Dan Fitzgerald From: Timothy Snyder [EMAIL PROTECTED] Reply-To: u2-users@listserver.u2ug.org To: u2-users@listserver.u2ug.org Subject: RE: [U2] OPEN

RE: [U2] OPEN vs TRANS

2005-10-09 Thread Stevenson, Charles
Vectoring (is 'vector' a verb?) is built into TRANS already. No need to abandon in favour of OCONVS T-correlative. You can specify a dynamic array of IDs for the target file to read. I have used the Translate code with OCONVS() function when it is stylistically in keeping with the use of

RE: [U2] OPEN vs TRANS

2005-10-08 Thread Allen E. Elwood
In situations where there are multiple reads I usually just pass the whole @RECORD. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Mark Johnson Sent: Friday, October 07, 2005 21:52 To: u2-users@listserver.u2ug.org Subject: Re: [U2] OPEN vs TRANS I've

Re: [U2] OPEN vs. TRANS

2005-10-07 Thread Mats Carlid
Bob Woodward wrote: I believe, for the most part, you are correct, but doesn't TRANS also do some work with the system delimiters? Such as a LOWER() or RAISE() function on the data that is returned? TRANS does indeed return the field LOWER-ed. -- mats Something in the back of my head is

RE: [U2] OPEN vs TRANS

2005-10-07 Thread Hennessey, Mark F.
'... IF(TRANS(ORDERFILE,@ID,1,'X')) EQ '' THEN 'NO FIELD 1' ELSE TRANS(ORDERFILE,@ID,1,'X')...' -Original Message- From: Glenn Herbert [mailto:[EMAIL PROTECTED] Sent: Thursday, October 06, 2005 7:54 PM To: Hennessey, Mark F.; u2-users@listserver.u2ug.org Subject: RE: [U2] OPEN vs TRANS The vlist

RE: [U2] OPEN vs TRANS

2005-10-07 Thread BNeylon
Herbert [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 10/06/2005 07:53 PM Please respond to u2-users To: [EMAIL PROTECTED], u2-users@listserver.u2ug.org cc: Subject:RE: [U2] OPEN vs TRANS The vlist should show a call to Ftrans, which basically does an OPEN

RE: [U2] OPEN vs TRANS

2005-10-07 Thread Glenn Herbert
. __ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Friday, October 07, 2005 11:22 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] OPEN vs TRANS Our system has many accounts with, basically

RE: [U2] OPEN vs TRANS

2005-10-07 Thread Allen E. Elwood
: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of George Gallen Sent: Thursday, October 06, 2005 11:11 To: u2-users@listserver.u2ug.org Subject: [U2] OPEN vs TRANS Is there any savings on using TRANS() vs an OPEN at the top and a READ in the program (Assuming I am only reading 1 record

RE: [U2] OPEN vs TRANS

2005-10-07 Thread Keith W. Roberts
@listserver.u2ug.org Subject: RE: [U2] OPEN vs TRANS You are 100% correct and this is a known issue (to me anyways). The cache is only flushed when exiting the account or when you return back to TCL. Unfortunately, there is no direct way to call the internal transclear

RE: [U2] OPEN vs TRANS

2005-10-07 Thread George Gallen
this application does not need to write, nor set locks, the TRANS may be a nice option. George -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Allen E. Elwood Sent: Friday, October 07, 2005 12:54 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] OPEN vs TRANS

RE: [U2] OPEN vs TRANS

2005-10-07 Thread Allen E. Elwood
. Roberts Sent: Friday, October 07, 2005 10:27 To: u2-users@listserver.u2ug.org; [EMAIL PROTECTED] Subject: RE: [U2] OPEN vs TRANS Possible workaround? Whenever you LOGTO, do a LIST VOC SAMPLE 1 (HUSHed) to change the file and record pointers. -Keith Original Message From: [EMAIL PROTECTED

RE: [U2] OPEN vs TRANS

2005-10-07 Thread Glenn Herbert
To: [EMAIL PROTECTED]; u2-users@listserver.u2ug.org Subject: RE: [U2] OPEN vs TRANS You are 100% correct and this is a known issue (to me anyways). The cache is only flushed when exiting the account or when you return back to TCL. Unfortunately, there is no direct way to call

RE: [U2] OPEN vs TRANS

2005-10-07 Thread Timothy Snyder
Allen E. Elwood [EMAIL PROTECTED] wrote on 10/07/2005 12:53:47 PM: The way I look at it, when I started programming 30 years ago systems were millions of times slower, and in another 30 years they'll be so stinking fast that coding for speed will go the way of the Suchomimus and the

RE: [U2] OPEN vs TRANS

2005-10-07 Thread Allen E. Elwood
clients say N!! Allen www.tortillafc.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Timothy Snyder Sent: Friday, October 07, 2005 14:21 To: u2-users@listserver.u2ug.org Subject: RE: [U2] OPEN vs TRANS Allen E. Elwood [EMAIL PROTECTED

RE: [U2] OPEN vs TRANS

2005-10-07 Thread Dan Fitzgerald
] OPEN vs TRANS Date: Fri, 7 Oct 2005 17:21:28 -0400 Allen E. Elwood [EMAIL PROTECTED] wrote on 10/07/2005 12:53:47 PM: The way I look at it, when I started programming 30 years ago systems were millions of times slower, and in another 30 years they'll be so stinking fast that coding for speed

RE: [U2] OPEN vs TRANS

2005-10-07 Thread Bruce Nichol
Goo'day, At 14:50 07/10/05 -0700, you wrote: Being independent, you have to listen to what the *client* wants. Do they need me to spend an additional 40 hours at $110 an hour to make something run faster? Most clients say N!! My customers say it louder than that..

RE: [U2] OPEN vs TRANS

2005-10-07 Thread Larry Hiscock
: [U2] OPEN vs TRANS Goo'day, At 14:50 07/10/05 -0700, you wrote: Being independent, you have to listen to what the *client* wants. Do they need me to spend an additional 40 hours at $110 an hour to make something run faster? Most clients say N!! My customers say it louder than

Re: [U2] OPEN vs TRANS

2005-10-07 Thread Mark Johnson
I agree. That's what we consultants are for. To help our clients make intelligent decisions. - Original Message - From: Larry Hiscock [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Friday, October 07, 2005 7:12 PM Subject: RE: [U2] OPEN vs TRANS Sometimes you have to educate

Re: [U2] OPEN vs TRANS

2005-10-07 Thread Mark Johnson
effects. If I need another field, I use OPEN and READ. Thanks Mark Johnson - Original Message - From: Timothy Snyder [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Friday, October 07, 2005 5:21 PM Subject: RE: [U2] OPEN vs TRANS Allen E. Elwood [EMAIL PROTECTED] wrote on 10/07/2005

[U2] OPEN vs TRANS

2005-10-06 Thread George Gallen
Is there any savings on using TRANS() vs an OPEN at the top and a READ in the program (Assuming I am only reading 1 record 1 time) This is using UV10 George --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] OPEN vs TRANS

2005-10-06 Thread Glenn Herbert
__ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Hennessey, Mark F. [EMAIL PROTECTED] Sent: Thursday, October 06, 2005 2:55 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] OPEN vs TRANS I think

RE: [U2] OPEN vs TRANS

2005-10-06 Thread Ross Ferris
@listserver.u2ug.org Subject: RE: [U2] OPEN vs TRANS I think you could test this by writing the code both ways, then doing a VLIST to see what actual basic object code would be. -Original Message- From: George Gallen [mailto:[EMAIL PROTECTED] Sent: Thursday, October 06, 2005 2:11 PM To: u2-users

RE: [U2] OPEN vs. TRANS

2005-10-06 Thread Bob Woodward
Herbert Sent: Thursday, October 06, 2005 4:54 PM To: [EMAIL PROTECTED]; u2-users@listserver.u2ug.org Subject: RE: [U2] OPEN vs TRANS The vlist should show a call to Ftrans, which basically does an OPEN and a READ, and caches both for later reuse (subsequent reads on a file