[VNET] "NO_CASE" dosent work in select statement

[Ruslan Zasukhin]

On 10/22/04 12:29 AM, "SoftIl" <softil at onlinehome.de> wrote:

> Hi Ruslan,
> there is a new BUG in Valentina VNET.
> The "NO_CASE" clause doesnt work!
> 
> If I write this:
> 
> "select ohrnummer from tiere where (ohrnummercountry like 'DE00')"
> 
> I get an resultset of 10 records.
> 
> If I write this:
> "select ohrnummer from tiere where (ohrnummercountry like 'de00') NO_CASE"
> 
> I get an resultset of 0 records!
> 
> I need urgent an update.

Hi,


I think problem in ()

Try this

    where ohrnummercountry like 'de00' NO_CASE

-- 
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
-------------------------------------------------------------