You still don't say what you're planning on doing with these number...just displaying them?
Yes may be ... I am working on modification of database component for accessing SQLite3 databases for FreePascal project. We map declared column's types to native freepascal internal field types. So DECIMAL and NUMERIC is mapped to TFmtBCDFieldType (which is able to hold up to 64 digits) We read column value using sqlite3_column_text and then convert string representation into TBCD (which is internal structure for "arbitrary" precision numbers) But problem arrives when we want write back values. We use sqlite3_bind_text and as I wrote a this point we loose precision (because SQLite3 forces conversion to floating point values). TIA -Laco.
_______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
