Help for SQL query

[info at vallemediatime.com]

----- Original Message -----
From: "Ivan Smahin" <IvanSmahin at public.kherson.ua>
To: "Valentina Developers" <valentina at lists.macserve.net>
Sent: Wednesday, June 15, 2005 9:52 AM
Subject: Re[2]: Help for SQL query


> Hello Paolo,
>
> Wednesday, June 15, 2005, 10:42:12 AM, you wrote:
>
> ivc> with:
> ivc> WHERE fld IN (v1, v1) -- same fields
> ivc> the query works, it's probably that this sql sintax need two or more
value,
> ivc> right?
>
> No. It is allowed to use any number of arguments (not zero) in the "IN"
clause.

Thanks, but with:
WHERE fld IN (v1)
I get a Verror, can you test this?
Paolo
V4MD 2.0.2 WIN

>
> --
> Best regards,
>  Ivan                            mailto:IvanSmahin at public.kherson.ua
>
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina
>
>
>
> --
> Internal Virus Database is out-of-date.
> Checked by AVG Anti-Virus.
> Version: 7.0.323 / Virus Database: 267.6.2 - Release Date: 04/06/2005
>
>