Re: [sqlite] New to SQLite and I have a question

2010-09-12 Thread Bob Keeland
Yes, I got an email from Olaf, and I will definitely take any help I can get. Such help from the VBForum was instrumental in my program for reading EXIF data from digital photographs.   Bob --- On Sun, 9/12/10, Bart Smissaert wrote: From: Bart Smissaert

Re: [sqlite] New to SQLite and I have a question

2010-09-12 Thread Bob Keeland
Rich,   It is good to hear from another ecologist. You will probably understand my need (desire) to make an electronic plant key. I've had to carry Too Many large and heavy plant keys with me in the field. Something on a PDA or a smart phone would be much easier to carry and probably

Re: [sqlite] Issues .import(ing) a .csv file

2010-09-12 Thread Rich Shepard
On Sun, 12 Sep 2010, Simon Slavin wrote: > That's one danger, depending on how you have set up your delimiters. I > think your earlier post about commas is more likely to solve your problem. Simon, Yup. It did. Thanks, Rich ___ sqlite-users

Re: [sqlite] Issues .import(ing) a .csv file

2010-09-12 Thread Simon Slavin
On 12 Sep 2010, at 4:01pm, Rich Shepard wrote: > On Sun, 12 Sep 2010, Simon Slavin wrote: > >> Any commas in it ? Any single or double quotes ? > > Probable. I need to look. > > There are apostrophe's in a long text column that I thought might be > interpreted as single quotation marks.

Re: [sqlite] New to SQLite and I have a question

2010-09-12 Thread Rich Shepard
On Sun, 12 Sep 2010, Bob Keeland wrote: > Access may not be the best database for my programs, but then again my > needs are not that great. I just need to search a database and then search > the results of the first search, then search the results of the second > search, etc. That sounds simple

Re: [sqlite] New to SQLite and I have a question

2010-09-12 Thread Bart Smissaert
To use SQLite in classic VB or VBA you need this free wrapper: http://www.thecommon.net/3.html I have been using it for a few years now (in a commercial application) and it is fast and easy plus excellent support from the author Olaf Schmidt. RBS On Sat, Sep 11, 2010 at 9:27 PM, Bob Keeland

Re: [sqlite] New to SQLite and I have a question

2010-09-12 Thread Bob Keeland
Jay, Thanks for the reply. I'll have to reconsider my book purchase. By the way, I love the quote at the bottom of your email. As a professional scientist I've found that when I try to explain what I do most people's eyes tend to glaze over, etc.   My step-son is a computer chip designer. When

Re: [sqlite] New to SQLite and I have a question

2010-09-12 Thread Bob Keeland
Mike,   Thanks for the info. I'll go ahead and get the Mike Owens book to start with. Other books may follow. Yes, I live in Microsoft's world, but not by choice. I worked for the federal government for 25 years and was at the mercy of people higher up on the food chain most of the time. For

Re: [sqlite] New to SQLite and I have a question

2010-09-12 Thread Rich Shepard
On Sat, 11 Sep 2010, Sam Carleton wrote: > If you need to learn the basics of SQL, I would highly recommend the book SQL > For > Smarties. > It covers all the basics and a lot more. I also have his book

Re: [sqlite] New to SQLite and I have a question

2010-09-12 Thread Rich Shepard
On Sat, 11 Sep 2010, Bob Keeland wrote: > While I greatly appreciate the help I've gotten on SQLite in general, I > still wonder about the last part of my questions below. Can anyone > recommend a good book for learning to use SQLite? What about these that I > found on Amazon.com > The

Re: [sqlite] Issues .import(ing) a .csv file

2010-09-12 Thread Rich Shepard
On Sun, 12 Sep 2010, Simon Slavin wrote: > Any commas in it ? Any single or double quotes ? Simon, Probable. I need to look. There are apostrophe's in a long text column that I thought might be interpreted as single quotation marks. Thanks, Rich

Re: [sqlite] Issues .import(ing) a .csv file

2010-09-12 Thread Rich Shepard
On Sat, 11 Sep 2010, Melton Low wrote: > When you saved the spreadsheet as a csv file, you probably took the > default delimiter which happens to be a comma. You should check for a > cell with data that has a comma in it. The embedded comma would be treated > as a column separator which would

[sqlite] ON DELETE CASCADE not working, version 3.6.23.1

2010-09-12 Thread Mark Rainess
Hello all, I have PRAGMA foreign_keys = ON With: pysqlite version is 2.4.1 sqlite3 version is 3.6.23.1 And the tables: CREATE TABLE tags_product ( id INTEGER PRIMARY KEY, tag_id INTEGER NOT NULL, product_id INTEGER NOT NULL,