Thanks for your suggestions!
On Monday 06 June 2005 05.22, Ulrik Petersen wrote:
Hi Karim,
Cláudio Leopoldino wrote:
You may use EXPLAIN clause and verify the reazon...
Cláudio
Hi!
I hope to get some feedback whether the query time is what I should
expect.
Running this query
What is the best way to create an empty sqlite3 database?
I mean without tables and rows inside it.
The problem is that if I create a 0 length file, when I try to open
it with sqlite3_open I get the error file is encrypted or is not a
database.
Maybe a possible solution could be to manually
Hello there,
I have two tables and used constraint ON_DELETE_CASCADE in one of the table
to delete records from second table if records from first table are deleted
which foreign key points to first table. I'm using SQLiteExplorer to
manipulate tables. But it is not working properly. I found all
It appears that SQLite 3 doesn't
actually do anything until a table
is created. Try this:
sqlite3 db
SQLite version 3.2.1
Enter .help for instructions
create table x (y);
drop table x;
.quit
[EMAIL PROTECTED] 6/6/2005 9:31:26 AM
I don't seem to get that. Maybe you're using an old version.
On Jun 6, 2005, at 7:36 AM, Helmut Tschemernjak wrote:
The data is not encrypted.
What makes you think it is a SQLite database (a slightly rhetorical
question as I'm pretty sure I know what makes you think that). But,
and this isn't rhetorical, what makes you think it isn't encrypted?
Will Leshner wrote:
On Jun 6, 2005, at 7:36 AM, Helmut Tschemernjak wrote:
The data is not encrypted.
What makes you think it is a SQLite database (a slightly rhetorical
question as I'm pretty sure I know what makes you think that). But, and
this isn't rhetorical, what makes you
On Jun 6, 2005, at 6:01 PM, Helmut Tschemernjak wrote:
Just do a less on the .db files and you can see the information is
in clear text. I will investigate into it a little bit more.
I did on one file, but it was not clear text. Do you see a SQLite
header on the files?
Hello there,
Will you please tell me when SQLite will be supporting FOREIGN KEYS and
ON_DELETE_CASCADE? Where can I get more information about version and what's
new feature?
As well as Can someone guide me about how to write and fire trigger that
could do work of ON_DELETE_CASCADE
Regards,
Ajay