Reply to thread

Message

<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]

Verification