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 were
manually added directly into sqlite3 ("insert into movies (Title, Category,
TV) values ("","","")" as I was still working on the program. For the
program, I was using the same database but with only a few test records.
Once I got the program working (or so I thought), I copied the complete
database from my Nokia N810 to my development directory. I then added
another movie just to make sure everything was operating correctly. Well,
it didn't work and I was stumped. Here's what the program does and what
occurs with a large database:
First, the program displays all the categories that a movie can be in. I
enter a category, such as SciFi. I then enter the title of the movie, such
as "X-Men". The program then goes through all the titles in the database
looking to see if there's a match. If there is, I'm told the movie already
exists and it exits. If the movie doesn't exist, I'm asked if the movie was
recorded from TV. After that, all is written to the database. That's what
happens with a small number of records and what SHOULD happen, but doesn't,
when there are a large number of records.
As you can see from the code, I enter the movie title into a variable called
"movie_title". Each title (stored under variable "movie") in the database
is compared to "movie_title". In a small database, e.g. with less than 200
records (I don't know exactly how many) all works as it should. However, at
some point, the CONTENTS of movie_title changes. At some point, the
contents of movie_title starts changing almost as quickly as "result1[i]"
changes. What gets input into the database is whatever is in movie_title at
the time. In checking all three variables (movie_title, category, tv), only
movie_title changes. The other two remain correct.
I've removed the rest of the program as well as anything that doesn't
pertain specifically to this problem to make it easier to review.
Any ideas or help will be greatly appreciated! As I stated in the
beginning, I'm puzzled and frustrated...
And thanks, in advance!
Nick.
http://www.nabble.com/file/p22137080/test.cpp test.cpp
--
View this message in context:
http://www.nabble.com/Problem-with-Inserting-Records-into-Large-Database-tp22137080p22137080.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
