Hi,
Yes, it's a solution but I want to test the two approachs (in VB and in
SQLite with an extension) to choice the faster. Before, I worked with VB6
and Access and the faster way is to use the calculation possibilities of
Access. I want just try it with VB .Net and SQLite. But I'm not able to
bui
Hello,
We released a Database Manager we developed for managing customer info and
purchases, creating invoices, searching and reporting.
It's all posted on: http://www.funduc.com/fsdbmgr.htm
Thank you SQLite community!
Mike Funduc
Funduc Software Inc.
supp...@funduc.com
http://www.funduc.com
On Thu, Apr 9, 2009 at 6:42 PM, Kelly Jones wrote:
> On 4/9/09, P Kishor wrote:
>> On Thu, Apr 9, 2009 at 6:23 PM, Kelly Jones
>> wrote:
>>> Given how cool SQLite is, has anyone created SQLite dbs of geonames,
>>> tycho2, or other large data sets that are available for download via
>>> FTP, HTTP
On 4/9/09, P Kishor wrote:
> On Thu, Apr 9, 2009 at 6:23 PM, Kelly Jones
> wrote:
>> Given how cool SQLite is, has anyone created SQLite dbs of geonames,
>> tycho2, or other large data sets that are available for download via
>> FTP, HTTP, Torrent or similar mechanism?
>>
>> I realize I could dl
On Thu, Apr 9, 2009 at 6:23 PM, Kelly Jones wrote:
> Given how cool SQLite is, has anyone created SQLite dbs of geonames,
> tycho2, or other large data sets that are available for download via
> FTP, HTTP, Torrent or similar mechanism?
>
> I realize I could dl the raw data, create tables, import t
Given how cool SQLite is, has anyone created SQLite dbs of geonames,
tycho2, or other large data sets that are available for download via
FTP, HTTP, Torrent or similar mechanism?
I realize I could dl the raw data, create tables, import the data,
create indexes, etc, but it's much faster just to do
>I realize your example may not reflect the specific needs of your
>application, ...
Yea, my actual application required a query too complex to be
put in an ordinary "where" clause. I think I've figured it
out - think of the "exists" clause as sort of an implied
join with the table to be parti
On Thu, 9 Apr 2009, Dave Dyer wrote:
> This little program deletes all rows. Is this a bug, or
> perhaps I misunderstand how delete with an exists clause
> is supposed to work.
>
> drop table if exists dummy;
> create table dummy ( var int);
> insert into dummy (var) values (1);
> insert into dum
You want:
delete from dummy where var=2;
In years of DB work, I've never used exists. If you're mentioning
this as a bug, I guess it could be: I'd have to lookup exists to see
exactly how it's supposed to work.
Jim
On 4/9/09, Dave Dyer wrote:
>
> This little program deletes all rows. Is
This little program deletes all rows. Is this a bug, or
perhaps I misunderstand how delete with an exists clause
is supposed to work.
drop table if exists dummy;
create table dummy
( var int
);
insert into dummy (var) values (1);
insert into dummy (var) values (2);
insert into dummy (var) valu
On Wed, 08 Apr 2009 23:17:02 +0200, Florian Nigsch
wrote:
>Hi all,
>
>I have been trying to implement a couple of things in SQLite because I
>only need it for myself (so no concurrency issues here).
>
>I am working on Arch Linux (uname: 2.6.28-ARCH #1 SMP PREEMPT Sun Mar
>8 10:18:28 UTC 2009
Dave,
Regarding: "I understand what a deadlock is, and I know it's not
technically a deadlock. This is why I stated the title as deadlock
behavior."
My apologies, Dave. I thought there might actually have been a
difference in definition that was adding to your problem. After your
reply, thou
Joanne Pham wrote:
> Hi All,
Hi Joanne Pham,
> I have seen the define for SQLITE_LOCKED as below
> #define SQLITE_LOCKED 6 /* A table in the database is locked */
> I thought the SQLITE is database locking so I was wondering when the table in
> the database is locked?
> Thanks,
you're
Joanne Pham wrote:
> I have seen the define for SQLITE_LOCKED as below
> #define SQLITE_LOCKED 6 /* A table in the database is locked */
> I thought the SQLITE is database locking so I was wondering when the
> table in the database is locked?
http://sqlite.org/sharedcache.html
Igor Tandetnik
Hi All,
I have seen the define for SQLITE_LOCKED as below
#define SQLITE_LOCKED 6 /* A table in the database is locked */
I thought the SQLITE is database locking so I was wondering when the table in
the database is locked?
Thanks,
JP
_
On 10/04/2009 12:34 AM, Thibaut Gheysen wrote:
> Hi,
>
> I develop a windows mobile application in VB .Net (compact framework 2.0)
> with SQLite and the ADO.net provider. In this application, I must calculate
> the distance between 2 points for all items of a table. For this I need
> "power" and "
Hi,
I develop a windows mobile application in VB .Net (compact framework 2.0)
with SQLite and the ADO.net provider. In this application, I must calculate
the distance between 2 points for all items of a table. For this I need
"power" and "sqrt" function but these functions doesn't seem to be inclu
On 9/04/2009 8:40 PM, Florian v. Savigny wrote:
>
> The question was serious, sincere, and earnest!
>
> > [It] seems [...] that the typeof() column adds no information that
> > the quoted value itself does not provide.
>
> > So, can I simply use quote() [...] to determine the storage
> >
Hello Brian,
you do not need a VALUE keyword in this case.
INSERT INTO "subscribers_new"
--VALUES <- remove this
SELECT id, ip_address, added, 'aa:bb:cc:etc' from subscribers;
See the syntax diagram for the insert command:
http://www.sqlite.org/lang_insert.html
Martin
Brian Zambrano
Can anyone explain to me why an insert with select statement isn't working?
I know in my my example below I just have an extra column which I could have
added, but my actual tables are a bit more complex and this below is just to
demonstrate the problem.
-- Original table
CREATE TABLE "subscribers
"Simon Chen"
wrote in message news:22964648.p...@talk.nabble.com
> Another related question, during rollback, would triggers be called?
No. Rollback works at the low level, by restoring whole pages in the
database file. It doesn't work with individual records.
Igor Tandetnik
___
The question was serious, sincere, and earnest!
> [It] seems [...] that the typeof() column adds no information that
> the quoted value itself does not provide.
> So, can I simply use quote() [...] to determine the storage
> class SQLite uses?
It would really be of great help to know t
How can I convert it into a string through ODBC? Here is some of my data.
Date_Stamp
2009/03/16 10:52
2009/03/16 14:18
2009/03/16 14:20
2009/03/16 14:43
2009/03/16 15:10
2009/03/16 15:17
2009/03/16 15:23
2009/03/16 15:30
2009/03/16 15:32
2009/03/16 15:47
Rene
> -- Forwarded message
On Apr 9, 2009, at 3:18 PM, Arthur Skowronek wrote:
> Griggs, Donald wrote:
>> This mailing list, like many, will automatically strip attachments.
>> Posting onto your own webspace is a great way, as you have
>> discovered,
> to reference files.
> Thank you for your advice :).
>
>>
>> I'm wri
Griggs, Donald wrote:
> This mailing list, like many, will automatically strip attachments. Posting
> onto your own webspace is a great way, as you have discovered,
to reference files.
Thank you for your advice :).
>
> I'm writing just to say that I *did* reproduce a problem.
>
> I'm using Windo
Thank a lot Jay
From: Jay A. Kreibich
To: General Discussion of SQLite Database
Sent: Wednesday, April 8, 2009 1:22:57 PM
Subject: Re: [sqlite] what is the default for the commit when the connection is
opened.
On Wed, Apr 08, 2009 at 10:12:15PM +0200, Martin
26 matches
Mail list logo