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. Jim Bentley American Celiac Society [EMAIL PROTECTED] tel: 1-504-737-3293 ________________________________ From: Dennis McGrath <[EMAIL PROTECTED]> To: RBASE-L Mailing List <[email protected]> Sent: Saturday, December 6, 2008 2:58:31 PM Subject: [RBASE-L] - Re: Running 7.6 code from a batch? I can guess, but what is in messon.cmd? Did you check to see if you actually have a TEMP environment variable? ________________________________ From:[email protected] [mailto: [email protected] ] On Behalf Of [EMAIL PROTECTED] Sent: Saturday, December 06, 2008 1:42 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Running 7.6 code from a batch? Sure! If someone wants to take a look at it, here's the code SET AUTOSYNC ON SET ERROR VAR XERR SET COLOR WHITE ON BLUE SET ECHO OFF OUTPUT SCREEN RUN MESSON.CMD SET QUOTES ="""" SET BLANK=" " SET DELIMIT="," SET IDQUOTES=` SET NULL " " SET MANY="*" SET VAR XVMANY=(CVAL("MANY")) SET SINGLE="?" SET WHILEOPT OFF SET WALKMENU ON SET CASE OFF SET FILES 25 SET LAYOUT ON SET ROWLOCKS ON SET LINES 20 SET ZERO ON SET ANSI OFF SET FEEDBACK ON SET LINEEND ="^" SET WALKMENU ON SET EQNULL OFF SET CURRENCY " " PREF 2 B SET REVERSE ON SET SEMI=";" SET ZOOMEDIT OFF SET SCRATCH ON SET VAR vSCRATCH TEXT = NULL SET VAR vSCRATCH = (ENVVAL("TEMP")) IF vScratch IS NOT NULL THEN SET SCRATCH .vSCRATCH ENDIF SET TIME FORMAT "HH:MM AP" SET TIME SEQ "HHMM" SET DATE MM/DD/YY SET DATE FORM MM/DD/YY SET DATE CENTURY 19 SET DATE YEAR 80 SET WAIT 15 SET HEADINGS ON SET SELMARGIN 1 SET AUTOSKIP OFF SET TOLERANCE=0. SET QUALCOLS 2 SET SORT MAX 64 SET CLEAR ON Karen Karen, If you post a copy of the program code perhaps someone on the list can spot the problem line(s). Jim Bentley

