[sqlite] Crash after add column

Hi. I Use C/Linux. After I try to ADD a column by run the querry "ALTER TABLE x ADD y NUMERIC" from my application, I can't use the data base any more. If I try to get or save any data at my DB it cause crash of the application. Thanks -- View this message in context:

Re: [sqlite] Newbie question - SQLite the best choice?

On Sat, 6 Mar 2010, Richard Cooke wrote: > Our application could have up to 10,000 users via a public facing web > site. As a first stab at the schema, I thought I'd have one "Master User" > database which will probably look like this: Richard, If I recall correctly, SQLite does not do well

Re: [sqlite] Newbie question - SQLite the best choice?

Richard Cooke wrote: > Can I use the user_id (as a FOREIGN KEY) that resides in another > database to link the two DBs together? I'm a newbie to all of theis > database design so I am using this project as a learning experience. > From my limited knowledge of MySQL I think I could have

Re: [sqlite] Problem with SQLite in BCB 4

You cannot push_back(NULL) null pointer. Fix is below: if(result == SQLITE_ROW) { vector values; for(int col = 0; col < cols; col++) {

[sqlite] Newbie question - SQLite the best choice?

Hi Folks, Please forgive me if this isn't the proper forum to post this question but I am in need of some expert advice concerning if SQLite is the best choice for my application. Our application could have up to 10,000 users via a public facing web site. As a first stab at the schema, I

[sqlite] SQLITE3 Recompiling for FTS3

For Windows: I followed the best of my ability recompiling the most current SQLITE3.DLL to get the FTS3 incorporated. I added the compiler directive SQLITE_ENABLE_FTS3 SQLITE_ENABLE_FTS3_PARENTHESIS and was able to create a SQLITE3.DLL but it faults when a example test C/C++ program runs.

[sqlite] Problem with SQLite in BCB 4

I have a problem with SQLite in BCB 4.0. I wrote my own application - I found very useful information on http://www.dreamincode.net/forums/index.php?showtopic=122300 On form (Form1) I have: Memo1 and Button3. File Unit1.cpp:

[sqlite] Problem with SELECT in BCB

I have a problem with SQLite in BCB 4.0. I wrote my own application - I found very useful information on http://www.dreamincode.net/forums/index.php?showtopic=122300 On form (Form1) I have: Memo1 and Button3. File Unit1.cpp:

Re: [sqlite] Password protection?

On 6 Mar 2010, at 3:04pm, Joe wrote: > Is there a pre-compiled SEE release available? One that matches the current > public release? As far as I know we have no need to customize SQLite, and > even if we did I am not sure we would even know how ... it isn't what we do. I think that if you

Re: [sqlite] Password protection?

Is there a pre-compiled SEE release available? One that matches the current public release? As far as I know we have no need to customize SQLite, and even if we did I am not sure we would even know how ... it isn't what we do. Joe Weinpert PGAS, Inc. - Original Message - From: "Simon

Re: [sqlite] Password protection?

On 6 Mar 2010, at 4:12am, Neville Franks wrote: > Saturday, March 6, 2010, 2:57:59 PM, you wrote: > > J> Does SQLite allow for password protecting a database? How about > J> tables, can they be individually password protected? > > No, you would need to do this in your application. A password