Re: [sqlite] Retrieve a int or a sqlite_int64
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
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
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
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