Fabrice,

the problem is your view definition.
If you're using anything but plain column names you've got to define the
select AND the returning fields.


Try:

create view Test ( st_article, st_datelibre_month) as
select st_article, extract(month from st_datelibre1) as
st_datelibre_month
from statistiquefiche

This should work.


HTH

Luc.

Fabrice Vendé - INFOCOB schrieb:

>
> No, because :
> create view Test as
> select st_article,extract(month from st_datelibre1) from statistiquefiche
>
> Doesn't work !!!!
>
> But "select st_article,extract(month from st_datelibre1) from
> statistiquefiche" work fine.
>
> Thank you for help...
>
> Fabrice Vende
> fabrice@...
>
> -
> SARL I N F O C O B
> Developpement, formation, matériel, logiciel
> http://www.infocob.com
>
> ----- Original Message -----
> From: "Marcos Vinicius Dufloth" <dufloth@...>
> To: <ib-support@yahoogroups.com>
> Sent: Thursday, September 27, 2001 1:53 PM
> Subject: Re: [ib-support] Group by month don't work !
>
> > Try creating a view extracting month and then select the view grouping by
> > month.
> >
> > -------------------------------------
> > Marcos Vinicius Dufloth
> > Tecnocyber, Ltda
> > Erechim - RS - Brasil
> > ICQ# 128291190
> >
> >
> > ----- Original Message -----
> > From: "Fabrice Vendé - INFOCOB" <fabrice@...>
> > To: <ib-support@yahoogroups.com>
> > Sent: Thursday, September 27, 2001 7:00 AM
> > Subject: Re: [ib-support] Group by month don't work !
> >
> >
> > Will a future version allow this ?
> >
> >
> > Fabrice Vende
> > fabrice@...
> >
> > -
> > SARL I N F O C O B
> > Developpement, formation, matériel, logiciel
> > http://www.infocob.com
> >
> >
> >
> >
> > >
> > > Well, you could put it that way. InterBase doesn't let you group by an
> > expression.
> > >
> > > Helen
> > >
> > > All for Open and Open for All
> > > InterBase Developer Initiative · http://www.interbase2000.org
> > > _______________________________________________________
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/