I have never put the extra parens when using the select into statement. The help file does not show it with the extra parens. I know that some other commands like the extra parens but not the select into.
I was thinking maybe it got pickier with the syntax. Dan From: [email protected] Sent: Monday, July 30, 2012 7:56 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Struggling with SP code Dan: So you don't put the parenthesis around the whole thing? I have run into situations where I get syntax errors (not all the time) if you leave them out, so for years I have changed my ways and always put them in. Karen In a message dated 7/30/2012 9:46:11 AM Central Daylight Time, [email protected] writes: I do not know if this will make a difference but remove the extra () from the max. SELECT MAX(OppActivityID) INTO pvOppActivityID FROM OppActivity + WHERE OppID = .pvOppID AND OppActivityID <>.pvOppActID Dan
