Yeah I know the Syntax Map shows all the aggregate functions without and in the examples of Select the ListOf example shows with. Since All of these functions are chanelled to the parser and every function is shown with, I use the extras, if for no other reason than consistency in my feeble grey matter. It won't err out with them in place.
----- Original Message ----- From: "Dan Goldberg" <[email protected]> To: "RBASE-L Mailing List" <[email protected]> Sent: Monday, July 30, 2012 11:05 AM Subject: [RBASE-L] - Re: Struggling with SP code 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
