[sqlite] Alter table to add a variable named column

2006-05-23 Thread Kevin Piciulo
. Kevin Piciulo

[sqlite] prepare error

2006-05-19 Thread Kevin Piciulo
Hello, I've been staring at this line for quite a while now, and can't figure out what the problem is. I know the database is created and open. The following returns SQLITE_ERROR. sqlite3_prepare(m_dbDataBase, UPDATE Users SET ? = ? WHERE user_id == ?;, -1, stmt, NULL); My guess is

Re: [sqlite] prepare error

2006-05-19 Thread Kevin Piciulo
I tried without using a bound column name, that took care of it. Thanks Jay Sprenkle wrote: On 5/19/06, Kevin Piciulo [EMAIL PROTECTED] wrote: Hello, I've been staring at this line for quite a while now, and can't figure out what the problem is. I know the database is created and open

Re: [sqlite] C++ Arrays in sqlite

2006-05-16 Thread Kevin Piciulo
associated with it. This also in my mind seems like blob is the way to go. John Stanton wrote: Do you intend to access array elements using SQL? Kevin Piciulo wrote: Hey everyone, This may not be the place to ask (if not please direct me.) I'm relatively new to sql, and newer to sqlite

[sqlite] C++ Arrays in sqlite

2006-05-15 Thread Kevin Piciulo
Hey everyone, This may not be the place to ask (if not please direct me.) I'm relatively new to sql, and newer to sqlite. Through experimenting i've figured out how to add a string to a table, create a table, remove a string, some basic stuff like that. What I'd like to do is add an

Re: [sqlite] C++ Arrays in sqlite

2006-05-15 Thread Kevin Piciulo
,but I'm sure someone else will post something more helpful than me. Mark -Original Message- From: Kevin Piciulo [mailto:[EMAIL PROTECTED] Sent: 15 May 2006 17:31 To: sqlite-users@sqlite.org Subject: [sqlite] C++ Arrays in sqlite Hey everyone, This may not be the place to ask