[sqlite] How to get column datatype

Hi All, Does SQLite support any SQL command to get column datatype of table like varchar, INTEGER? Please share example of such command. It would be helpful for me. Thanking you. -- Regards, - Tarun Thakur ___ sqlite-users mailing list sqlite-users

Re: [sqlite] VACUUM command issue

Jan 4, 2012 at 6:52 AM, Tarun <er.tarun.9...@gmail.com> wrote: > Hi All, > > I am running p... The size of the database file is not representative of the amount of content in the file while there is an active write-ahead log. Run "PRAGMA wal_checkpoint;" after doing your i

[sqlite] VACUUM command issue

at that moment. Please share correct behavior that should happen in this scenario shared above. Waiting for your response, I am stuck in my work. -- Thanks and Regards, - Tarun Thakur Module Lead NEC HCL System Technologies, Noida www.nechclst.in ___ sqlite

[sqlite] (no subject)

at that moment. Please share correct behavior that should happen in this scenario shared above. Waiting for your response, I am stuck in my work. -- Thanks and Regards, - Tarun Thakur Module Lead NEC HCL System Technologies, Noida www.nechclst.in ___ sqlite

Re: [sqlite] SQLite3 linking error on 64 bit linux machine

Hi Igor, Thanks for reply. This issue is resolved. I downloaded source code sqlite-autoconf-3070701.tar.gz and built on 64 bit machine. It built successfully and I am able to link with it. Thanks and Regards, Tarun On 8/31/11, Igor Tandetnik <itandet...@mvps.org> wrote: > Tarun &l

[sqlite] SQLite3 linking error on 64 bit linux machine

-linux/bin/ld: skipping incompatible /usr/lib/libsqlite3.so when searching for -lsqlite3 /usr/lib64/gcc/x86_64-suse-linux/4.3/../../../../x86_64-suse-linux/bin/ld: cannot find -lsqlite3 Please let me know what I should do to get it resolved. Thanks in advance. -- Regards, - Tarun Thakur Module

[sqlite] How to configure any parameter to set max number of records to be added in SQLite DB

. Thank you all. -- Regards, - Tarun Thakur Module Lead NEC HCL System Technologies, Noida www.nechclst.in ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] SQL ROWNUM option is failed - Want to Read records in chunks from table

quot;. I am stuck. Thanks in advance. -- Regards, - Tarun Thakur Module Lead NEC HCL System Technologies, Noida www.nechclst.in ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] VACUUM command not working

Thank you so much Richard. I have tried WAL and then applied VACUUM, it is working fine. Thanks again, Tarun Thakur On 8/19/11, Richard Hipp <d...@sqlite.org> wrote: > On Thu, Aug 18, 2011 at 11:19 PM, Tarun <er.tarun.9...@gmail.com> wrote: > >> Hi All, >> >

[sqlite] VACUUM command not working

turned. Given below is output shown: [tarun@emu async_prg]$ ./sqlite_async_compKey vacum1.db 1000 1313661267 1313661269 1313661316 system1-> Size of file after records insertion -rw-r--r--. 1 tarun tarun 559104 Aug 18 15:25 vacum1.db system2 -> Size of file after records deletion -rw-r--r--