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

2009-02-21 Thread nshaw
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

2009-02-21 Thread Marcus Grimm
Hello, I looked for a while at you code. I can't see why it fails but I have a few remarks: 1. Why do you use get_table and parse the result instead of simply doing a query like select Title from movies where Title = 'NewTitle' and check if you get an empty result set? 2. Did you try

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

2009-02-21 Thread nshaw
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