This runs in my ISQL. I use IBConsole. And I am using the IBX
components that came with DELPHI7.
The version of firebird I'm using is 6.2.2.908 with a file date of
12/12/2002 12:37 am.

Here is the sql statement.
CREATE VIEW POVIEW "DID", "DNAME", "DADR1", "DADR2", "DCITY",
"DST", "DZIP") AS SELECT CO_IDNUM, CO_NAME, ADR_ADR1, ADR_ADR2,
ADR_CITY, ADR_ST, ADR_ZIP FROM COMPANY
LEFT JOIN ADDRESS ON (CO_IDNUM=ADR_IDNUM)
WHERE CO_IDNUM=:num AND ADR_SEQ=:seq

Here is the error

invalid request BLR at offset 68
undefined message number

I have tried it with "" around the alias name and without, no
difference in error.

I have tried using both the TIBSQL and TIBQuery. Same error. When I
do it in IBConsole, and supply the parameters, the view is created.

what is causing this error and how do I fix it.

Dixon Epperson