[V4MD] UPPER doesn"t work ?

[Gregoire William]

OK...thanks...
same thing for the IF() stuff i think ? I know understand why all my tests
didn't work :))))

And about method, my problem is that I import all from ACCESS export...
how i can import method too ?
I have to import THEN insert my method in all the records ? or is there
another way, such as a text field in access with the method like
"UPPER(fld)" ?

thanks

CrrCrr

> -----Message d'origine-----
> De : Valentina-bounces at lists.macserve.net
> [mailto:Valentina-bounces at lists.macserve.net]De la part de Ruslan
> Zasukhin
> Envoye : jeudi 10 juillet 2003 18:56
> A : Valentina at lists.macserve.net
> Objet : Re: [V4MD] UPPER doesn"t work ?
>
>
> on 7/10/03 18:54, Gregoire William at wgregoire at paris.mediagerance.com
> wrote:
>
> > SELECT UPPER(Fld)
> > FROM Tbl
> >
> > give me an error 603 (Field not found)
> >
> >
> > when
> >
> > SELECT Fld
> > FROM Tbl
> >
> > work w/o problems...
> >
> > Am i forgetting something ????
>
> Yes Gregoire,
>
> In Valentina 1.x you cannot use functions directly in SQL query.
>
> You need at first create BaseObject method with that formula
> and use BaseObject method in query.
>
>
> --
> Best regards,
> Ruslan Zasukhin      [ I feel the need...the need for speed ]
> -------------------------------------------------------------
> e-mail: ruslan at paradigmasoft.com
> web: http://www.paradigmasoft.com
>
> To subscribe to the Valentina mail list go to:
> http://lists.macserve.net/mailman/listinfo/valentina
> -------------------------------------------------------------
>
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/Valentina