Error in Group BY (obtainSelectStatement)

[t16turbo]

I have the following error appearing when I try to compile the report:


OracleTextQuerySource%ObtainSelectStatement(62): Actual: [new line] Expecting: '(', '+', '-', [currency constant],
[floating constant], [hexa constant], ID, [A-Z], [date constant],
[integer constant], Null, [octal constant], [string constant], ::, BNot,
ID@, ID#, ID%, ID&, ID!, ID$, New, Not, Nothing, Width



my code in the ObtainSelectStatement is as follows:

  GroupStr = "GROUP BY x.dsti_proj_ref, a.transtype, a.transdate, a.quantity, a.project_code, a.resource_code, " & 
 +			"b.currency_code, b.stdcost, b.totalcost, b.billrate, b.amount, c.company_name, d.name, e.first_name, " &
+			"e.last_name, b.amo"

can anyone see something I can't? I don't understand why it's not working.
thanks in advance

 

[gdwood]

I don't think it likes your carriage returns and + signs.

try

GroupStr = "GROUP BY x.dsti_proj_ref, a.transtype, a.transdate, a.quantity, a.project_code," &
GroupStr = GroupStr & "a.resource_code, b.currency_code, b.stdcost, b.totalcost, b.billrate, " &
GroupStr = GroupStr & "b.amount, c.company_name, d.name, e.first_name, e.last_name, b.amo"

or something like that.

 

[PeteWalburn]

That should be:

GroupStr = "GROUP BY x.dsti_proj_ref, a.transtype, a.transdate, a.quantity, a.project_code,"
GroupStr = GroupStr & "a.resource_code, b.currency_code, b.stdcost, b.totalcost, b.billrate, "
GroupStr = GroupStr & "b.amount, c.company_name, d.name, e.first_name, e.last_name, b.amo"

Pete

 

[gdwood]

Thanks Pete, cut and paste error on my part as we build ours with a few variables, good catch