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/
