[sqlite] CVS branch

2004-04-23 Thread D. Richard Hipp
Users who download SQLite sources directly from CVS should note that the stable code base is now on a branch. The trunk will not compile or function at this time. Unless you want to work on the new, experimental version 3.0 of SQLite you should do the following from CVS: cvs update -r

[sqlite] ADO 2.6 Provider for SQLite

2004-04-23 Thread Raymond Irving
Hello, Does anyone know where I can get the ADO provider for SQLite (if it's available)? I'm using ADO 2.6 (not ADO.Net) and would like to access the SQLite database via the ADO objects. Many Thanks __ Raymond Irving - To

Re: [sqlite] TWS - all-in-one web server

2004-04-23 Thread D. Richard Hipp
Tom Shafer wrote: > Senario: TWS is running as the read-only-web-application server. Web clients > search & read-only. Local Clients may be updating the same SQLite db with > ODBC (they are NOT using the web app). (this is tested, and works fine) > > I have a SQLite.exe commandline backup script

[sqlite] TWS - all-in-one web server

2004-04-23 Thread Tom Shafer
Senario: TWS is running as the read-only-web-application server. Web clients search & read-only. Local Clients may be updating the same SQLite db with ODBC (they are NOT using the web app). (this is tested, and works fine) I have a SQLite.exe commandline backup script to copy everything to text

Re: [sqlite] CppSQLite

2004-04-23 Thread Mark D. Anderson
There is no copyright statement or license stated in the article or in the download. So it isn't clear what the legal status is of CppSQLite? -mda On Fri, 23 Apr 2004 14:56:45 +0100, "Rob Groves" <[EMAIL PROTECTED]> said: > For those that are interested, a new version of CppSQLite and >

[sqlite] CppSQLite

2004-04-23 Thread Rob Groves
For those that are interested, a new version of CppSQLite and accompanying article is available here: http://www.codeproject.com/database/CppSQLite.asp Main new features are support for pre-compiled SQL and multithreaded features of SQLite, plus removal of Microsoft specific C++. Cheers, Rob.

Re: [sqlite] Backing up data by date

2004-04-23 Thread Christian Smith
On Thu, 22 Apr 2004, Lloyd thomas wrote: >Thanks Christian, >Although that makes sense I can find nowhere on the >net which explains how to dump the data within a transaction. >Do you have an example. It's just like any other select, except bounded by begin and commit

Re: [sqlite] FW: Help with Porting Problem

2004-04-23 Thread Christian Smith
On Tue, 20 Apr 2004, Juan Romano wrote: >Hi, I am porting sqlite to vxworks. I use the shell to issue some >simple SQL commands. I can create a table and then I can issue insert >SQL statements, but when I try to display the data I inserted (by using >select) I always get the first record and