At 09:35 AM 11/27/2009, Roberts, Jennifer wrote:
I am wanting to use the SET VAR vGetDate = (GETDATE('Select Date'))
to bring up the Windows GUI Calendar. How do I find out if the user
clicked 'cancel' instead of 'ok'?
Here's how:
-- start here
SET VAR vGetDate DATE = NULL
SET VAR vGetDate = (GETDATE('Select Date'))
IF vGetDate IS NULL THEN
CLS
PAUSE 2 USING '[Cancel] button was pressed!'
ELSE
CLS
PAUSE 2 USING '[OK] button was pressed!'
ENDIF
RETURN
-- end here
That's all there is to it!
Very Best R:egards,
Razzak.