I'm a fairly competent but amateur Delphi programmer and I can construct all the SQL statements I need. But I'm having enormous trouble making sqlite.exe work.
Can some kind person please tell me <exactly> what, right down to the last dot and semi-colon, I should type in at the sqlite> prompt to open a SQLite3 database called "BaseStation.sqb" located in the same folder as sqlite and then to get a simple SQL query like "select * from Aircraft" to come up with some data on screen, or preferably save it to a disk file? Whatever I try I get either a syntax error response or one saying that table Aircraft does not exist. Which is strange as other programs like SQLiteSpy will quite happily display all 7000 records in this supposedly non-existent table. And yes, I have read the available guidance and done my best to follow it, to no avail. I would like to feed instructions into sqlite.exe from my own Delphi program and then manipulate the result. I've done that before with other command line programs. I've tried various Delphi sqlite wrappers but they won't cooperate with me either. The database is created by a commercial program and is certainly constructed and manipulated through an accompanying sqlite3.dll. I just need to get more detailed data out of it than I can using the limited analyser built into the program, and it's fairly important that it all happens with one click of a GO button that can be programmed to happen automatically in my absence at a certain time - otherwise I'd just use SQLiteSpy and copy and paste the data it displays. Thanks in advance. Michael Hooker Surrey, England -----Original Message----- From: Ken [mailto:[EMAIL PROTECTED] Sent: 29 December 2006 23:04 To: sqlite-users@sqlite.org; [EMAIL PROTECTED] Subject: Re: [sqlite] Joining tables in a single file I think the attach is the way to go, but no need to insert, just select from the attached databases. sqlite3 master.db (master is empty). attach a.db A attach b.db B attach c.db C Then : select <columns> from a.A, b.b, c.c where .... Alberto Simões <[EMAIL PROTECTED]> wrote: Hi I am using SQLite to store ngrams from texts (bigrams, trigrams and tetragrams). This is not really important for the question; just imagine I have three tables A (int,int), B (int, int, int) and C (int, int, int, int). As the table keys are full rows and the tables get big, it is not quite efficient com compute bigrams, trigrams and tetragrams at the same time. Given that I have access to a cluster, I split the job in three tasks that can be computed separately on different cluster nodes. One calculates bigrams, another trigrams, and other to calculate tetragrams. So far, everything fine. The problem is that this results in three different files each with a table. I need to join tables in the same file. There are no dependencies between tables, thus you can imagine that I need something like: cat A.db B.db C.db > full.db # kidding I can do an export and import for each table. But I would like to know if there is any faster method. Thank you Kind regards, Alberto -- Alberto Simões ---------------------------------------------------------------------------- - To unsubscribe, send email to [EMAIL PROTECTED] ---------------------------------------------------------------------------- - -- No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.1.409 / Virus Database: 268.15.29/608 - Release Date: 29/12/2006 -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.1.409 / Virus Database: 268.15.29/608 - Release Date: 29/12/2006 ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------