This thread looks to be a little on the old side and therefore may no longer be relevant. Please see if there is a newer thread on the subject and ensure you're using the most recent build of any software if your question regards a particular product.
This thread has been locked and is no longer accepting new posts, if you have a question regarding this topic please email us at support@mindscape.co.nz
|
I am using MySQL and the latest LightSpeed nightly 20140527. So given a simple table Contact
I have a record whereby the middle name is
When I read the value of When I run this query I get the expected
When I run this query I get the expected
However if I try and select the value directly or into a non-entity object the
or
or
or
There seems to be some sort of conversion in the
Thanks, Scott |
|
|
Hi Scott, Ive tried to repro this here but in all of the cases where you are seeing null Im seeing a value returned. Are you able to send through the project you are using (a small repro project) and I can have more of a look into whats going on.
|
|
|
Hi Jeremy, So I am looking to get a NULL value and not an empty string, because the value in the database is NULL. I can only get the value back as NULL if I access it from an Entity object. If I try to select the string value directly, or select to a value of a known type or out to an anonymous type having the value, then the string is converted from NULL to an empty string - which is odd. I have attached a small repo project to show this. NB: My model is created directly using LSGEN. Thanks, Scott |
|
|
Thanks Scott, We have tracked this down and added in a fix which will be in the next nightly build for you. Let us know if you continue to see any problems after updating.
|
|