Razzak, Absolutely! I sure hate those DOH! moments.
--Dennis -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of A. Razzak Memon Sent: Sunday, December 01, 2002 11:15 PM To: [EMAIL PROTECTED] Subject: RE: Time format/Sequence challenge? Dennis, Always the BEST practice to Pre-Define all variables with appropriate data types. Very Best Regards, Razzak. At 06:04 PM 11/30/2002 -0600, Dennis McGrath wrote: >I messed up that previous test. I failed to explicitly set vTime to TIME. > >Once that is done, the code works with no errors. > >SET TIME FOR HHMM AP >SET TIME SEQ HHMM >SET VAR vTime TIME = '1145' >SEL * FROM TESTTIME > 1145 AM > 1145 PM >SEL * FROM TESTTIME WHERE TESTTIME = .vTime > 1145 AM >SEL * FROM TESTTIME WHERE TESTTIME = (.vTime) > 1145 AM ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/ ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/
