Home » U++ Library support » U++ SQL » Sqlite3 int64 / wstring support patch
| Sqlite3 int64 / wstring support patch [message #4141] |
Tue, 25 July 2006 10:25  |
aroman
Messages: 18
Registered: November 2005
|
Promising Member |
|
|
Sqlite3 supports directly storing int64 values in the database. It also supports directly storing 16-bit strings. I would like to add support to UPP to handle that.
This involves patching the Value class to support int64's, along with adding the required methods in the sqlite3 value parsing. Also, it should be added to the schema.
Since Value already stores doubles, int64 does not increase size.
I also gently tweaked the storage format for time and date. The original stored time/date as:
'YYYY-MM-DD' or 'YYYY-MM-DD HH:MM:SS'
however the single quotes are not needed since the string is being bound and saved directly into the DB. (I think I messed up the order, though - please check that.)
While I was at it, I added support for "Limit(n)" to limit the number of rows returned by a query.
- Augusto
|
|
|
|
Current Time: Sat Jun 20 18:22:20 GMT+2 2026
Total time taken to generate the page: 0.00676 seconds
|
U++ framework
Search
Help
Members
Register
Login
Home
