Re: [sqlite] Retrieve a int or a sqlite_int64

[gwenn]

Ok,
Thanks.

On Tue, May 13, 2014 at 11:59 PM, Teg  wrote:
> Hello Charles,
>
> Tuesday, May 13, 2014, 3:12:09 PM, you wrote:
>
> CS> Load it with sqlite3_value_int64 every time. If the number fits in a 32 
> bit
> CS> integer, then you can store it in one.
>
> This is what I do. Everything is 64 bits to be future proof.
>
>
> CS> Charles
> CS> ___
> CS> sqlite-users mailing list
> CS> sqlite-users@sqlite.org
> CS> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
>
>
> --
> Best regards,
>  Tegmailto:t...@djii.com
>
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Retrieve a int or a sqlite_int64

[Teg]

Hello Charles,

Tuesday, May 13, 2014, 3:12:09 PM, you wrote:

CS> Load it with sqlite3_value_int64 every time. If the number fits in a 32 bit
CS> integer, then you can store it in one.

This is what I do. Everything is 64 bits to be future proof. 


CS> Charles
CS> ___
CS> sqlite-users mailing list
CS> sqlite-users@sqlite.org
CS> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users



-- 
Best regards,
 Tegmailto:t...@djii.com

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Retrieve a int or a sqlite_int64

[Charles Samuels]

On Tuesday, May 13, 2014 12:02:27 PM gwenn wrote:
> Is there any way to differentiate one value persisted with
> sqlite3_bind_int from another persisted with sqlite3_bind_int64 ?

No, there's no difference

> How to know which method between sqlite3_value_int and
> sqlite3_value_int64 should be used to retrieve the value back ?

Load it with sqlite3_value_int64 every time. If the number fits in a 32 bit 
integer, then you can store it in one.

Charles
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Retrieve a int or a sqlite_int64

[gwenn]

Hello,
Is there any way to differentiate one value persisted with
sqlite3_bind_int from another persisted with sqlite3_bind_int64 ?
How to know which method between sqlite3_value_int and
sqlite3_value_int64 should be used to retrieve the value back ?
Regards.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users