[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

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

[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] 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'

[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

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

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

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" To: sqlite-users@sqlite.org Sent: Wednesday, July 7, 2010 1:51:28 PM Subject: [sqlite] Reg: In Memory Database

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] 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"

[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] "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" To: "General Discussion of SQLite Database" Sent: Wednesday, July 7,

[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".

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