Leave them in. It is the expected syntax for RBase functions.
----- Original Message ----- From: <[email protected]> To: "RBASE-L Mailing List" <[email protected]> Sent: Monday, July 30, 2012 10:56 AM 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 : > : > : > : >
