I got it working finally -- I made the IBQuery component
unidirectional, (the default was otherwise) and I removed the
un/prepare statements. Not sure why, but now it works.
Dixon

--- In ib-support@yahoogroups.com, "dixonepperson" <edepperson@j...>
wrote:

> 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