The actual solution was for me to take the 2 minutes required to comment 
out the TRANS line, add code to open the file, readv the file, comment my 
code, compile and then catalog the program.  Someone who can really type 
would have finished the job in 30 seconds.  :-)
What really hurt was all the time was taken up trying to figure out why 
the flag being set by the TRANS was incorrect.  Now I know.  I have always 
been leery of using a Oconv TRANS in a databasic program.  I was under the 
impression the TRANS had to open the file every time the TRANS was 
executed, now I know better. :-)  Of course, if I had been correct I 
wouldn't have had the problem.  :-(
Learn something new every day.


Bruce M Neylon
Health Care Management Group 




"Keith W. Roberts" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
10/10/2005 11:39 AM
Please respond to u2-users

 
        To:     <[email protected]>, <[EMAIL PROTECTED]>
        cc: 
        Subject:        RE: [U2] OPEN vs TRANS

I understood exactly what you were saying.  The "solution" was for the
case where the acct *wasn't* being exited and therefore @FILENAME,
@RECORD, etc. not flushed.  [Unless, of course, the "cache" you speak of
is something specific to TRANS() rather than the above, but I can't see
why that would 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]; [email protected];
[EMAIL PROTECTED]
Subject: RE: [U2] OPEN vs TRANS

>    Why  do  you  believe doing this (Logto followed by LIST
> VOC...) would
>    work  ( I don't think it will)?   I think you might have
>    misunderstood what  I meant by "exiting the account" - that would
> be 
> using QUIT.   I
>    guess I should have been more clear by saying "quitting universe".
> 
> ______________________________________________________________________
> 
>    From: [EMAIL PROTECTED]
>    [mailto:[EMAIL PROTECTED]  On  Behalf
> Of  "Keith W.
>    Roberts" <[EMAIL PROTECTED]>
>    Sent: Friday, October 07, 2005 1:27 PM
>    To: <[email protected]>; <[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]
>    [mailto:[EMAIL PROTECTED] On Behalf Of
> Glenn Herbert
>    Sent: Friday, October 07, 2005 9:35 AM
>    To: [EMAIL PROTECTED]; [email protected]
>    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() function.
> 
> ______________________________________________________________________
>    > > From: [EMAIL PROTECTED]
>    > [mailto:[EMAIL PROTECTED] On    > Behalf Of
>    > [EMAIL PROTECTED]
>    > Sent: Friday, October 07, 2005 11:22 AM
>    > To: [email protected]
>    > Subject: RE: [U2] OPEN vs TRANS
>    >
>    > Our system has many accounts with, basically, the same
> file names,
>    > layouts, etc. We found a problem with using the translate    >
>    rather than > open/read in programs.
>    > If a program logs from account to account and accesses    > info
>    with a > trans,
>    > the trans doesn't always open and read the file in the    > new
>    account's > file,
>    > rather the trans retrieves the info from an earlier account.
>    > Am I right is supposing this phenomena is due to the file    >
>    and record > having the same ID and logging to another account 
>    > doesn't flush the > cache?
>    > Thanks,
>    > Bruce
-------
u2-users mailing list
[email protected]
To unsubscribe please visit http://listserver.u2ug.org/
-------
u2-users mailing list
[email protected]
To unsubscribe please visit http://listserver.u2ug.org/

Reply via email to