Reply to thread

Message

Thanks! Bug confirmed and solved...
We treat the result of the DateToYearProjectionExpression as an INT and therefore try to read it with GetInt32. However, the SQLite command strftime returns a TEXT Value. SQLite refuses to convert TEXT into INTEGER automatically and so we have to make an explicit CAST in the respective SQL statement returned by SQLiteDatabase.CreateDateToYearProjectionExpression. Just a one line change already done and tested...

I somehow knew they would publish the new version of system.data.sqlite when I don't really have time... So what, I just did the update as well. Test is running. When everything goes well, I'll publish v0.08 Beta 2 within the next hour or so. Included changes:
Resolve the conversion exception reported by Morpheus above
Update to sytem.data.sqlite 1.0.89.0

<blockquote data-quote="MJGraf" data-source="post: 1036382" data-attributes="member: 17886">Thanks! Bug confirmed and solved...We treat the result of the DateToYearProjectionExpression as an INT and therefore try to read it with GetInt32. However, the SQLite command strftime returns a TEXT Value. SQLite refuses to convert TEXT into INTEGER automatically and so we have to make an explicit CAST in the respective SQL statement returned by SQLiteDatabase.CreateDateToYearProjectionExpression. Just a one line change already done and tested...I somehow knew they would publish the new version of system.data.sqlite when I don't really have time... So what, I just did the update as well. Test is running. When everything goes well, I'll publish v0.08 Beta 2 within the next hour or so. Included changes:<ul>
<li data-xf-list-type="ul">Resolve the conversion exception reported by Morpheus above</li>
<li data-xf-list-type="ul">Update to sytem.data.sqlite 1.0.89.0</li>
</ul></blockquote>

[QUOTE="MJGraf, post: 1036382, member: 17886"] Thanks! Bug confirmed and solved... We treat the result of the DateToYearProjectionExpression as an INT and therefore try to read it with GetInt32. However, the SQLite command strftime returns a TEXT Value. SQLite refuses to convert TEXT into INTEGER automatically and so we have to make an explicit CAST in the respective SQL statement returned by SQLiteDatabase.CreateDateToYearProjectionExpression. Just a one line change already done and tested... I somehow knew they would publish the new version of system.data.sqlite when I don't really have time... So what, I just did the update as well. Test is running. When everything goes well, I'll publish v0.08 Beta 2 within the next hour or so. Included changes: [LIST] [*]Resolve the conversion exception reported by Morpheus above [*]Update to sytem.data.sqlite 1.0.89.0 [/LIST] [/QUOTE]