At 04:56 PM 27-09-01 +0200, you wrote:

>No, because :
>create view Test as
>select st_article,extract(month from st_datelibre1) from statistiquefiche
>
>Doesn't work !!!!

no, because you have to assign column names for ALL of the output columns of the view.

Dare I suggest you actually READ THE MANUAL <g>

Helen


All for Open and Open for All
InterBase Developer Initiative · http://www.interbase2000.org
_______________________________________________________