[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

Thank you for your reply. Pragma wal_checkpoint gave reduced file size. But I still dont know why DB file size increased when I deleted all records .. Can you please clarify this issue? Thanks in advance. On 04-Jan-2012 5:42 PM, "Richard Hipp" wrote: On Wed, Jan 4, 2012 at 6:52

[sqlite] VACUUM command issue

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 ___ s

[sqlite] (no subject)

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 ___ s

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 wrote: > Tarun wrote: >> I am tryi

[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 wrote: > On Thu, Aug 18, 2011 at 11:19 PM, Tarun wrote: > >> Hi All, >> >> I am running program in which I have crea

[sqlite] VACUUM command not working

or code returned. 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 dele