Bill, The data type is integer.
I am not sure why but your revised sub-query fixed it. Thanks a ton Steve -----Original Message----- From: Bill Downall [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 18, 2003 10:06 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: -INTERNAL ERROR- Out of dynamic space What is the data type of Op_ID? Is there any chance that the data contains a comma, parenthesis, or quotation mark? Try correlating the sub-query: SELECT ALL FROM optionvalue1 v1 + WHERE op_id NOT in + (sel op_id from productOptions p2 where p2.op_id = v1.op_id) Bill On Tue, 18 Nov 2003 09:58:14 -0600, Fogelson, Steve wrote: >Thanks for the response. I am performing this at an R> prompt. >It wraps around like this: >R>SELECT ALL FROM OptionValue1 WHERE OP_ID NOT IN (SELECT OP_ID FROM >ProductO+ >+>ptions) >So I believe the right parenthesis is there. I copy and pasted all the table >names and columns to make sure they were spelled correctly. >Still doesn't work.
