Peter,

finally I was able to replicate your issue (though in version 2.11 B3 ANSI):

You have set "UseLocalSessionEngineSettings" to true.

In you sessions-settings you have set "LocalStandardNullBehaviour" to
false, which is not the default setting.

Setting this value to true will solve your problem.

Regards Uli

Peter


>Obviously EDBMgr has some formatting of the result

Yup - I said it did. I don't know if it was in specific response to one of my rants about not being able to tell the difference between emptystring and null or not

If it doesn't happen in EDBManager it has to be something in your code, but with the snippet you posted I can see nothing to cause it so it must be the data (logical assumption?). Can you post a working demo project with the code to create the database and insert the data so I can have a look?

There's no text in there so unicode shouldn't enter into it (I say hopefully)

Roy Lambert [Team Elevate]

Roy,

I posted an answer 1 hour ago.

Uli

Uli


<<You have set "UseLocalSessionEngineSettings" to true.

In you sessions-settings you have set "LocalStandardNullBehaviour" to
false, which is not the default setting.

Setting this value to true will solve your problem.>>

Brilliant bit of eyeball/detective work. However, that probably means there's a bug.

From the manual for StandardNullBehavior

This feature does not affect anything other than SQL comparisons, and does not affect how the IS
NULL/IS NOT NULL operators work, how required (NOT NULL) columns work, or how primary,
unique, and foreign key constraints work with respect to NULLs.


So True or False should not affect operations which it is doing here.

Roy Lambert

Uli

>I posted an answer 1 hour ago.

I went out leaving my post queued and turned the 'puter off, came back started up, opened news client and off it went before I even saw yours.

I responded to your post an hour ago and you haven't answered yet

Roy

Roy,

<<
I responded to your post an hour ago and you haven't answered yet
>>

Good reply  Sorry about that.  

Maybe you are right. Let's wait for Tim's answer to that. It'll be interesting any way.

Uli

Uli

Yes, very well spotted, and thanks for your help. I have obviously altered the setting at some stage, as that property is True by default, as it should be. I tested it in the main project and all is well.

Thanks all

Regards

Peter

Roy,

<< This feature does not affect anything other than SQL comparisons, and
does not affect how the IS NULL/IS NOT NULL operators work, how required
(NOT NULL) columns work, or how primary, unique, and foreign key constraints
work with respect to NULLs.

So True or False should not affect operations which it is doing here. >>

Actually, it does - I'll need to update that bit in the manual to reflect
that it also can change the way things like adding and subtracting.

Tim Young
Elevate Software
www.elevatesoft.com

Uli,

<< In you sessions-settings you have set "LocalStandardNullBehaviour" to
false, which is not the default setting.

Setting this value to true will solve your problem. >>

Nice catch.

Thanks,

Tim Young
Elevate Software
www.elevatesoft.com