Does it show the variable type as being "DATE" when you type "SHOW VAR"? IT should display the variable name, the variable value and the variable type. You can also verify the variable type from inside TRACE.
Javier Valencia, PE President Valencia Technology Group, L.L.C. 14315 S. Twilight Ln., Suite #14 Olathe, KS 66062-4571 (913)829-0888 (913)649-2904 FAX -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of mjs Sent: Thursday, August 15, 2002 11:00 AM To: [EMAIL PROTECTED] Subject: RE: Invalid date???? Insufficient space?? 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/ ================================================ 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/
