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 get the Unable to materialize error on a plain INT(4) UNSIGNED nullable column in MySQL/Lightspeed.
Using professional version 2.2.948.10429
|
|
|
This is the stack trace of the innerException:
Object of type 'System.DBNull' cannot be converted to type 'System.Nullable`1[System.UInt32]'.
at System.RuntimeType.CheckValue(Object value, Binder binder, CultureInfo culture, BindingFlags invokeAttr)
at System.Reflection.RtFieldInfo.InternalSetValue(Object obj, Object value, BindingFlags invokeAttr, Binder binder, CultureInfo culture, Boolean doVisibilityCheck, Boolean doCheckConsistency)
at System.Reflection.RtFieldInfo.InternalSetValue(Object obj, Object value, BindingFlags invokeAttr, Binder binder, CultureInfo culture, Boolean doVisibilityCheck)
at System.Reflection.RtFieldInfo.SetValue(Object obj, Object value, BindingFlags invokeAttr, Binder binder, CultureInfo culture)
at System.Reflection.FieldInfo.SetValue(Object obj, Object value)
at Mindscape.LightSpeed.Model.FieldModel.SetValueSlow(Object , Object )
|
|
|
I found that the problem lies in the UNSIGNED part of the field definition.
This causes the field to be a which causes the cast error.
If it is not defined as unsigned it will be of type and it will work fine (it will crash on the next unsigned uint that is).
Can you please tell me if this is fixed in a nightly build and if that will support many entities (we use the professional version because we use may entities).
Help very much appreciated.
|
|
|
the types are <uint> and <int> respectively, but these got filtered out or are present as tags and as such invisible in my previous post (should have used 'Preview' I realize)
|
|
|
You're right, this is specific to unsigned integer handling. It will be fixed in the 17 July nightly build, which will be available from about 1430 GMT. Yes, if you have the Professional edition of LightSpeed then you can get Professional nightly builds which support an unlimited number of entities. However, you will need to log into the store and download from there -- do not download the Express edition from the public part of the Web site! |
|
|
By the way, in case you have trouble finding the nightly builds in the store, click on My Account, choose My Software Purchases and follow the Get Files link. |
|
|
Just to add to this, once the nightly build is up you can get it from: http://www.mindscape.co.nz/store/myaccount.aspx Click on the "Get Files" and you should see the nightly builds. I hope that helps, John-Daniel Trask |
|