Hi Karen, I know this is a long shot but I have stopped using the .CMD extension because Windows XP on my computer keeps trying to "run" them giving me all kinds of unknown command errors.
Perhaps Windows (even in its DOS mode) is trying to run your .CMD file as an NT command and slowing down the works? A long shot but I thought I would share it. Dave Fitts State of Maine, Risk Management Division -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Sunday, December 07, 2008 2:11 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Running 7.6 code from a batch? Good suggestions. I have never run AUTOSYNC ON at my clients, so I don't know whether that slows things down. And I also don't mess with QUALCOLS, so I'll ask him if he knows why it is reduced to 2 from 10. Anyone know if that would make things slower? I've also never played around with WAIT. Boy, it looks like someone really messed with the default settings, doesn't it? This client hates seeing the "$" in the currency fields; that's why it's blank. I'd have to say that the majority of my clients also want it blank. Yes they are using the old pre-SQL defaults for character settings. They know it's a problem should they ever want to use external programs. This is by far the most complicated application I have worked on in my 22 years of RBase programming. There are thousands (yes thousands) of individual program files, haven't counted but probably almost a thousand forms and reports between 7.6 and the remaining DOS, and I had no involvement in the writing of this app so it's been pretty hard coming into this client under their contractor. Even Wrigley, a big Fortune XX-? company, does not have an RBase app as complicated as this one. It would take a Fortune 100 budget to change everything to a single quote, and this is a small privately owned company... Karen Karen, In addition to other comments I would: 1. review consequences of setting AUTOSYNC ON. The default is OFF 2. Why is currency symbol BLANK. 3. review why you SET QUALCOLS 2 -- default is 10 4. review why you SET WAIT 15 -- default is 4 sec Just an observation. Is the database really using the pre-SQL characters of DOUBLE_QUOTES=" and the SINGLE=? and MANY=* If so, while they are legal under RBase any using current help and documentation may be confused if they don't mentally make the conversion between what the documentation shows and what they actually have to enter.
