Bob It only works for me if there are 8 characters specified.
DIR MAIL_?? File not found DIR MAIL_O?? Returned the file name MAIL_OUT_SEL_Form.frm and MAIL_OUT_SEL_Form.LOB John From: [email protected] [mailto:[email protected]] On Behalf Of [email protected] Sent: Monday, August 03, 2009 10:49 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: filename characters Does anyone have insight on the following results? I am at a loss..... R>dir checka??.??? Volume in drive G has no label. Directory of G:\RBTI\Edi_V8\ CheckAWM txt 543 1-23-09 9:51a CheckAWM.txt CHECKA~1 TXT 480 1-23-09 9:52a CheckAlex.txt CHECKA~2 TXT 543 1-23-09 9:51a checkalex111.txt 3 File(s) 1566 bytes 115894489088 bytes free R>dir checkal?.??? File not found The second dir should have returned the last two files above, but did not. The first dir should not have returned the last two files but did. Can someone confirm like behaviour on thier system or is something awry on my install. As I stated before, this worked fine for many months, but I would not think a database corruption would effect a file handling command. Thanks, -Bob ----- Original Message ----- From: "ttc inc" <[email protected]> To: "RBASE-L Mailing List" <[email protected]> Sent: Monday, August 3, 2009 9:19:08 AM GMT -06:00 US/Canada Central Subject: [RBASE-L] - filename characters Are there any settings that effect filename wildcard characters? (Turbo V8) (Other than the set single command) I have a program that has ran fine for many months. It runs 24 hours 7 days per week via a form timer. This weekend it stopped running. The code that quit working is : --Rename the Merchant EDI files so that users can discern if they have --been sent via this program and that this program will not reprocess same files at --a later time. Include a time stamp to prevent duplicate file names SET VAR voldfile TEXT = ('G:\Edisoft\Sales\HOME DEPOT WESTCOAST\recv\RC??????.???') SET VAR vnewfile TEXT = ('????????sent' + (CTXT(IHR(.#TIME)) ) + '_' + (CTXT(IMIN(.#TIME)) ) + '.???' ) RENAME .voldfile &vnewfile (The . and & are intentional and I believe correct. In any case it worked before and I have tried various combinations this morning, without success) This code has worked without issue for many months. I have several hundred archive files that prove the rename command worked in the past. Now it does not. All file names start out such as RC20090801.001, RC20090801.002, RC20090801.003 etc. The rename command should rename them to RC20090801sent_0824.001, RC20090801sent_0824.002, RC20090801sent_0825.003 and has done so in the past for hundreds of files. This weekend it stopped working. The voldfile RC??????.??? now picks up all files that start with RC, even if the filename has more that 8 characters. This did not use to happen. I.E. previously the above voldfile would not include any RC20090801sent_0824.001 files as they were longer than 8 characters. It seems like the single character wild card is not working now for some reason. I have checked the single character wildcard and it is set properly. I might find some other work around, but I need to find out why it worked before and not now. Any thoughts??? Thanks, -Bob created
