Hi,
I am using "PRAGMA table_info(table-name);" to the the schema info of a
table, but I could not customize the returned field name, such as:
I wish "cid" to be ColumnID.
normally we do by this:
"SELECT cid AS ColumnID FROM (table-name);"
but now I could not. is there anyway work out?
As a courtesy to my users, I wish to pop up a message thingy telling the user when the program is waiting for the database to not be busy. Right now I register a busy handler, and so I know how long I have been waiting, because we have the count parameter, when it is 1, I look at the clock, when th
On Sat, 2005-07-30 at 18:18 -0700, Cory Nelson wrote:
> something like sql server is likely better for the task. sqlite can
> lag quite a bit when it needs to get file locks over the network to
> stay atomic.
The point of this thread is that SQLite cannot be _atomic_ over [any]
networked filesyst
On Wed, 2005-08-03 at 08:46 -0500, Henry Miller wrote:
> >In my opinion system time stamps etc are not a reliable means of
> >comparing 2 files. Many things can change the timestamp of a file,
> >without changing the contents, and one (server) os/filesystem can
> >report a different file size to an
Hello All,
I've using SQLite 2.8.16 with a music management application, and I'm
trying out why certain queries take a long time and to figure out how
SQLite uses my indexes. I've got a master "media" table with a couple
of auxiliary tables like "artists", "albums", and "genres". Each
table's
Austin Ziegler wrote:
On 8/3/05, Khamis Abuelkomboz <[EMAIL PROTECTED]> wrote:
Hi
I'm using SQLite in my application and am very excited about this little
and fast database.
How can I retrieve the last created autoincrement value?
On MySQL and SQLServer or just the SQL standard I can fire
David Fowler wrote:
Query 2:
SELECT * FROM table1, table2
WHERE ((table1.value LIKE "%value%" AND table1.table2_id = table2.id)
> OR (table1.value LIKE "%different_value%" AND table1.table2_id =
table2.id)); This query (and even more complex versions of it) works in
MySQL (Haven't tried anoth
On 8/3/05, Khamis Abuelkomboz <[EMAIL PROTECTED]> wrote:
> Hi
>
> I'm using SQLite in my application and am very excited about this little
> and fast database.
>
> How can I retrieve the last created autoincrement value?
> On MySQL and SQLServer or just the SQL standard I can fire the following
>
Hi
I'm using SQLite in my application and am very excited about this little
and fast database.
How can I retrieve the last created autoincrement value?
On MySQL and SQLServer or just the SQL standard I can fire the following
select statement:
SELECT @@IDENTITY
Is there a similar way to do s
Hi,
I have a requirement where I need to update 2 tables in 2 separate
DBs within a transaction. Do I need to attach the second table to the
first at the start of the transaction? As I understand SQLite commits
a transaction across a single DB only?
Thanks!
Jens:
Thanks. I did see that suggested elsewhere in this list and I am
proceeding that way in order to use any of the shell functionality.
Thanks,
Dan
Jens Miltner wrote:
Am 03.08.2005 um 20:50 schrieb Dan Wellisch:
Hello:
I understand there is the .import function for the sqlite3 comm
Am 03.08.2005 um 20:50 schrieb Dan Wellisch:
Hello:
I understand there is the .import function for the sqlite3 command
interface, but I need to execute this function from within the
C API. What do I use to do this? I need to execute this type of
function from within my C++ program, not t
Hello:
I understand there is the .import function for the sqlite3 command
interface, but I need to execute this function from within the
C API. What do I use to do this? I need to execute this type of
function from within my C++ program, not the command line.
Thanks,
Dan
On 8/3/2005 at 10:34 djm wrote:
>Wednesday, August 3, 2005, 4:41:24 AM, you wrote:
>
>> No, none of those things are guaranteed. If there's even a single
>> writer it can be unsafe (consider AFS putting a corrupt journal up
>> that clients notice download, and thrash their local copy).
>
>But Im
On Wed, 2005-08-03 at 10:34 +0200, djm wrote:
> Hello,
>
> Wednesday, August 3, 2005, 4:41:24 AM, you wrote:
>
> > No, none of those things are guaranteed. If there's even a single
> > writer it can be unsafe (consider AFS putting a corrupt journal up
> > that clients notice download, and thrash
Am 02.08.2005 um 19:18 schrieb D. Richard Hipp:
On Tue, 2005-08-02 at 09:30 -0400, D. Richard Hipp wrote:
On Mon, 2005-08-01 at 22:04 +0200, Jens Miltner wrote:
we get an assertion (no crash here, though) in btree.c
and the backtrace looks similar to the one scunacc provided, which
made me
Hello L. S.,
you can create a HTML version by running the TCL scripts which are part of the
tarball sources.
I have compiled a MS Windows HTML Help document from these. The Help file is
part of DISQLite3, a Delphi wrapper of SQLite3. Even if you do not use Delphi,
you might still be interested
Hello,
Wednesday, August 3, 2005, 4:41:24 AM, you wrote:
> No, none of those things are guaranteed. If there's even a single
> writer it can be unsafe (consider AFS putting a corrupt journal up
> that clients notice download, and thrash their local copy).
But Im saying there -wont- be a single w
18 matches
Mail list logo