[sqlite] Why "TRUNCATE TABLE" can't empty a table?

Following is my program: rc = sqlite3_exec(db, "TRUNCATE TABLE students;", NULL, NULL, &errMsg); but this sentence can success and return 1. Help~ ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlit

Re: [sqlite] How to recognize a sqlite database file?

*sqlite3_column_origin_name(sqlite3_stmt*,int); const void *sqlite3_column_origin_name16(sqlite3_stmt*,int); maybe it's more convenient. At 2012-08-14 11:44:14,"Igor Tandetnik" wrote: >daedae11 wrote: >> If I use the group of: >> sqlite3_prepare16_v2() >> s

Re: [sqlite] How to recognize a sqlite database file?

If I use the group of: sqlite3_prepare16_v2() sqlite3_step() andsqlite3_finalize() how can I get the names of a table's columns from a SELECT sql sentence? At 2012-08-14 10:11:31,"Simon Slavin" wrote: > >On 14 Aug 2012, at 3:05am, daedae11 wrote: > >> Thank you

Re: [sqlite] How to recognize a sqlite database file?

Thank you. I got it. And I have another question. Does function sqlite3_exec support UTF-16? At 2012-08-14 10:01:13,"Simon Slavin" wrote: > >On 14 Aug 2012, at 2:57am, daedae11 wrote: > >> How can I judge whether a file is a database file? Is there a function th

[sqlite] How to recognize a sqlite database file?

How can I judge whether a file is a database file? Is there a function that I can use for this purpose? Help! Hope for you reply. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users