Subject | Group By [field indexes] |
---|---|
Author | Ed Dressel |
Post date | 2005-04-20T15:39:43Z |
I am using FB 1.5 and have created a SQL statement that works fine
using a 'group by 1, 2, 3, 4' command--but another user (using FB 1.0)
is getting an exception. I can replace the field indexes with names
except for #2 which is a concantenated field:
SELECT R.BUYER, (U1.FNAME || ' ' || U1.LNAME),...
I tried
GROUP BY R.BUYER, (U1.FNAME || ' ' || U1.LNAME),...
(and variations of it as well) but it does not like the open param.
Any comments on how I might handle this?
Thanks
Ed Dressel
using a 'group by 1, 2, 3, 4' command--but another user (using FB 1.0)
is getting an exception. I can replace the field indexes with names
except for #2 which is a concantenated field:
SELECT R.BUYER, (U1.FNAME || ' ' || U1.LNAME),...
I tried
GROUP BY R.BUYER, (U1.FNAME || ' ' || U1.LNAME),...
(and variations of it as well) but it does not like the open param.
Any comments on how I might handle this?
Thanks
Ed Dressel