U++ forum: Welcome to the forum

Status & Roadmap

Authors & License

Funding Ultimate++

Search on this site

Search in forums

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

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

Return to the default flat view

Create a new topic

Submit Reply

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

Thu, 03 December 2020 18:56

Alboni is currently offline

Alboni
Messages: 214
Registered: January 2012
Location: Deventer, Netherlands

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 124 times)

Report message to a moderator

Send a private message to this user

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

] [

PDF

]

Current Time: Mon Apr 29 06:21:32 CEST 2024

Total time taken to generate the page: 0.02543 seconds