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
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
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).
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
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
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
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
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
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.
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
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
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
> 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
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:
14 matches
Mail list logo