Re: [sqlite] SQL92

Heavenes Darren - Try the following link... http://www.wiscorp.com/SQLStandards.html I have know Michael M. Gorman for the past 4+ years. He has been in the ANSI SQL committee for over 20 years. He is directly involved in the standards process. Hope That Helps. Enjoy! Robert Artigas - Origi

Re: [sqlite] Performance problem

"Mrs. Brisby" <[EMAIL PROTECTED]> 07/11/2003 12:50 PM To: [EMAIL PROTECTED] cc: [EMAIL PROTECTED] Subject:Re: [sqlite] Performance problem > On Thu, 2003-11-06 at 19:00, [EMAIL PROTECTED] wrote: > > How would you handle the lack of ordering associate wit

Re: [sqlite] charindex function

Greg Obleshchuk wrote: how do I get [my function] placed into the original source? Print the copyright release at http://www.sqlite.org/cpywrtrls.html Sign it and mail me a copy. After I have your release on file, you will be permitted to contribute code. D. Richard Hipp 6200 Maple Cove

[sqlite] charindex function

Hello, I have finished a charindex function for sqlite (which is attached to this email).  When I say finished I have done the Non SQLITE_UTF8 work.   charindex give the starting position of a specific _expression_ in a string.   charindex (StringtoFind, ReferenceString,startingpos)   Can an

Re: [sqlite] SQL92

>Hello, >Does anyone have a web link to a document that details SQL92. > >regards >Greg O For that matter, I would like to see a link to the details of SQL99, or whatever the newest SQL standard is. I sorta need it, but my previous searches haven't worked... -- Darren Duncan -

Re: [sqlite] Performance problem

On Thu, 2003-11-06 at 19:00, [EMAIL PROTECTED] wrote: > How would you handle the lack of ordering associate with hash tables? > Sqlite can currently use indicies for three main tests: equals, less than, > and greater than. While hash-tables are good at finding equal-to in > constant time it usua

[sqlite] SQL92

Hello, Does anyone have a web link to a document that details SQL92. regards Greg O

Re: [sqlite] database table is locked

- Forwarded by Ben Carlyle/AU/IRSA/Rail on 07/11/2003 10:03 AM - Ben Carlyle 07/11/2003 10:03 AM To: Thiago Mello <[EMAIL PROTECTED]>@CORP cc: Subject:Re: [sqlite] database table is locked Thiago Mello <[EMAIL PROTECTED]> 08/11/2003 09:00 AM

Re: [sqlite] Performance problem

- Forwarded by Ben Carlyle/AU/IRSA/Rail on 07/11/2003 10:00 AM - Ben Carlyle 07/11/2003 10:00 AM To: "Mrs. Brisby" <[EMAIL PROTECTED]>@CORP cc: Subject:Re: [sqlite] Performance problem "Mrs. Brisby" <[EMAIL PROTECTED]> 07/11/2003 12:08 AM

[sqlite] database table is locked

Hi, Im doing a SELECT sql query, and in the callback function of this sql query I do a UPDATE, so when I do this update I get database table is locked. How I cant do the UPDATE in the second sqlite_exec() function?! Thanks, Thiago Mello ---

Re: [sqlite] Intentionally breaking SQLite integrity

Ben Nason wrote: In order to test my error handling if "PRAGMA integrity_check;" fails, I'm looking for an easy way to introduce an integrity error into a database. Any ideas? Try writing random binary data into the middle of the database file. You can do the most damage by writing random data

[sqlite] Intentionally breaking SQLite integrity

Hello, In order to test my error handling if "PRAGMA integrity_check;" fails, I'm looking for an easy way to introduce an integrity error into a database. Any ideas? Thanks, Ben -- "As I walk out my door, step into the pollution, I breathe in the problems, exhale solutions" - C-Rayz Walz, "Be

[sqlite] No tables found by ODBC driver (Windows 2000)

I discovered sqlite today and it looks promising. Many times in the past I've needed a lightweight, distributable database engine. Checking it out, I created a small, one table database, using the SQLite Database Browser. I installed the SQLite ODBC driver, set up a user DSN (My computer is

Re: [sqlite] locking

Kevin Waterson wrote: if you are inside of a transaction, can other people read the database? or does it lock the database file for the duration of the transaction? It locks the db. Regards, Frank - To unsubscribe, e-mail: [EM

RE: [sqlite] Fields parameters

> > I've got a question, how could I get the field parameters (e.g. id is > > integer and not null) I know that there is create table statment in > > SQLITE_MASTER for each table, but I want to use sqlite in program > > language > > there is no regular exp. in so it is hard to parse this statement,

Re: [sqlite] Performance problem

On Wed, 2003-11-05 at 23:59, Jonas Forsman / Axier.SE wrote: > According to the postgresql documentation, the hash algorithm is > discouraged compared to b-tree for performance reasons. > > http://www.postgresql.org/docs/view.php?version=7.3&idoc=1&file=indexes-types.html > > Note: Testing has sh