Jim,
You need to set your variable first. The ESC doesn't set the variable so do
this
SET VAR vGetDate DATE = NULL
SET VAR Date_A = (GETDATE('Pick Processing Start Date'))
IF Date_A IS NULL THEN
SET VAR vAbort = 1
PAUSE 2 USING 'OPPERATION ABORTED!'
BREAK
ENDIF
Jan
-----Original Message-----
From: Dan <[email protected]>
To: [email protected] (RBASE-L Mailing List)
Date: Thu, 13 Aug 2009 11:07:31 -0400
Subject: [RBASE-L] - RE: GETDATE
Jim, if you escape the date picker, the variable isn't set at all. it is'nt
null or = '[esc]'. Check to see if the variable exists after the set.
Dan
At 10:51 AM 8/13/2009, you wrote:
Jim,
Maybe try SET VAR Date_A date=(GETDATE('Pick Processing Start Date'))
Dave Fitts
State of Maine
From: [email protected] [ mailto:[email protected]] On Behalf Of Jim Belisle
Sent: Thursday, August 13, 2009 8:35 AM
To: RBASE-L Mailing List
Subject: [RBASE-L] - GETDATE
I use the GETDATE command to bring up the calendar so people can choose the
date.
Does the CANCEL button give the same value as the Escape key in my variable
below?
Should I use IF Date_A = [Esc] instead of the IS NULL in my IF THEN
statement?
SET VAR Date_A = (GETDATE('Pick Processing Start Date'))
IF Date_A IS NULL THEN
SET VAR vAbort = 1
PAUSE 2 USING 'OPPERATION ABORTED!'
BREAK
ENDIF
The above code works in RBEDIT mode but not from the R prompt. I get a SET
error.
What am I doing wrong?
Jim
