OpenEuphoria

Re: How to catch integer 64 bit return variable type

• Posted by ChrisBurch2 <crylex at freeuk.co.uk> Jun 12, 2007
• 619 views

D. Darmawan wrote:
> 
> ChrisBurch2 wrote:
> > 
> > Hi
> > 
> > This is interesting.
> > 
> > Are you using the sqlite3 wrappers?
> > Are you trying to get a large signed integer from a database query, or as
> > a return value from one of the other functions?
> 
> Yes Chris, I'm using sqlite3 wrapper, and the problem was occurred when I'm
> trying
> to get a large signed integer in one numeric field from a database query
>  
> > The reason I ask is that database queries are returned as text values in
> > sqlite3,
> > so you have to do the conversion afterwards.
> 
> Really??? FYI, I performed sqlite_step and sqlite_column_int that will return
> an 
> integer value from certain field. 

Yes, you're right. I've never used, or needed to use those functions in the
wrapper,
a clear case of disuse atrophy.

> I think what you're talking about sqlite_get_table function. Yes, I know that
> function
> will return text value and we can pointing it out with data[row][col] in 
> sequence format. But it's memory greedy while it's returning a huge rowset.
>  
> > However, if you are using functions not yet wrapped in eusqlite3, and you do
> > manage to wrap them, I would be more than happy to add them to eusqlite3
> > library.
> > 
> > Chris
> 
> I'd love too, Chris. That is a great idea. Ability to returning value in big
> integer 
> from some functions may be placed in first priority, I think. And then, making
> some 
> functions for handling query function customization is a good idea (I've
> written
> this
> one in my modified eusqlite3 wrapper).
> 
Are you able now to have 64 bit integers returned from sqlite_column_int calls?
And, will the same function return lower vaue (smaller bit count) integers?

If you are amenable, I would like to take a look at your modified functions,
for incorporation into the wrapper. post to crylex at gmail dot com

> Regards,
> Doni

Cheers

Chris