It is a date type. After the thing bombs, if I type SHOW VAR vdate it responds 08/14/2002
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Troy Sosamon Sent: Thursday, August 15, 2002 11:24 AM To: [EMAIL PROTECTED] Subject: RE: Invalid date???? Insufficient space?? I would double check to make sure vdate is a date data type??? ===== Original Message from [EMAIL PROTECTED] at 8/15/02 8:14 am >This is too wierd. > >What's wrong with this code? > >SELECT MAX rdate_ INTO vmaxdate I1 FROM famhx0 + > WHERE patnumbr = .vpnum AND rdate_ <= (.vdate) > APPEND famhx0 TO famhx1 WHERE patnumbr = .vpnum + > AND rdate_ = (.vmaxdate) > UPDATE famhx1 SET rdate_ = .vdate WHERE patnumbr + > = .vpnum and rdate_ = (.vmaxdate) >--EDI ALL FRO FAMHX1 WHERE PATNUMBR = .VPNUM AND + >-- RDATE_ = .VDATE > EDIT USING famhx1 WHERE patnumbr = .vpnum AND + > rdate_ = .vdate > >If I run the above code as is, I get an error message >that says "-ERROR- Invalid DATE value (2418)"and then >"Insufficient space to process famhx1" > >If I put parentheses around the last variable .vdate, >it works! > >If I trace it, it works! > >If I remove the -- in lines 7 and 8, it works! > >I am runnig this on a skeleton database with EVERYTHING >removed except the tables in question, and the form in >question. The mini database was packed, reloaded, etc. > >HELP! > >Mike Sinclair >================================================ >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/ ================================================ 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/
