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
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
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
-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
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 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
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
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
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
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
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
[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,
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
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
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?
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
> 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
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
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
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
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
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
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
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
"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
"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
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 =
<[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
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
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
On May 13, 2008, at 7:57 AM, [EMAIL PROTECTED] wrote:
>
> Im running ATTACH database on SQlite 3.5.8 on windows.
> Im 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
34 matches
Mail list logo