>>Hi Tamar,
>>
>>

>>		insert into ERRORLOG ;
>>              (DATE, TIME, USER, TERMINAL, CUSTOMER, ALIAS,;
>>               RECNUM, KEYFLD, ERRMSG1, ERRMSG2, ERRMSG3, ACTION, ;
>>				MEMVARS, DETAILS, CALLSTACK) ;
>>		   values ;
>>		      (date(), time(), gcUSER_NAME, SysZero(), space(len(customer)), lcALIAS, ;
>>               lnREC, lcKEY, lcLINE1, lcLINE2, lcLINE3, 'REBOOT',;
>>               '', m.lcDetails, m.lcStackInfo)
>>

>>
>>- Could SysZero() change alias() or insert a log row itself or otherwise interfere with the insert midstream?
>>
>
>Nope, SysZero reads one environmental variable (GETENV()) and cleans up and returns the result.
>
>>- and -
>>
>>Does space(len(customer)) rely on selected alias? If it's a variable, try with mdot or what happens if you replace with "" ?
>
>Nope, Customer here is a field in ErrorLog, so just inserting an empty value there. Guess I could try just the empty string. (Inherited code, and policy through the app is to use space(len(field)) for empty values, but certainly makes no difference here.
>
>The weird thing, of course, is that all this is working for everyone else, so it has to be something local.
>
>Tamar

Stupid question -- Does it make a difference if you assign the value returned by SysZero() to a variable, then using the variable inside the INSERT INTO make a difference?