Hello,
Has anyone else had any problems getting the column names pragmas
working in SQLite 3.x ?
I can't seem to get them to work, and can't find anything relating to
the latest version on the website.
Thanks,
Steve
-Original Message-
From: Drew, Stephen
Sent: 06 April 2005 11:57
To:
> After thinking about this a bit more, I realized that writing a
> trigger that didn't trigger for the locker is pretty simple. So I'm
> thinking that triggers would work in this situation, but I'm
> wondering if anybody has ever done anything like this before.
>
That really seems like a
Will Leshner wrote:
On Apr 6, 2005 10:43 AM, Will Leshner <[EMAIL PROTECTED]> wrote:
After thinking about this a bit more, I realized that writing a
trigger that didn't trigger for the locker is pretty simple. So I'm
thinking that triggers would work in this situation, but I'm wondering
if anybody
Hi there,
1. i get the following error;
c:\>sqlite.exe 1.db
Unable to open database "1.db": database disk image is malformed
so i can't execute pragma integrity_check.
2. this is the corrupted file:
00: 2A 2A 20 54 68 69 73 20 ? 66 69 6C 65 20 63 6F 6E ** This
file con
10: 74
On Apr 7, 2005 7:44 AM, Kervin L. Pierre <[EMAIL PROTECTED]> wrote:
> I know your pain :) . Finer grain locking would be
> great.
Yes. We may simply be trying to use SQLite for something it just
wasn't designed for. On the other hand, if you are using SQLite as
your single-user database, it
other than encoded and not encoded.
i did not find the length limitations in the
documentation but seems like TEXT can only hold less
than 250 chars. is it true or is it SqliteExplorer
that only shows 250 chars. Thanks.
Drew, Stephen wrote:
Hello,
Has anyone else had any problems getting the column names pragmas
working in SQLite 3.x ?
My experience has been that they don't work as advertised in the
documentation in recent versions. However, I don't normally use them, so
it hasn't been a problem for me.
I
Jay wrote:
Oh. Nifty. I would therefore be safe doing this:
begin immediate;
insert into master_table() values();
insert into related_table( master_id, data )
select last_insert_rowid(), 'stuff';
commit;
But it would fail if I had multiple related tables?
begin immediate;
insert into
jack wu said:
> i did not find the length limitations in the
> documentation but seems like TEXT can only hold less
> than 250 chars. is it true or is it SqliteExplorer
> that only shows 250 chars. Thanks.
That's not a limitation of SQLite. I'm regularly storing strings larger
than that in a
I think from recent discussions, it became clear that supporting these
extra pragmas was
becoming a big headache. I don't know that tsupport has been
deliberately dropped, but
it may have fallen by the wayside. The reasons for this are that the
behavior now matches
all the other RDBMSes in
It is a limitation of sqliteExplorer.
> -Original Message-
> From: jack wu [mailto:[EMAIL PROTECTED]
> Sent: Thursday, April 07, 2005 7:05 PM
> To: sqlite-users@sqlite.org
> Subject: [sqlite] what is the difference between TEXT and
> BLOB data type?
>
>
> other than encoded and not
Thanks much - one more question though...
I'm attempting to copy data from an in memory database to
another db (file or otherwise). Is it possible to attach an
existing in-memory database to another existing db connection?
(attach database :MEMORY: would just seem to create another in
mem db).
I am trying to create a table after creating a select statement which
selects records from an existing table. Is this possible? I get a
SQLITE_LOCKED / "database table is locked" error when I attempt this.
In psuedo code the logic is as follows:
select_stmt = db.execute("SELECT * FROM
Hi, everyone:
When using the Sqlite (version for Linux 2.8.11) under Symbian I found it
always cannot free the memory allocated itself and I have to do it myself.
For instance, we must use the sqlitefree() after each sqliteMalloc(),
otherwise my Symbian UI will report to me an error
14 matches
Mail list logo