[sqlite] Help with SQLite and VB2010 Express

2011-01-10 Thread Bob Keeland
I've been struggling with how to use SQLite with Visual Basic2010 Express. VB2010 Express does not work with Microsoft Access (which I've used in the past) and so I have to use SQL. I don't feel that I need the capabilities of Microsoft SQL Server and so I've been looking at SQLite and MySQL.

Re: [sqlite] Help with SQLite and VB2010 Express

2011-01-10 Thread Bob Keeland
are having problems.   BobK You really don't need to run the msi. You can download the binary package and added the dlls as references and start using the dataprovider. In the future, this sort of question should be asked in the System.Data.SQLite forum. On Mon, Jan 10, 2011 at 12:10 PM, Bob

Re: [sqlite] Help with SQLite and VB2010 Express

2011-01-10 Thread Bob Keeland
Database sqlite-users@sqlite.org Date: Monday, January 10, 2011, 4:49 PM On 10 Jan 2011, at 9:34pm, Bob Keeland wrote: Obviously I don't know what I'm doing with SQLite so I'll ask the question that shows my ignorance. What is the difference between what can or should be asked on this list

Re: [sqlite] beginner

2010-12-23 Thread Bob Keeland
On SQLite I see lots of complex questions and equally complex answers posted by people who obviously know what they are doing. I, however, still need to learn the basics of using SQLite. Is there anything like SQLite-Manager that works for those of us who still use Microsoft software? I'm

Re: [sqlite] Just compiled SQLite in Visual Studio

2010-12-01 Thread Bob Keeland
?   Bob Keeland Forest Dynamics, Inc. --- On Tue, 11/30/10, Igor Tandetnik itandet...@mvps.org wrote: From: Igor Tandetnik itandet...@mvps.org Subject: Re: [sqlite] Just compiled SQLite in Visual Studio To: sqlite-users@sqlite.org Date: Tuesday, November 30, 2010, 8:06 PM Bob Keeland keela

Re: [sqlite] Just compiled SQLite in Visual Studio

2010-11-30 Thread Bob Keeland
the difference. I've been thinking about Java, but am not sure yet. Bob Keeland --- On Tue, 11/30/10, john darnell john.darn...@walsworth.com wrote: From: john darnell john.darn...@walsworth.com Subject: Re: [sqlite] Just compiled SQLite in Visual Studio To: General Discussion of SQLite Database

Re: [sqlite] Just compiled SQLite in Visual Studio

2010-11-30 Thread Bob Keeland
Oh, from the various replies I see that C++ is a more capable extension of C. Igor was only using a figure of speech, kind of. Sorry about the newbee question, but thanks for the replies.   Bob Keeland --- On Tue, 11/30/10, Simon Slavin slav...@bigfraud.org wrote: From: Simon Slavin slav

Re: [sqlite] Create Read-only Database

2010-10-10 Thread Bob Keeland
of options (selections) is reduced. What the user wants ideally is to be left with only one selection - that will be their answer. They really don't care how they get to that point. If a person updates the database they will probably make the overall program unusable.   Bob Keeland --- On Sun

Re: [sqlite] Create Read-only Database

2010-10-10 Thread Bob Keeland
A second response to this issue orf read-only. For my program the user will never directly the database. The user will make selections from the program and then the program will query the database. The user will then see how many records remain in the database and make selections from other

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

2010-09-12 Thread Bob Keeland
search, then search the results of the second search, etc. That sounds simple to me, but I'm an ecologist not a professional programmer.   Thanks again. Bob Keeland --- On Sun, 9/12/10, Rich Shepard rshep...@appl-ecosys.com wrote: From: Rich Shepard rshep...@appl-ecosys.com Subject: Re: [sqlite

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

2010-09-12 Thread Bob Keeland
he starts talking about what he does MY eyes tend to glaze over, etc.   Bob Keeland --- On Sat, 9/11/10, Jay A. Kreibich j...@kreibi.ch wrote: From: Jay A. Kreibich j...@kreibi.ch Subject: Re: [sqlite] New to SQLite and I have a question To: General Discussion of SQLite Database sqlite-users

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

2010-09-12 Thread Bob Keeland
, 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 to me, but I'm an ecologist

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

2010-09-12 Thread Bob Keeland
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 keela...@yahoo.com wrote: Hi all, I am new to using SQLite but think that it may be good for a project that I'm working

[sqlite] New to SQLite and I have a question

2010-09-11 Thread Bob Keeland
recommend a good book on SQLite? Any help or suggestions welcome (even if the answer is go away).   Bob Keeland Forest Dynamics, Inc. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

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

2010-09-11 Thread Bob Keeland
be SQLite, Access, or whatever). The data for the database will much more difficult to come up with than writing the code for the program. Thanks a lot for the help.   Bob Keeland --- On Sat, 9/11/10, Simon Slavin slav...@bigfraud.org wrote: From: Simon Slavin slav...@bigfraud.org Subject: Re

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

2010-09-11 Thread Bob Keeland
using Visual Basic 2010 Express (and have ordered a book on it).   Bob Keeland --- On Sat, 9/11/10, Olaf Schmidt s...@online.de wrote: From: Olaf Schmidt s...@online.de Subject: Re: [sqlite] New to SQLite and I have a question To: sqlite-users@sqlite.org Date: Saturday, September 11, 2010, 6:00 PM