[sqlite] working with a many-to-many relationship

I have never worked with 2 tables in a many-to-many relationship and could use some help. I have done some research and have the following understanding: given: table a    _id integer primary key,    a_data varchar(40); table b    _id integer primary key,    b_data

[sqlite] How to invoke successive SQLite script files

I have a file which contains SQLite and SQLite/SQL commands. I can invoke that file and successfully execute all of the commands in that file by starting a SQLite cmd line session and using the .read command. I'll refer to that as script-C. What I would like to do is create a higher

Re: [sqlite] How to invoke successive SQLite script files

Thanks Kees for your response. I tried embedding the .read command into my sql script files and it appears to work fine. One thing I don't like is having to specify the full path (relative to where I'm invoking SQLite3 from) to each file I reference in the scripts I invoke with .read.

[sqlite] restricting values allowed in a column

I have a table schema that looks like this: _ID integer primary key autoincrement name varchar(40) category varchar(40) recommendation varchar(40) I would like to restrict the values that are entered into the recommendation column. How would I state that at the time I create the

Re: [sqlite] restricting values allowed in a column

Hi Jay, Creating a new db with the added constraint is not  problem for me at this time. If I wanted to allows only values yes or no or maybe in the recommendation column would I do it like this when I created the table -    recommendation varchar(4) CHECK(recommendation='yes' |

Re: [sqlite] importing data from file with 3 colums to table with 4 columns

Thanks Monte for your response. I am still pretty new to SQlite, but it looks very similar to what Simon suggested. I think it would work just as well. From my perspective the ideal way to do this would be to specify the columns names the following data in the file is to load into.

Re: [sqlite] Reg: In Memory Database Using SQLite

Hi Subhadeep, I'm not seeing the source code included anywhere in your email. Thx -Chris - Original Message - From: Subhadeep Ghosh subhadeep.gh...@uniken.com To: sqlite-users@sqlite.org Sent: Wednesday, July 7, 2010 1:51:28 PM Subject: [sqlite] Reg: In Memory Database

Re: [sqlite] Reg: In Memory Database Using SQLite

Yes, please do send it to me. Thx -C - Original Message - From: Subhadeep Ghosh subhadeep.gh...@uniken.com To: General Discussion of SQLite Database sqlite-users@sqlite.org Sent: Saturday, July 10, 2010 7:42:03 AM Subject: Re: [sqlite] Reg: In Memory Database Using SQLite Hi

Re: [sqlite] adb shell command gives very inconsistent results

My apology. It was late when I posted this and wasn't paying enough attention to where I was posting it to. -Chris - Original Message - From: Simon Slavin slav...@bigfraud.org To: General Discussion of SQLite Database sqlite-users@sqlite.org Sent: Wednesday, July 7, 2010

[sqlite] importing data from file with 3 colums to table with 4 columns

Hello, I have a db tbl with the following schema: _ID integer primary key autoincrement name varchar(40) category varchar(40) recommendation varchar(40) I have a data file I want to import which contains 3 columns worth of data. It looks like this: Barracuda|seafood|No

Re: [sqlite] importing data from file with 3 colums to table with 4 columns

Thank you very much Simon. That worked very slick. Say, is there a way to put all of the SQLite3 commands  I used into a script and have SQLite3 execute them in the script sequentially? -Chris - Original Message - From: Simon Davies simon.james.dav...@googlemail.com To:

[sqlite] adb shell command gives very inconsistent results

 I do not own an Android phone and am working exclusively in the Eclipse/emulator environment on my laptop. When I type in the adb shell cmd from the tools directory I get very inconsistent results. Sometimes it says error: device not found. Sometimes it says error: device offline. If I

Re: [sqlite] working with existing (look-up) database in Android/Eclipse

Hi Simon, Thanks very much for getting back to me. You wrote - Specify the full path of your file when you open the file.  For example /assets/databases/events.db. That is my problem, I don't know how to do that. Based on my current [limited] understanding of how Android opens a