Joanne Pham <[EMAIL PROTECTED]> wrote: > Thanks a lot Igor! > But the codes below didn't work too: > char stmt[STMT_LEN]; > char *sqlStmt = &stmt[0]; > strcpy(&stmt[0],"output compressTable; mode csv; select * from > compressTable; ");
I didn't say the dot in front is wrong: the whole command is wrong. Neither "output compressTable;" nor ".output compressTable;" are valid SQL statements. > So how to set the output and mode before executing the select > statement. What output and mode? sqlite3_exec doesn't produce any output. Again - you are confusing SQLite API and sqlite3 command line utility built on top of that API. Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users