On 19-4-2013 19:09, ramona.grissom wrote:
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?
Start with the Interbase 6.0 Getting Started,
Thanks Alan! We'll give it a try.
Is this dependent on the version of FB the client is using? I think they are
still on FB 1.5.
--- In firebird-support@yahoogroups.com, Alan J Davies Alan.Davies@... wrote:
That will work.
Here's a real-life example I just changed using your question:
Tried the query and it fails.
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
On Fri, 19 Apr 2013 16:39:36 -, ramona.grissom
ramona.gris...@yahoo.com 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
Thanks Alan! We'll give it a try.
Is this dependent on the version of FB the client is using? I think they are
still on FB 1.5.
The database needs to be dialect 3.
--
With regards,
Thomas Steinmaurer
http://www.upscene.com/
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 firebird-support@yahoogroups.com, Mark
--- In firebird-support@yahoogroups.com, Thomas Steinmaurer ts@... wrote:
Thanks Alan! We'll give it a try.
Is this dependent on the version of FB the client is using? I think they
are still on FB 1.5.
The database needs to be dialect 3.
I believe they are dialect 1, what is the