Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 3 of 3 total
Thread Standard NULL behavior in 2.29b1
Tue, Dec 4 2018 12:07 PMPermanent Link

Yusuf Zorlu

MicrotronX - Speditionssoftware vom Profi

Hi all, is there a bug in this version because i have "Standard NULL behavior = No" and i get no result for

select * from mytable where myfield = '';

the myfield is a string-field and all datasets have a null in it.

Yusuf Zorlu
MicrotronX
Tue, Dec 4 2018 12:09 PMPermanent Link

Yusuf Zorlu

MicrotronX - Speditionssoftware vom Profi

but if i do

select * from mytable where myfield is null;

i get a lot of rows ..

Yusuf Zorlu
MicrotronX
Mon, Dec 10 2018 3:53 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Yusuf,

<< Hi all, is there a bug in this version because i have "Standard NULL behavior = No" and i get no result for

select * from mytable where myfield = '';

the myfield is a string-field and all datasets have a null in it. >>

Okay, I've reproduced this and will have a fix for it in the next build/release.

Tim Young
Elevate Software
www.elevatesoft.com
Image