Thanks, isn't debug a great command? I like being able to turn on/off additional testing and logging easily.
I usually write to a .err file or a .log file, but I have a tracker table that I also use. Some people wonder why my code has so much testing and logging in it. Good to know I am not the only one to do stuff like this. Kenny From: [email protected] [mailto:[email protected]] On Behalf Of Javier Valencia Sent: Thursday, June 20, 2013 3:40 PM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: Error code 2295 - missing right side of comparison Kenny, The only problem I have found with unmonitored tasks running of the Windows Scheduler is when the user changes password and the Windows Scheduler password is not updated. Other than that, it runs pretty much the same that when we run the utility manually. I have a log table that I use when debugging stubborn issues that has two columns: LogDateTime and LogMessage. I can add commands throughout the code that write to this table at different places in the process with a date-timestamp and a code location/comment, such as: DEBUG INSERT INTO DebugLog ( LogDateTime, LogMessage) + VALUES (.#NOW, 'schedule Update Utility - Start of Update loop') I can look at this table afterwards and see where the messages stop or skip and 9 out of 10 times I can figure out the problem. Javier, Javier Valencia, PE O: 913-829-0888 H: 913-397-9605 C: 913-915-3137 From: [email protected] [mailto:[email protected]] On Behalf Of Kenny Camp Sent: Thursday, June 20, 2013 1:58 PM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: Error code 2295 - missing right side of comparison Thanks Javier, I do that too. In this routine, I do not build any commands inside of variables. I can't seem to re-create the error using all the tricks I have learned from this list, so I wondered if anyone else might have run into this. Only happens when the scheduled task is run unmonitored. Kenny From: [email protected] [mailto:[email protected]] On Behalf Of Javier Valencia Sent: Thursday, June 20, 2013 1:27 PM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: Error code 2295 - missing right side of comparison Kenny, You are likely missing the right side of a comparison in a statement, just like the messages indicates. I have run into this error when I build a command in a variable and one of the components is undefined or blank and the expression Is incomplete. Easiest way to find the error is to trace the code and you will know exactly where it is. All my code now has a statement at the top: DEBUG SET TRACE ON When I want to trace , I simple SET DEBIUG ON and the code will be traced; I SET DEBUG OFF and the tracing stops. It work great when developing code or debugging. Javier, Javier Valencia, PE O: 913-829-0888 H: 913-397-9605 C: 913-915-3137 From: [email protected] [mailto:[email protected]] On Behalf Of Kenny Camp Sent: Thursday, June 20, 2013 12:41 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Error code 2295 - missing right side of comparison List, What cause the error Error code 2295 - missing right side of comparison? I've tried recreating it with no luck. If variable is undefined 2515, if not found 2059, if null 2059. Also tried in a sub-select. It happened in an automated routine and I haven't been able to find which command caused it. As a work around, I have that message ( and all error messages) turn off, but would like to discover what is causing it. Kenny
