In article <000501c52d7e$16363e30$0a01a8c0@ANNIBALE>, Salvatore Besso wrote:

> is it possible to use parameters in view definitions? I have this SQL that
> complains for a bad variable "CN" but that normally works if I remove the
> parameter. I'm creating it with IB_Expert:

use it when you call the view

select * from your_view where C.Short_Name = :CN

C.Short_Name has to be in the output list of the view

--
Nick
-----We Solve your Computer Problems---
Founder & Listowner of the Prolifics User Group
Panther, Ingres, UNIX, Interbase, Firebird - Available Shortly