Searching for an empty/non-empty field

[Ruslan Zasukhin]

On 11/11/04 5:20 PM, "jda" <jda at his.com> wrote:

>> Try this:
>> 
>>    select * from theTable where len(myField) = 0
>> 
>> and the converse would be:
>> 
>>    select * from theTable where len(myField) > 0
>> 
>> Both cases would (should) skip Null values.
>> 
> 
> Hm, that generates an exception: Internal Error (626688). Sounds like
> another bug report.

Ivan will check.

Jon, may be I have now understand, do you want

    WHERE fld IS NULL
    WHERE fld IS NOT NULL

?

> BTW, is anyone else out there beta testing V2? There are > 25 issues
> on the beta bug tracker
> (http://paradigma.ukrcom.kherson.ua/bt/login_page.php), and I think
> all but one are from me! I encourage anyone who wants to see v2 be a
> success to jump in. It's definitely usable now, although still buggy
> (see above).

I agree. 

It is time for V4RB developers to start convert own existed projects to 2.0.

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