The error is Invalid token. Dynamic SQL Error. SQL error code = -104. Token unknown - line 3, column 1. "account number".
I believe they are dialect 1, what is the difficulty in changing the dialect? This was tested on both FB 1.5 and FB 2.5 --- In [email protected], Mark Rotteveel <mark@...> wrote: > > On Fri, 19 Apr 2013 16:39:36 -0000, "ramona.grissom" > <ramona.grissom@...> wrote: > > Tried the query and it fails. > > What is the error? > > > This works: > > > > select > > ii.part_number,extractweekday(ih.inv_date),ih.inv_date,ih.part_number as > > account_number > > from invitems ih > > join invitems ii > > on ii.inv_id=ih.inv_id > > group by ii.part_number,ih.inv_date,ih.inv_date,ih.part_number > > > > Doesn't work: > > select > > ii.part_number,extractweekday(ih.inv_date),ih.inv_date,ih.part_number as > > "account number" > > from invitems ih > > join invitems ii > > on ii.inv_id=ih.inv_id > > group by ii.part_number,ih.inv_date,ih.inv_date,ih.part_number > > > > Tried, [account number], 'account number', etc. > > Are you by any chance using dialect 1? > > Mark >
