U++ framework: U++ SQL » Some queries return incorrect datatypes with SqLite

Home » U++ Library support » U++ SQL » Some queries return incorrect datatypes with SqLite

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Some queries return incorrect datatypes with SqLite [message #55728]

Thu, 03 December 2020 18:56

Alboni
Messages: 216
Registered: January 2012
Location: Kajaani, Finland

Experienced Member

Hello, I see some issue with SqLite3 lately that didn't exist before.

They have to do with the datatype of the results of a query.

issue 1 : SqlMax(some time column) returns WSTRING_V result instead of TIME_V
issue 2 : Selecting a BOOL column also returns WSTRING_V result instead of BOOL_V

again, it only applies to SqLite, on MySql it works correctly

I enclosed an example

Attachment: SqLiteIssues.zip
(Size: 1.33KB, Downloaded 279 times)

Report message to a moderator

[Message index]

		Some queries return incorrect datatypes with SqLite By: Alboni on Thu, 03 December 2020 18:56
		Re: Some queries return incorrect datatypes with SqLite By: mirek on Fri, 11 December 2020 14:55
		Re: Some queries return incorrect datatypes with SqLite By: Alboni on Fri, 11 December 2020 15:17
		Re: Some queries return incorrect datatypes with SqLite By: mirek on Fri, 11 December 2020 15:42
		Re: Some queries return incorrect datatypes with SqLite By: Alboni on Fri, 11 December 2020 16:43

Previous Topic:	libpq-fe.h in Alpine Linux
Next Topic:	MySqlSession Close and Reconnect crashes Application

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Mon Sep 07 01:51:59 GMT+2 2026

Total time taken to generate the page: 0.00677 seconds