Re: [sqlite] How to execute the statment file using sqlite API

2008-04-24 Thread Dennis Cote
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

Re: [sqlite] How to execute the statment file using sqlite API

2008-04-23 Thread Fin Springs
On Apr 22, 2008, at 7:57 PM, Joanne Pham joannekpham-at-yahoo.com | sqlite| wrote: Hi all, I have the serveral sql statement in the one file call : getData.sql and I want to use the sqlite API to call this file to execute all sql statements in this file at once. Can you tell me what

Re: [sqlite] How to execute the statment file using sqlite API

2008-04-23 Thread Joanne Pham
Message From: Fin Springs [EMAIL PROTECTED] To: sqlite-users@sqlite.org Sent: Wednesday, April 23, 2008 6:25:12 AM Subject: Re: [sqlite] How to execute the statment file using sqlite API On Apr 22, 2008, at 7:57 PM, Joanne Pham joannekpham-at-yahoo.com | sqlite| wrote: Hi all, I have

[sqlite] How to execute the statment file using sqlite API

2008-04-22 Thread Joanne Pham
Hi all, I have the serveral sql statement in the one file call : getData.sql and I want to use the sqlite API to call this file to execute all sql statements in this file at once. Can you tell me what API I should use. I had the code to execute the statment but I don't know how to call the file.