At 02:02 AM 8/10/2003 +0000, you wrote:

> >
>Thanks for replying , Helen. Tried all 3 suggestions and none
>worked. Tried:
>
>All table identifiers.
>No table indentifiers.
>Wraping F_DayOfWeek(OrderDate) in GROUP BY.
>Took out the OrderDate from the GROUP By.
>Tried it in a Boat.
>Tried it with a goat.
>Tried it, oh I've tried it, even in a moat.
>
>Here is the table def:
>CREATE TABLE ORDERSPERMANENT (
> ALCOHOLTAX NUMERIC(15,4),
> AMOUNTTENDERED NUMERIC(15,4),
> AMOUNTTENDERED2 NUMERIC(15,4),
> AMUSEMENTTAX NUMERIC(15,4),
> CHANGEDUE NUMERIC(15,4),
> CREDITTYPE VARCHAR(50),
> CREDITTIP NUMERIC(15,4),
> COMMENTS VARCHAR(50),
> CUSTOMERPHONE VARCHAR(50),
> DRAWERNUMBER INTEGER,
> DRIVERID INTEGER,
> LOCALSALESTAX NUMERIC(15,4),
> NUMBEROFGUESTS SMALLINT,
> ORDERCLOSED SMALLINT,
> ORDERDATE DATE,
> ORDERID INTEGER,
> ORDERSTATUS VARCHAR(50),
> ORDERSUB NUMERIC(15,4),
> ORDERTIME DATE,
> ORDERTOTAL NUMERIC(15,4),
> ORDERTYPE VARCHAR(50),
> PAYMENTTYPE VARCHAR(50),
> PAYMENTTYPE2 VARCHAR(50),
> PRINTED SMALLINT,
> REMOTED SMALLINT,
> SALESTAX NUMERIC(15,4),
> SERVERID INTEGER,
> STATIONID INTEGER,
> STORENUMBER INTEGER,
> STRAUTH VARCHAR(200),
> TABLEID INTEGER,
> TIMEOUT DATE,
> TOTALTIME DOUBLE PRECISION,
> VOIDMANAGER INTEGER,
> SUPRESSORDERUPDATE SMALLINT,
> FINALIZED SMALLINT,
> SHIFTNUMBER SMALLINT,
> ISOPEN SMALLINT,
> ORDERDESTINATION VARCHAR(50),
> EXTORDERID BLANKINTEGER,
> VIPID BLANKINTEGER,
> PERMID BLANKINTEGER,
> RSTATUS RECORDSTATUS
>);

Well....I don't know about your client environment but I've just created
this table and the view here (without table identifiers) and both worked
just fine. Natch, I used the DOW() and SDOW() UDFs from fbudf, as I don't
have FreeIBUDFLib funcs installed in my kick-it-to-death test database.

Here Fb 1.5 RC6 on Win2K SP 2-retreated. Regular fbclient.dll,
firebird.conf set up with OldParameterOrdering true (tho' that shouldn't
touch your issue).

h.