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: u2-users@listserver.u2ug.org 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 Bruce M Neylon Health Care Management Group Glenn Herbert 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 and a READ, and caches both for later reuse (subsequent reads on a file open'd earlier don't waste the time of the open). I also believe that the file cache is for 10 files, then the oldest gets closed, and the record cache is for 50 records between all open files. If you do multiple TRANS ops on the same file same record, but different fields, you only pay the cost of search for the field (assuming your file and record are still IN the cache!) Hope this helps Glenn ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/