Re: [sqlite] Need sql query help

2006-06-25 Thread onemind
Thanks for all of the great ideas :) Plently of techniques to work on there. Just incase your interested, i woke up this morning and all the words finally made it into sqlite :) It took over 8 hours, so if anyone could tell me a text command that would do this same task of importing a txt file

Re: [sqlite] Need sql query help

2006-06-25 Thread onemind
Thanks, The thing is, i am going to need to use different letters each time to search through over 200,000 words in a database and it needs to be fast. What technology would be best suited for this task? I just assumed that a databse would be ideal, why do you say sql isn't suited for this and

Re: [sqlite] Sqlite crashes when i imort huge list

2006-06-25 Thread onemind
Aha, sorry Richard, it seems you may have been right. I downloaded a different gui call SQLite Administrator and it is importing now. The first gui i used, used 100% of my cpu and crashes, this new one doesn't use much but it is a sloow process.Have been running it for about 10 mins

[sqlite] Where is the sqlite3.h file?

2006-06-25 Thread onemind
Hi, I am trying to use the .dll with c but it doesn't come with the eader file. Also, what is the.def file that comes with it? Thanks for any info -- View this message in context: http://www.nabble.com/Where-is-the-sqlite3.h-file--t1844421.html#a5034422 Sent from the SQLite forum at

[sqlite] Need sql query help

2006-06-25 Thread onemind
Hi, I was hoping someone could tell me if it was possible to select all words containing ceratin letters. Eg If i had a table wit a word column that had a huge list of words and i wanted to select every word that contained all these letters "qdsa". Then it would return the words: quads

Re: [sqlite] Sqlite crashes when i imort huge list

2006-06-25 Thread onemind
Thanks guys, Richard: The reason i didn't mention the software is because all guis just create the text commands anyway so they all do the same thing. I doubt it is a problem with the gui i used which was "SQLite database browser". Chris: Thanks for that but i dont know how that helps me. Are

[sqlite] Sqlite crashes when i imort huge list

2006-06-24 Thread onemind
Hi, I am using the sqlite gui and click import table from csv. I select a txt file that contain over 200,000 words in a list. Sqlite works fine with a smaller list of 200-300 words but when i import my big list, it hangs for ages or completely crashes my computer. Does anyone know how i can