![]() | ![]() Products ![]() ![]() ![]() ![]() |
Home » Technical Support » ElevateDB Technical Support » Support Forums » Search Forums » Search Results » View Thread |
Messages 11 to 19 of 19 total |
![]() |
Sat, Sep 14 2013 7:09 AM | Permanent Link |
Uli Becker | 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 |
Sat, Sep 14 2013 8:47 AM | Permanent Link |
Roy Lambert NLH Associates ![]() | 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] |
Sat, Sep 14 2013 8:54 AM | Permanent Link |
Uli Becker | Roy, I posted an answer 1 hour ago. ![]() Uli |
Sat, Sep 14 2013 11:34 AM | Permanent Link |
Roy Lambert NLH Associates ![]() | 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 |
Sat, Sep 14 2013 11:40 AM | Permanent Link |
Roy Lambert NLH Associates ![]() | 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 |
Sat, Sep 14 2013 4:52 PM | Permanent Link |
Uli Becker | Roy, << I responded to your post an hour ago and you haven't answered yet ![]() >> Good reply ![]() ![]() Maybe you are right. Let's wait for Tim's answer to that. It'll be interesting any way. Uli |
Sat, Sep 14 2013 8:05 PM | Permanent Link |
Peter | 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 |
Tue, Sep 17 2013 1:11 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. ![]() | 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 |
Tue, Sep 17 2013 1:11 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. ![]() | 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 |
« Previous Page | Page 2 of 2 | |
Jump to Page: 1 2 |
This web page was last updated on Saturday, June 22, 2024 at 05:51 PM | Privacy Policy![]() © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? ![]() |