Re: [sqlite] Retrieve a int or a sqlite_int64

2014-05-13 Thread 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 b

Re: [sqlite] Retrieve a int or a sqlite_int64

2014-05-13 Thread 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>

Re: [sqlite] Retrieve a int or a sqlite_int64

2014-05-13 Thread 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 use

[sqlite] Retrieve a int or a sqlite_int64

2014-05-13 Thread 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. ___