Joanne Pham wrote:
> So I don't want to read the file into array and executes it.
> I have the define the array of characters as below:
> .output outputFile.mode csv select startTime, appName, appType,
> isAppDeleted, remoteWXId;
> but it didn't work.
From the ".output" command above it appears you are using the sqlite3
shell and not the SQLite API functions from your own application. If
this is not true then you need to know that all the meta-commands that
start with a period are implemented by the sqlite3 shell application,
and not by the sqlite library, so they cannot be used by your application.
If you are using the sqlite3 shell, you can use the .read command to
execute all the commands in a file.
sqlite>.read getData.sql
HTH
Dennis Cote
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
