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. What I haven't done is check the length of result[i]. It's
possible something is being added that even exceeds 75.
Again - THANKS! I will switch to using a select statement to check for
existing movies (if I ever solve this problem). I do use that select
statement right now since I'm not using the program but working directly
inside sqlite3.
Nick.
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 to check the result error-codes from the various
sqlite functions?
3. The strcpy (movie, result1[i]); might overwrite your stack
in case the result string exceeds your max_len.
Maybe an error entry in the DB?
4. Are you sure to run the loop including the ncols: ?
for (int i=0; i<nrows+1; i++)
hope this helps
Marcus
--
View this message in context:
http://www.nabble.com/Problem-with-Inserting-Records-into-Large-Database-tp22137080p22138042.html
Sent from the SQLite mailing list archive at Nabble.com.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
