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, I'm
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:
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
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, Bent
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
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
- 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
- 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
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 usually
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
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
11 matches
Mail list logo