Some strange effect of the round expression :
sqlite> select round(1-0.5);
0
sqlite> select round(2-0.5);
2
sqlite> select round(3-0.5);
2
sqlite> select round(4-0.5);
4
sqlite> select round(5-0.5);
4
sqlite> select round(6-0.5);
6
sqlite>
On Wed, 2005-07-27 at 13:31 -0400, Andrew Piskorski wrote:
> On Tue, Jul 26, 2005 at 10:21:22PM -0400, Mrs. Brisby wrote:
>
> > That's incorrect. Threading increases development time and produces less
> > stable applications. In fairness: it's the skill level of the engineer
...
> When people - ev
On Wed, 2005-07-27 at 09:08 +0100, Paul Smith wrote:
> At 03:21 27/07/2005, Mrs. Brisby wrote:
> >On Mon, 2005-07-25 at 09:48 -0500, Jay Sprenkle wrote:
> > > The theory has been proposed that threads aren't better than separate
> > > processes, or application implemented context switching. Does an
On Tue, 2005-07-26 at 23:20 -0400, Kervin L. Pierre wrote:
> We get all those threads related questions because SQLite
> is difficult to use with threads and has sparse sometimes
> conflicting documentation on the subject.
Maybe people think that SQLite should serialize its own internals. Maybe
th
> From: Tito Ciuro <[EMAIL PROTECTED]>
> Date: Wed, 27 Jul 2005 13:10:45 -0400
> To: sqlite-users@sqlite.org
> Subject: Re: [sqlite] ALTER TABLE: Confusing documentation
>
> On 27/07/2005, at 13:04, Kurt Welgehausen wrote:
>
> > The docs are correct; you just have to read carefully.
>
> I have :-)
On Tue, Jul 26, 2005 at 10:21:22PM -0400, Mrs. Brisby wrote:
> That's incorrect. Threading increases development time and produces less
> stable applications. In fairness: it's the skill level of the engineer
Mrs. Brisby, that is probably quite correct in at least one particular
sense, but since
On 27/07/2005, at 13:04, Kurt Welgehausen wrote:
The docs are correct; you just have to read carefully.
I have :-)
They say that you can "rename, or add a new column to,
an existing table".
No, it doesn't.
It states that you can "rename or add a new column to an existing
table."
Regar
The docs are correct; you just have to read carefully.
They say that you can "rename, or add a new column to,
an existing table".
Regards
Hello,
The ALTER TABLE page (http://www.sqlite.org/lang_altertable.html)
states:
SQLite's version of the ALTER TABLE command allows the user to
rename or add a new column to an existing table. It is not possible
to remove a column from a table.
The RENAME TO syntax is used to rename the
-Original Message-
From: Mark Allan [mailto:[EMAIL PROTECTED]
Sent: Wednesday, July 27, 2005 10:53 AM
To: sqlite-users@sqlite.org
Subject: [sqlite] UPDATE - crash when many columns
Hi,
I am using SQLite on an embedded software product.
I seem to have a problem when I update more than 6
On Wed, 27 Jul 2005, Mark Allan wrote:
>
>Hi,
>
>I am using the SQL command:-
>
>UPDATE PATIENTS SET
>FIRSTNAME=?,SURNAME=?,SEX=?,WEIGHT=?,HEIGHT=?,FACTOR=?,DYSPNOEA_SCORE=?,SMOKING_STATUS=?,OCCUPATION=?,REFERRED_BY=?
> WHERE PATIENT_ID = '296'
>
>or similar, where the values for the ?'s are all
It looks like libtclsqlite3.dylib either didn't get made
or is in the wrong place. You can search your disk to see
whether it got made. There's a switch in the Makefile
that determines whether it gets made or not.
OS X has been discussed several times on this list. You
might try searching the arch
On Wed, 27 Jul 2005, Edwin Knoppert wrote:
>I reread the faq hundred times but i don't understand the \000 remark.
>
>For INSERT how can i embed BLOB data having single quote and chr(0) bytes?
>Currently i replace all singlequotes with 2x single quotes and that works fine.
>The chr(0) byte did not
I will look that up, read something about binding.
But *can* 'escaping' be used as alternative?
- Original Message -
From: "Cory Nelson" <[EMAIL PROTECTED]>
To:
Sent: Wednesday, July 27, 2005 5:41 PM
Subject: Re: [sqlite] Sorry, trivail question probably, chr(0) in blob.
in sqlite 3
On 7/27/2005 at 16:24 djm wrote:
>Hello,
>
>It seems that the functions required for reading data without a
>callback are mising in SQLite 3? I cant find "sqlite3_compile",
>or "sqlite3_step". Am I missing something?
>
>The documentation on the website describes "sqlite_compile" and
>"sqlite_step
Hi,
I am using SQLite on an embedded software product.
I seem to have a problem when I update more than 6 columns within a single
record at one time. All columns are in the same table, they are either strings,
integers or dates.
I am using the SQL command:-
UPDATE PATIENTS SET
FIRSTNAME=?,S
Yes
On 7/27/05, Sudhir Hasbe <[EMAIL PROTECTED]> wrote:
> Hi All,
> Can we use SQL Lite Database from multiple processes at the same
> time. Example. I have a database called Customer.db. I want to use it from
> apache server for web application and also use it from a c program running
> o
On Wed, 27 Jul 2005, Paul Smith wrote:
>At 03:21 27/07/2005, Mrs. Brisby wrote:
>>On Mon, 2005-07-25 at 09:48 -0500, Jay Sprenkle wrote:
>> > The theory has been proposed that threads aren't better than separate
>> > processes, or application implemented context switching. Does anyone
>> > have an
in sqlite 3.x you can bind data to prepared statements, no escaping is required.
On 7/27/05, Edwin Knoppert <[EMAIL PROTECTED]> wrote:
> I reread the faq hundred times but i don't understand the \000 remark.
>
> For INSERT how can i embed BLOB data having single quote and chr(0) bytes?
> Currentl
I reread the faq hundred times but i don't understand the \000 remark.
For INSERT how can i embed BLOB data having single quote and chr(0) bytes?
Currently i replace all singlequotes with 2x single quotes and that works fine.
The chr(0) byte did not succeed.
I'm using the dll and don't do any c to
Hi All,
Can we use SQL Lite Database from multiple processes at the same
time. Example. I have a database called Customer.db. I want to use it from
apache server for web application and also use it from a c program running
on the server.
Regards
Sudhir Hasbe
Hello,
It seems that the functions required for reading data without a
callback are mising in SQLite 3? I cant find "sqlite3_compile",
or "sqlite3_step". Am I missing something?
The documentation on the website describes "sqlite_compile" and
"sqlite_step" which were presumably menat to be "upgrad
good to know...
> -Original Message-
> From: Dennis Jenkins [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, July 27, 2005 4:26 PM
> To: sqlite-users@sqlite.org
> Subject: Re: [sqlite] ANN: sqlite3Explorer V 1.7
>
> Dennis Jenkins wrote:
>
> > Cariotoglou Mike wrote:
> >
> >> *. new featur
Dennis Jenkins wrote:
Cariotoglou Mike wrote:
*. new feature : support for encrypted databases (WITH the licenced
version of sqlite)
http://www.singular.gr/sqlite/
Awesome! Thanks! I was hoping that you would add encryption support.
:) (We purchased our license a few weeks ago).
Ho
Cariotoglou Mike wrote:
*. new feature : support for encrypted databases (WITH the licenced
version of sqlite)
http://www.singular.gr/sqlite/
Awesome! Thanks! I was hoping that you would add encryption support.
:) (We purchased our license a few weeks ago).
However, I am unable to ge
From: John LeSueur <[EMAIL PROTECTED]>
Reply-To: sqlite-users@sqlite.org
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] New Query Question
Date: Tue, 26 Jul 2005 19:51:54 -0600
MIME-Version: 1.0
Received: from sqlite.org ([67.18.92.124]) by mc11-f29.hotmail.com with
Microsoft SMTPSVC(6.0.37
Ok Thank's for your help i will trying this !!!
[EMAIL PROTECTED] a écrit :
Hi,
unfortunately this has to do with the C calling convention used by sqlite3.dll.
By default DLLs compiled with C have the cdecl calling convention, but VB only
supports the stdcall calling convention.
You must re
Hi,
unfortunately this has to do with the C calling convention used by sqlite3.dll.
By default DLLs compiled with C have the cdecl calling convention, but VB only
supports the stdcall calling convention.
You must recompile sqlite using MS Visual C++ or other compiler and switch the
default cal
*. new feature : support for encrypted databases (WITH the licenced
version of sqlite)
http://www.singular.gr/sqlite/
hello i'm trying to open a database with VB6 without wrapper
i'm using sqlite3.dll
and it's my code :
Option Explicit
Private Declare Function sqlite3_open Lib "sqlite3.dll" (ByVal filename
As String, ByRef dbHandle As Long) As Long
Private Declare Function sqlite3_open16 Lib "sqlite3.dll" (By
Right you are. For some reason I was sure that existed. How about
defining the column as text and doing "ORDER BY + 0.0".
That won't use an index though. If you need an index you'll have
to define a collation sequence that sorts numericly.
--- [EMAIL PROTECTED] wrote:
> I tried that but got:
At 03:21 27/07/2005, Mrs. Brisby wrote:
On Mon, 2005-07-25 at 09:48 -0500, Jay Sprenkle wrote:
> The theory has been proposed that threads aren't better than separate
> processes, or application implemented context switching. Does anyone
> have an experiment that will prove the point either way?
32 matches
Mail list logo
