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/
