Thanks for your reply Igor.
When we checked with the provided query we found that the duplicate values
are present in the BrandDescription. We are working with the device where
the memory is limited. We are suppose to sort the data by
BrandDescription.When we tried with "ORDER BY BrandDescription
Hi Folks:
I'm new to this list and just came across a major issue so I thought I'd
post here: I'm using SQLite (from REALbasic which uses the SQLite DB engine
for SQL support) to store image files, and while R/W to local files is
excellent, the same operations on files residing on a remote volume m
When I execute sql statement "delete from Carimages where OpTime <'2008-05-01
00:00:00'" in my database, sqlite3 crashed.
The Exception Information reported by XP is:
Code: 0xc005 Flags:0x
Record: 0x Address: 0x00406652
The sqlite3.exe is
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Virgilio Alexandre Fornazin wrote:
> A good and new safe could be a sqlite3_close_v2() call prototyped like
>
> int sqlite3_close_v2(sqlite3 * db, int closePendingStatements);
Funnily enough that is exactly what I provide in my Python wrapper for
SQL
A good and new safe could be a sqlite3_close_v2() call prototyped like
int sqlite3_close_v2(sqlite3 * db, int closePendingStatements);
and current sqlite3_close() call could become
int sqlite3_close(sqlite3 * db)
{
return sqlite3_close_v2(db, 0);
}
In this way, current running code does
> Does anybody have any thoughts on this proposed behavior changes for
> the sqlite3_close() interface?
>
> D. Richard Hipp
> [EMAIL PROTECTED]
Fine with me.
- Richard Klein
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:808
It seems like a programmer error if a statement remains unfinalized when
the DB is closed. It would be great if something about the API would
help programmers detect and fix errors like this. Having sqlite3_close
return an error helped a little, because it made you aware there was a
problem, but
On May 13, 2008, at 8:02 PM, Scott Hess wrote:
> On Tue, May 13, 2008 at 4:51 PM, D. Richard Hipp <[EMAIL PROTECTED]>
> wrote:
>> The currently documented behavior of sqlite3_close() is that when it
>> called on a database connection that has unfinalized prepared
>> statements is to return SQLI
On Tue, May 13, 2008 at 4:51 PM, D. Richard Hipp <[EMAIL PROTECTED]> wrote:
> The currently documented behavior of sqlite3_close() is that when it
> called on a database connection that has unfinalized prepared
> statements is to return SQLITE_BUSY and fail to close the connection.
> The rational i
The currently documented behavior of sqlite3_close() is that when it
called on a database connection that has unfinalized prepared
statements is to return SQLITE_BUSY and fail to close the connection.
The rational is that we did not want a call to sqlite3_close() to
destroy sqlite3_stmt*
Yes, I completely agree. But a single "undoable event" generates
multiple changes to the database (which might as well be done inside a
single transaction). Thus one click on Undo results in multiple changes
to undo the event (ie, undoing the entire event's transaction). This
implies that so
On May 13, 2008, at 6:21 PM, David Barrett wrote:
> True, but even an application would need to "undo" in transactions,
> I'd
> think. Like, if a user drags a widget from column A to B, it
> generates
> an INSERT in one column and a DELETE in another. Pressing Undo once
> would leave it in
True, but even an application would need to "undo" in transactions, I'd
think. Like, if a user drags a widget from column A to B, it generates
an INSERT in one column and a DELETE in another. Pressing Undo once
would leave it in both columns, which is probably unexpected.
Anyway, I was more t
the Undo/Redo mechanism described is not really for transactions but rather a
"Button" within an application. So that the user can undo/redo changes.
Only one transaction can be active at a time. So to the best of my knowledge
there is no "transaction number" as there can be only 1. Now you may
On Tue, 13 May 2008, Darren Duncan wrote:
> Email lists have several important advantages over typical web boards, as I
> see it:
>
> 1. All the discussion details come to my email box that I regularly
> check, so I can be aware of and respond to things quickly if I choose. By
> contrast with a
What's the best way to group undo log entries by transaction? Is there
a function that returns the current transaction number? Or what's the
best way to set a global variable that is inserted into the undo log by
the trigger?
As background, the wiki has a great page on undo/redo:
htt
Jay A. Kreibich wrote:
> On Wed, May 07, 2008 at 10:25:49PM -0400, Andrew Cunningham scratched on the
> wall:
>
>
>> "I have doubts that you will be able to get SQLite to work on anything
>> less than a 32-bit processor.
>> D. Richard Hipp"
>>
>
>
>> I was under the impression as long a
[EMAIL PROTECTED] wrote:
> I apologize if this is off topic but wouldn't it be better to use some
> standard discussion board, like PHPBB instead of mailing list? It is pain to
> use mailing lists (you have couple of them for sqlite), ((un)registration,
> posting, receiving tons of e-mails, sea
We most certainly are using sqlite3_prepare_v2. This use case is a
bit more exotic.
We are currently working on an async database access API (discussion
thread [1]). The idea is to have a user prepare and bind parameters
on the calling thread, then clone that statement to send it to the
backgrou
On May 13, 2008, at 2:05 PM, Shawn Wilsher wrote:
> I was looking through the documentation and was wondering why
> sqlite3_transfer_bindings has been marked as obsolete. It's something
> that we use currently in our code, and I was looking to use it again
> for something new. Is there a new wa
I was looking through the documentation and was wondering why
sqlite3_transfer_bindings has been marked as obsolete. It's something
that we use currently in our code, and I was looking to use it again
for something new. Is there a new way to accomplish the same thing
that this function does? Wha
You shouldn't need to link. You could just compile it into your
application.
Derek Lee-Wo wrote:
>> If you do not use configure you have less control over compile options. You
>> need to think about whether yiou need to compile it thread safe or not.
>
> The app is single threaded so I don't n
> If you do not use configure you have less control over compile options. You
> need to think about whether yiou need to compile it thread safe or not.
The app is single threaded so I don't need a thread-safe version. I
think for my immediate needs, I should be OK just linking in the
sqlite3.c f
Does anyone run sqlite3 in an OnTime real time operating system?
Luiz Azevedo
Daiken Ltd
AVISO LEGAL
Esta mensagem é exclusivamente para a pessoa a quem se destina e pode conter
informações confidenciais ou legalmente protegidas. A transmissão incorreta da
mensa
If you do not use configure you have less control over compile options.
You need to think about whether yiou need to compile it thread safe or
not.
Derek Lee-Wo wrote:
> AIX 5.3 and I tried both xlC and gcc, but if I had a choice, I would
> prefer to use xlC.
>
> I decided to simply try lin
AIX 5.3 and I tried both xlC and gcc, but if I had a choice, I would
prefer to use xlC.
I decided to simply try linking in sqlite3.c (from the amalgamated
distribution) to my app and it "seems" to be working. I haven't done
much other than create a datafile and a table, but so far it's
worki
What verion of AIX are you using? What compiler? gcc or xlC?
JS
Derek Lee-Wo wrote:
> Is there a precompiled version of sqlite3 available for AIX? I did a
> Google search, but can't find anything.
>
> I would build it myself, but I'm having a really hard time as the
> configure script wouldn't
We implement a distributed synchronized Sqlite database by queueing
changes. In our case it is designed to permit internet operation to
continue during network failures or congestion.
Virgilio Alexandre Fornazin wrote:
> The best you can do actually with SQLite is a 'mirror-replicating' mode
>
On Tue, May 13, 2008 at 12:28 AM, Samuel Neff <[EMAIL PROTECTED]> wrote:
>
> One other issue we're having and are not sure about is we get a compiler
> error on sqlite3_profile and sqlite3_trace. We need to remove these two
> lines from the def file included with the sqlite source in order to g
Is there a precompiled version of sqlite3 available for AIX? I did a
Google search, but can't find anything.
I would build it myself, but I'm having a really hard time as the
configure script wouldn't run fully. First it complains about grep,
even when I installed the GNU grep, but I hacked conf
On Tue, May 13, 2008 at 3:13 PM, <[EMAIL PROTECTED]> wrote:
>
> I think mailing lists worked fine 20 years ago but does it have any
> advantage today ? :)
> Rado
>
>
That's just an opinion.. personally I prefer mailing lists because I can see
all seven lists I subscribe to in one place and check t
"Farzana" <[EMAIL PROTECTED]>
wrote in message news:[EMAIL PROTECTED]
> We are using SQLite and we have the table structure as CREATE TABLE
> Brand(PcNo numeric(4) Not Null,SubPcNo numeric(4) Not Null,BrandNo
> numeric(9) Not Null,BrandDescription nVARCHAR(254)Not Null,ST
> numeric(1),TS numeric(14
"Mahalakshmi.m"
<[EMAIL PROTECTED]> wrote
in message
news:[EMAIL PROTECTED]
> Igor Tandetnik wrote
>>> I can't reproduce this particular problem. Here's the test I wrote:
>>> Figure out what you are doing differently.
>
> I too did the same using both UTF8 anf UTF16 .Its coming right for
> UTF8 but
Hi,
Exercise in SQL for all
Is there a better way to phrase this INSERT trigger text:
UPDATE ITEM
SET
ITEM_SGT= ifnull(ITEM_SGT,(SELECT SGT FROM SETUP)) ,
ITEM_EGT = ifnull(ITEM_EGT,(SELECT EGT FROM SETUP)),
ITEM_SGT_MODE = ifnull(ITEM__AUTO_SGT_MODE,(SELE
<[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> I apologize if this is off topic but wouldn't it be better to use
> some standard discussion board, like PHPBB instead of mailing list?
Subscribe through GMane (http://gmane.org/) and use a NNTP client.
That's what I do.
Igor Tandetn
I apologize if this is off topic but wouldn't it be better to use some standard
discussion board, like PHPBB instead of mailing list? It is pain to use
mailing lists (you have couple of them for sqlite), ((un)registration, posting,
receiving tons of e-mails, searching, etc.).
Message from my o
Dear All,
We are using SQLite and we have the table structure as CREATE TABLE
Brand(PcNo numeric(4) Not Null,SubPcNo numeric(4) Not Null,BrandNo
numeric(9) Not Null,BrandDescription nVARCHAR(254)Not Null,ST numeric(1),TS
numeric(14)) where the index is CREATE UNIQUE index BrandKey1 on
Brand(PcNo,
On May 13, 2008, at 7:57 AM, [EMAIL PROTECTED] wrote:
>
> I‘m running ATTACH database on SQlite 3.5.8 on windows.
> I‘m opening one database
> file and attaching the second one.
> On my computer it works, but it fails at other computer. The
> database is opened in more
> than one thread (it i
I‘m running ATTACH database on SQlite 3.5.8 on windows. I‘m opening
one database
file and attaching the second one.
On my computer it works, but it fails at other computer. The database is opened
in more
than one thread (it is failing in worker thread).
sqlite3_step() returns SQLITE_MISUSE , but
39 matches
Mail list logo