SQL search

Ruslan Zasukhin sunshine at public.kherson.ua
Sun Aug 29 09:36:00 CDT 2004


On 8/28/04 6:03 PM, "jda" <jda at his.com> wrote:

> I have a table with 19 records. One of the fields is "propertyName",
> where I store the name of a variable, and the other field can contain
> the various values.
> 
> This search
> 
>  myDatabase.SQLSelect("select varCharField from misc where
> propertyName='groupName' ORDER BY varCharField"
> 
> returns all 19 records, even though only one of them has a
> propertyName of 'groupName'.
> 
> What is wrong with the select statement (or is this a bug in 2.0)?

I think bug.

This was usual database,
Or you have set UTF8 for it ?


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



More information about the Valentina-beta mailing list