Re: [sqlite] Newbie questions

Kurt Welgehausen wrote: 2) use a cursor to browse a result set ? ... No. The sqlite_compile/step/finalize paradigm allows (requires really ) forward browsing through a result set.

Re: [sqlite] Simultaneosly using sqlite on windows

On Tue, May 11, 2004 at 10:13:12PM +0200, Bronislav Klu?ka wrote: > I've created application using SQLite as database (Windows application). The > database is on remote server and application is accesing the database > through file system (e.g. user connect server as P:\ disc and uses the path >

RE: [sqlite] SQLite and ODBC

Hi, I find I have to agree with the opinion that says keep the ODBC driver should be external to the SQLite source. Why? Well, how many other database engines, client/server or otherwise, come with an ODBC driver embedded with the engine? The answer of course is none. Plenty of vendors supply

RE: [sqlite] SQLite and ODBC

Hi, I've download the version at http://www.ch-werner.de/sqliteodbc/ and it works just fine. I was only making a suggestion that such a cool database should come bundled with an ODBC driver (meaning it's part of the development). SQLite is very cool but it does not make any sense if it

RE: [sqlite] SQLite and ODBC

Regarding: "I was more think of ways to get an SQLite Database connected to every day database objects and controls." A good point! This may be a naive comment of mine, but if you just forgot about the vanilla sqlite download page, and instead considered page:

Re: [sqlite] SQLite and ODBC

At 12:29 PM -0700 5/17/04, Raymond Irving wrote: Thanks for the feedback but I was not thinking about network connections to the database. I was more think of ways to get an SQLite Database connected to every day database objects and controls. Most of todays database tools use ODBC. One

Re: [sqlite] SQLite and ODBC

Well put, Darren. Raymond, I would say that if you need ODBC then you need to use a different database (server) all together. SQLite fills the embedded database niche perfectly but it is not a replacement for MS-SQL, MySQl, PostgreSQl, Oracle or other database *servers*. If you need a RDBMS

Re: [sqlite] SQLite and ODBC

Darren Duncan wrote: At 7:25 AM -0700 5/17/04, Raymond Irving wrote: I think SQLite should come standard with an odbc driver since ODBC is an "open standard" I disagree. .. Finally, while ODBC is very common, it isn't the only protocol for networking databases, and some people may prefer an

Re: [sqlite] SQLite and ODBC

At 7:25 AM -0700 5/17/04, Raymond Irving wrote: I think SQLite should come standard with an odbc driver since ODBC is an "open standard" I disagree. Partly this is because D. Richard Hipp would then have to start certifying it like his own code and ensuring that it is always up to date with the

[sqlite] Life of a cursor

Hello, I'm testing Jim Lyon's sqaux library and I have a question regarding cursor validity. The call _sqaux_rowset_open() copies the results to a table_rowset structure. The question I have is the following: even though a table_rowset lives after the database has been closed, does this

RE: [sqlite] Newbie questions

I would be interested in the PDF file. Shawn -Original Message- From: Stéphane Rivière [mailto:[EMAIL PROTECTED] Sent: Monday, May 17, 2004 10:22 AM To: D. Richard Hipp Cc: [EMAIL PROTECTED] Subject: Re: [sqlite] Newbie questions > place? What doe a descending index give you that you

[sqlite] SQLite and ODBC

Hi, I think SQLite should come standard with an odbc driver since ODBC is an "open standard" __ Raymond Irving

Re: [sqlite] Newbie questions

> ... why would anybody want a descending index in the first > place? What doe a descending index give you that you > don't have with an ascending index? I believe it's an optimization in some DBMSs for multi-column sorting: create index i on t (c1 asc, c2 desc); otherwise, I agree with you.

Re: [sqlite] Newbie questions

Kurt Welgehausen wrote: 1) create an index in descending order ? No. See . Read the paragraph after the syntax description. True. But ascending indices can be traversed in reverse order (if you put the DESC keyword on an ORDER BY). So why would

Re: [sqlite] Newbie questions

> 1) create an index in descending order ? No. See . Read the paragraph after the syntax description. > 2) use a cursor to browse a result set ? ... No. Regards - To unsubscribe,

RE: [sqlite] sqlite with Visual Basic

Hi, I've recently downloaded and used the ODBC driver and have not seen any problems with it thus far. It works great with ADO. In fact I was able to use it as a drop-in replacement for an MS SQL Server connection using ADO It's very easy to install. You just simple copy the files with your

RE: [sqlite] sqlite with Visual Basic

Hi Murray, Installshield has a method for creating ODBC configurations as part of the setup. If I remember, I think that there is an MS API for interacting with the ODBC setup - if all else fails, do it yourself by writing to the appropriate places in the registry. Steve -Original

[sqlite] Newbie questions

Hi to all. I'm a software and hardware engineer living in Oleron Island, located near the french atlantic ocean coast. My (new) current language is Ada. I've done extensive searches around SQLite yesterday and I still have two questions without answers : is there a way/trick/workaround to : 1)