[Chicken-users] Big integers as statement parameters in sql-de-lite

2013-07-22 Thread Matt Gushee
Hi, chickenists-- I am working on an application that stores data in a SQLite3 database, and am currently using the sql-de-lite egg to interface with the DB. I have a few fields that represent dates, and I have defined their datatype as INTEGER. However, when I attempt to execute a statement

Re: [Chicken-users] Big integers as statement parameters in sql-de-lite

2013-07-22 Thread Kon Lovett
On Jul 22, 2013, at 3:26 PM, Matt Gushee m...@gushee.net wrote: Hi, chickenists-- I am working on an application that stores data in a SQLite3 database, and am currently using the sql-de-lite egg to interface with the DB. I have a few fields that represent dates, and I have defined their

Re: [Chicken-users] Big integers as statement parameters in sql-de-lite

2013-07-22 Thread Jim Ursetto
It's not that the values are too large, it's that srfi 19 represents them as bignums, which is not currently supported by sql-de-lite. However, they work as floats (they will be converted to integers before being passed to the database, due to the column type). Even on 32-bit systems, we fully