Sometimes this can be dangerous. We had a routine to open files in a common area. We had a live account in one directory and a test in another. If you switched back and forth between live and test you were still pointing to the same files. We had to create a 'close files' routine when switching back and forth. Anyway, we no longer share test and production on the same machine. Equipment is so cheap these days we bought a test server. Be careful ! Anthony
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Tuesday, August 09, 2005 11:42 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] New UV Accout VOC The problem here is that anything in the PRODUCTION voc that looks like <1>F <2>FILENAME <3>D_FILENAME will need to be changed in the SANDBOX account to <1>Q <2>PRODUCTION <3>FILENAME this is because these are actual files in the PRODUCTION account and they dont exist in the SANDBOX account, so you need to change these file defintions to pointers which tell you where the actual file is h [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 09/08/2005 15:58 Please respond to u2-users@listserver.u2ug.org To u2-users@listserver.u2ug.org cc Subject RE: [U2] New UV Accout VOC Will's answer is quite excellent but... 1. The SandBox VOC needs to know about files. So, I did something similar like... SELECT MYPOINTER WITH F1 = "F" COPY FROM MYPOINTER TO VOC SELECT MYPOINTER WITH F1 = "PA" COPY FROM MYPOINTER TO VOC 2. The first program that I tried ran OK. The second and third programs ended abnormally with messages like... "Improper data type" when trying to read a record from a file newly defined in the SANDBOX VOC... like read R.Record from F.FileName else R.Record = '' I suspect that it has to do with line three of the following... ED VOC FILENAME 1: F 2: FILENAME 3: D_FILENAME 3. Thus, further commentary would be appreciated. --Bill -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of [EMAIL PROTECTED] Sent: Monday, August 08, 2005 7:23 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] New UV Accout VOC Bill. From your sandbox account create a Q-pointer to your production account like this. Let's say the production account is called PRODUCTION ED VOC MYPOINTER NEW ITEM TOP .I 001 Q 002 PRODUCTION 003 VOC 004 .FI 'MYPOINTER' filed Now do this SELECT MYPOINTER WITH F1 = "V" 963 items selected COPY MYPOINTER TO: (VOC This should copy all the missing 'verbs' from PRODUCTION to SANDBOX. Will Johnson ------- 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/ ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/