>>>>> dixonepperson l'ha dit:

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

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

You cannot define a view that takes parameters: just omit the where
clause, and leave the filtering to the caller.

hth,
ciao, lele.
--
nickname: Lele Gaifax | Quando vivrò di quello che ho pensato ieri
real: Emanuele Gaifas | comincerò ad aver paura di chi mi copia.
email: lele@... | -- Fortunato Depero, 1929.