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/
