Re: [sqlite] Create DB file and then Create Table - Table FAILS.

"I can't find any documentation for using that library with C++." Yeah--tell me about it. I've been searching and searching without much luck at all. The only examples I've seen talk about including sqlite.h and then using sqlite functions as opposed to using objects and namespaces. But when

Re: [sqlite] Create DB file and then Create Table - Table FAILS.

This line seems erroneous: SQLiteCommand sqlCmd(%conn); Isn't the percent the modulus operator? Shouldn't it be: SQLiteCommand sqlCmd(); On 6/1/2011 5:06 PM, Don Ireland wrote: > I'm hoping someone can help me with this. > > Using Visual Studio C++, the following code DOES create the DB file. >

Re: [sqlite] Create DB file and then Create Table - Table FAILS.

On 2 Jun 2011, at 1:06am, Don Ireland wrote: > Using Visual Studio C++, the following code DOES create the DB file. > But the table doesn't get created and I'm stumped as to why it won't > create the table. Aren't you meant to do something like SQLiteCommand SQLiteCommand = new

[sqlite] Create DB file and then Create Table - Table FAILS.

I'm hoping someone can help me with this. Using Visual Studio C++, the following code DOES create the DB file. But the table doesn't get created and I'm stumped as to why it won't create the table. SQLiteConnection conn; conn.ConnectionString = "Data

Re: [sqlite] Create DB file and then Create Table - Table FAILS.

On Wed, Jun 01, 2011 at 12:21:15 -0400, Richard Hipp wrote: > On Wed, Jun 1, 2011 at 12:19 PM, Stephan Beal wrote: > > > On Wed, Jun 1, 2011 at 5:18 AM, Don Ireland wrote: > > > > > GenBookMRU_3 TEXT, GenBookMRU_4 TEXT); > > > > > > > i might be

Re: [sqlite] Create DB file and then Create Table - Table FAILS.

On Wed, Jun 1, 2011 at 12:19 PM, Stephan Beal wrote: > On Wed, Jun 1, 2011 at 5:18 AM, Don Ireland wrote: > > > GenBookMRU_3 TEXT, GenBookMRU_4 TEXT); > > > > i might be very wrong here, but i SEEM to remember that having a semicolon > on the end of

Re: [sqlite] Create DB file and then Create Table - Table FAILS.

On Wed, Jun 1, 2011 at 5:18 AM, Don Ireland wrote: > GenBookMRU_3 TEXT, GenBookMRU_4 TEXT); > i might be very wrong here, but i SEEM to remember that having a semicolon on the end of a line sent to sqlite3_exec() (or similar) doesn't work. i might, however, be

Re: [sqlite] Create DB file and then Create Table - Table FAILS.

Check to see if escaping combined with double quotes works for you: SQLiteConnection conn; conn.ConnectionString = "Data Source=D:\Users\Don\Downloads\CashBoxPrefs.dat"; conn.Open(); SQLiteCommand sqlCmd(%conn); sqlCmd.CommandText = "CREATE TABLE IF NOT EXISTS Prefs (\"SyncEnabled\" bool ,

Re: [sqlite] Create DB file and then Create Table - Table FAILS.

of SQLite Database Subject: Re: [sqlite] Create DB file and then Create Table - Table FAILS. Ooh. I don't know what happened to that message it was sent as paragraphs. It's kinda hard to read now. Don Ireland -Original Message- From: Don Ireland <sql...@donireland.com> To: SQLi

Re: [sqlite] Create DB file and then Create Table - Table FAILS.

Ooh. I don't know what happened to that message it was sent as paragraphs. It's kinda hard to read now. Don Ireland -Original Message- From: Don Ireland <sql...@donireland.com> To: SQLite <sqlite-users@sqlite.org> Sent: Tue, 31 May 2011 10:18 PM Subject: [sqlite] Cr

[sqlite] Create DB file and then Create Table - Table FAILS.

I'm hoping someone can help me with this. Using Visual Studio C++, the following code DOES create the DB file. But the table doesn't get created and I'm stumped as to why it won't create the table. SQLiteConnection conn; conn.ConnectionString = "Data