Hi All,
I have the following codes to execute the sql file but the error message return
back that dot(.).
It seems like sqlite3_exec didn't like .output wanPerfTableTest.
So how go to get arround with this command .output wanPerfTableTest
Your help is greatly appreciated.
Thanks
JP
Joanne Pham [EMAIL PROTECTED] wrote:
I have the following codes to execute the sql file but the error
message return back that dot(.).
It seems like sqlite3_exec didn't like .output wanPerfTableTest.
So how go to get arround with this command .output wanPerfTableTest
strcpy(stmt[0],.read
: Igor Tandetnik [EMAIL PROTECTED]
To: sqlite-users@sqlite.org
Sent: Wednesday, April 23, 2008 4:03:20 PM
Subject: Re: [sqlite] sqlite3_exec return an error message
Joanne Pham [EMAIL PROTECTED] wrote:
I have the following codes to execute the sql file but the error
message return back that dot
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.
:20 PM
Subject: Re: [sqlite] sqlite3_exec return an error message
Joanne Pham [EMAIL PROTECTED] wrote:
I have the following codes to execute the sql file but the error
message return back that dot(.).
It seems like sqlite3_exec didn't like .output wanPerfTableTest.
So how go to get
23, 2008 4:55:30 PM
Subject: Re: [sqlite] sqlite3_exec return an error message
On 4/23/08, 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
, 2008 5:02:17 PM
Subject: Re: [sqlite] sqlite3_exec return an error message
Thanks to both of you!
Sorry I am new baby to sqlite3.
Now I got it.
So I should use the shell script to execute these commands.
Thanks,
Joanne
- Original Message
From: P Kishor [EMAIL PROTECTED]
To: General