Re: [sqlite] New to SQLite Question - References

On 1 Nov 2012, at 2:53pm, Ryan Kool wrote: > Can you give suggestions on where to look for information on connecting to > a SQLite database from within a Java application? They're usually called 'wrappers'. Google the two words Java SQLite and pick one. Simon. __

[sqlite] New to SQLite Question - References

Hello All, Can you give suggestions on where to look for information on connecting to a SQLite database from within a Java application? I'm new to both Java & SQLite and am wondering where is the best place to start? I have been programming in C++ a long time using SQL Server so I'm not a novi

Re: [sqlite] new to sqlite rec'd BadImageFormatException error

1 > Sent: Wednesday, May 04, 2011 3:18 PM > To: sqlite-users@sqlite.org > Subject: [sqlite] new to sqlite rec'd BadImageFormatException error > > > this is the vb net code I was running > > Dim f As New OpenFileDialog > f.Filter = "

Re: [sqlite] new to sqlite rec'd BadImageFormatException error

I got it passed this error by using different SQLite library and the ADO.NET provider(an older one) its a bit confusing for a newbie. what is the newest I could use for vb net 2008? Filip Navara-3 wrote: > > What platform is set as target for the VB.NET code (x86 / x64 / Any CPU)? > Which bui

Re: [sqlite] new to sqlite rec'd BadImageFormatException error

I tried several different sqlite.dlls now it works Thanks kp2011 wrote: > > this is the vb net code I was running > > Dim f As New OpenFileDialog > f.Filter = "SQLite 3 (*.db)|*.db|All Files|*.*" > If f.ShowDialog() = DialogResult.OK Then > Dim SQLco

Re: [sqlite] new to sqlite rec'd BadImageFormatException error

g] On Behalf Of kp2011 Sent: Wednesday, May 04, 2011 3:18 PM To: sqlite-users@sqlite.org Subject: [sqlite] new to sqlite rec'd BadImageFormatException error this is the vb net code I was running Dim f As New OpenFileDialog f.Filter = "SQLite 3 (*.db)|*.db|All Files|*.*&

Re: [sqlite] new to sqlite rec'd BadImageFormatException error

What platform is set as target for the VB.NET code (x86 / x64 / Any CPU)? Which build of the SQLite library and the ADO.NET provider are you using? On Wed, May 4, 2011 at 9:17 PM, kp2011 wrote: > > this is the vb net code I was running > > Dim f As New OpenFileDialog >            f.Filter = "SQLi

[sqlite] new to sqlite rec'd BadImageFormatException error

this is the vb net code I was running Dim f As New OpenFileDialog f.Filter = "SQLite 3 (*.db)|*.db|All Files|*.*" If f.ShowDialog() = DialogResult.OK Then Dim SQLconnect As New SQLite.SQLiteConnection() Dim SQLcommand As SQLite.SQLiteCommand

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

> --- On Sun, 9/12/10, Bart Smissaert wrote: > > > From: Bart Smissaert > Subject: Re: [sqlite] New to SQLite and I have a question > To: "General Discussion of SQLite Database" > Date: Sunday, September 12, 2010, 11:28 AM > > > To use SQLite in classic VB or V

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

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 Subject: Re: [sqlite] New to SQLite

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

ere.   Bob --- On Sun, 9/12/10, Rich Shepard wrote: From: Rich Shepard Subject: Re: [sqlite] New to SQLite and I have a question To: "General Discussion of SQLite Database" Date: Sunday, September 12, 2010, 12:01 PM On Sun, 12 Sep 2010, Bob Keeland wrote: > Access may not be t

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

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 t

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

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 wro

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

designer. When he starts talking about what he does MY eyes tend to glaze over, etc.   Bob Keeland --- On Sat, 9/11/10, Jay A. Kreibich wrote: From: Jay A. Kreibich Subject: Re: [sqlite] New to SQLite and I have a question To: "General Discussion of SQLite Database" Date: Saturday,

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

the first 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 wrote: From: Rich Shepard Subject: Re: [sqlite] New to SQLite and I have a questi

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

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

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

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 Definitive

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

On Sat, Sep 11, 2010 at 06:27:16PM -0700, Bob Keeland scratched on the wall:   > The Definitive Guide to SQLite by Mike Owens Good, but older. Doesn't cover some of the newer features, including many of the _v2() interfaces. Covers SQL and basic database theory. Although this spends a

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

Bob, 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 Trees

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

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

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

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 wrote: From: Simon Slavin Subject: Re: [sqlite] New to SQLite and I have a question

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

"Bob Keeland" schrieb > I am new to using SQLite but think that it may be good > for a project that I'm working on. I do my programming > in Visual Basic and don't know any C\C++. > Is there any problem with connecting with SQLite from > Visual Basic? No. Though the links Simon gave you, are for

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

On 11 Sep 2010, at 9:27pm, Bob Keeland wrote: > I am new to using SQLite but think that it may be good for a project that I'm > working on. I do my programming in Visual Basic and don't know any C\C++. Is > there any problem with connecting with SQLite from Visual Basic? You'll need to pick a

[sqlite] New to SQLite and I have a question

Hi all, I am new to using SQLite but think that it may be good for a project that I'm working on. I do my programming in Visual Basic and don't know any C\C++. Is there any problem with connecting with SQLite from Visual Basic?   Basically my program will conduct repeatitive searches on a databas

Re: [sqlite] New to SQlite

Thank you so much for your help - Original Message - From: "Roosevelt Anderson" <[EMAIL PROTECTED]> To: "General Discussion of SQLite Database" Sent: Thursday, September 25, 2008 11:10 AM Subject: Re: [sqlite] New to SQlite > If you are using the ADO

Re: [sqlite] New to SQlite

If you are using the ADO.NET 2.0 provider from http://sqlite.phxsoftware.com/, then it won't work with Visual Studio 2003. This is because Visual Studio 2003 uses .Net 1.1 not .Net 2.0. If you wish to use the phxsoftware data provider try downloading Visual Studio Express 2005 or 2008 from Microsof

[sqlite] New to SQlite

I am new to SQlite and just migrated to vb.net from vb6 I cant find a step by step tutorial on how to add sqlite to vb.net i downloaded the sqlite wrapper but on the sqlite designer installation screen an option should show "Visual Studio 2003" i get a blank screen so i am not sure how to procee

Re: [sqlite] New to SQLite...............2....3..4 Thank you

t; <[EMAIL PROTECTED]> To: Sent: Wednesday, February 23, 2005 9:56 PM Subject: Re: [sqlite] New to SQLite...23..4 Thank you Thank you for that. I like what I am reading there. Still, TCL is mentioned together with SQLite. Is TCL an alternative to look into? Best regards Jan

Re: [sqlite] New to SQLite...............2....3..4 Thank you

ect: Re: [sqlite] New to SQLite...23 There is good PHP/SQLite introduction here: http://www.zend.com/php5/abs/php101-9.php Best regards, Witold - Original Message - From: "Jan Ekström" <[EMAIL PROTECTED]> To: Sent: Tuesday, February 22, 2005 8:36 PM Sub

Re: [sqlite] New to SQLite...............2....3

There is good PHP/SQLite introduction here: http://www.zend.com/php5/abs/php101-9.php Best regards, Witold - Original Message - From: "Jan Ekström" <[EMAIL PROTECTED]> To: Sent: Tuesday, February 22, 2005 8:36 PM Subject: Re: [sqlite] New to SQLite...2...

Re: [sqlite] New to SQLite...............2....3

rnamn, alder from exempel"); while ($row = sqlite_fetch_array($res)) { echo "rad:$row[fornamn]-> $row[efternamn]-> $row[alder]"; } ?> - Original Message - From: "Ulrik Petersen" <[EMAIL PROTECTED]> To: Sent: Tuesday, February 22, 2005 4:18 PM Subject

Re: [sqlite] New to SQLite...............2

Hi Jan, Jan Ekström wrote: I am using Windows Home Edition. I think the SQLite cammand shell is the same as windows command shell. The SQLite command shell is the sqlite.exe or sqlite3.exe file that you can download from the "Precompiled Binaries for Windows" section of the SQLite download page:

Re: [sqlite] New to SQLite...............2

I am using Windows Home Edition. I think the SQLite cammand shell is the same as windows command shell. jan - Original Message - From: "Cory Nelson" <[EMAIL PROTECTED]> To: Sent: Tuesday, February 22, 2005 3:47 PM Subject: Re: [sqlite] New to SQLite. Try the SQLite comma

Re: [sqlite] New to SQLite.

Try the SQLite command shell. On Tue, 22 Feb 2005 14:22:28 +0100, Jan Ekström <[EMAIL PROTECTED]> wrote: > Is there a best way to administrate SQLite? > Do I use PHP, TCL C or .? > Sincerely > Jan Ekström > > -- Cory Nelson http://www.int64.org

[sqlite] New to SQLite.

Is there a best way to administrate SQLite? Do I use PHP, TCL C or .? Sincerely Jan Ekström

Re: [sqlite] new to sqlite

i am new to sqlite... getting problem to for c interface to sqlite and retrove result... using suse linux... hoping ur cooperation. http://www.catb.org/~esr/faqs/smart-questions.html Roger

[sqlite] new to sqlite

  hello, i am new to sqlite... getting problem to for c interface to sqlite and retrove result... using suse linux... hoping ur cooperation. Thanking U.

Re: [sqlite] New to Sqlite

Brad, I found the problem and if I'd learn how to read :-) I wouldn't have sent the email. Now I know that nothing coming back means that all is OK and anything coming back means an error. Thanks, Michael At 10:31 AM 1/3/2005, Brass Tilde wrote: > My initial question is this: I have a set of SQL

Re: [sqlite] New to Sqlite

> My initial question is this: I have a set of SQL statements in a file that > builds my desired database. In reading the command line options for sqlite3 > it appeared the ".read" command would read this file and execute the > statements in the file specified. > Yet when I do that, I see the stat

[sqlite] New to Sqlite

Hello, I'm considering using Sqlite instead of Mysql on an embedded product. Since I only need straight forward INSERT, UPDATE, SELECT, and DELETE commands this seems like a reasonable alternative. Since this would be a new product, I thought I'd try to use Sqlite version 3. To evaluate the poss

Re: [sqlite] New to SQLite, couple of questions

"Andrew Piskorski" <[EMAIL PROTECTED]> wrote: On Mon, Dec 27, 2004 at 08:51:11PM -0800, Roger Binns wrote: Why do you need SQLite if you want everything in memory? All you gain is an SQL Parser to operate on the data structures instead of just doing it directly yourself. All? You gain the relatio

Re: [sqlite] New to SQLite, couple of questions

On Mon, Dec 27, 2004 at 08:51:11PM -0800, Roger Binns wrote: > Why do you need SQLite if you want everything in memory? All you gain is > an SQL Parser to operate on the data structures instead of just doing it > directly yourself. All? You gain the relational model, which in some cases could b

Re: [sqlite] New to SQLite, couple of questions

What are some of the limitations of using memory tables (operations, counts, etc)? Looking at Linux 32bit intel implementation (RH) and want to do some larger tables all in memory. How large you ask ... as large as I can fit in the typical 2gig workspace. Why do you need SQLite if you want everythi

[sqlite] New to SQLite, couple of questions

What are some of the limitations of using memory tables (operations, counts, etc)? Looking at Linux 32bit intel implementation (RH) and want to do some larger tables all in memory. How large you ask ... as large as I can fit in the typical 2gig workspace. Also does/can SQLite support 64 Bit O/S na