Re: [sqlite] Problem with Inserting Records into Large Database

Hi, Marcus! 1. Why did I use get table? I was following an example and never considered using a select statement (which makes more sense...). 2. Yes, I did check the error-codes and found nothing unusual. 3. I did consider that. I tried changing max_len to 50 and even 75. No change.

Re: [sqlite] Problem with Inserting Records into Large Database

BTW, I'm running SUSE in a VMware 6.5 VM with 1 processor and 512MB of memory. With the VM running, I have two xterms open (one to compile/run the program and one to check the status of sqlite3 records) along with gedit to edit the program. Thus, I'm nowhere near my memory limits. I'm thinking

[sqlite] Problem with Inserting Records into Large Database

Ok, this problem has me both very puzzled and frustrated. I'm running sqlite3 version 3.6.10 under SUSE 10.3. The file contains executable code that both works and fails depending upon the number of records in the database. The movie database currently has 525 DVDs in it. Most of the movies

Re: [sqlite] Passing Arguments to SQLite3 from C++

Thanks, Ted. I'll give this a shot. Regards, Nick. Teg wrote: > > Hello nshaw, > > std::string m_sSQL = "CREATE TABLE IF NOT EXISTS "; > m_sSQL += g_pszTableName; > m_sSQL += "(" ; > m_sSQL +=

[sqlite] Passing Arguments to SQLite3 from C++

Help! I've done everything I can think of to pass arguments to SQLite and nothing is working. If anyone has information on how to do it, I'd appreciate it. Here's a code segment: #include #include #include #include "util.h"

[sqlite] Newbee Question

I upgraded from 3.3.1.3 to 3.3.1.4. Up till now, I've been experimenting with SQLite3 via the CLP. Now, I'm trying to access a DB via a C program but I'm getting errors. Here's a small code fragment: #include #include #include "sqlite3.h" int main (int argc, char **argv) { sqlite3 *db;