Hello, I just did a quick check of SQLite version 3.24.0 with PVS-Studio
(https://www.viva64.com), a static code analyzer.
I have singled out a few strange code fragments that the analyzer warned
about that I think could be real bugs:
1. ext\misc\fileio.c:207 Last argument of memset() is
[mailto:sqlite-users-bounces at mailinglists.sqlite.org] On Behalf Of Simon
Slavin
Sent: Thursday, March 05, 2015 3:58 PM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] db File Remains Open After Connection is Closed
> On 5 Mar 2015, at 8:34pm, RNACS - Info wrote:
>
> The co
: Thursday, March 05, 2015 3:45 PM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] db File Remains Open After Connection is Closed
do you have any ... SqliteCommand's laying around that aren't finished?
On Thu, Mar 5, 2015 at 12:34 PM, RNACS - Info wrote:
> I have a program writ
I have a program written in Visual Basic .NET.
One of the functions of the program is to move all of the program's data,
including a SQLite database to a different folder.
The program is a 32-bit application using System.Data.SQLite.dll.
I am having a problem that after I copy the data to the
Hello,
I installed System.Data.SQLite (1.80) to my system.
The testprogram runs fine.
When putting the reference into VS Studio 2008 it takes an error: reference
can´t be found.
I copied the dll in several directories in my program without success.
I tried all the things I know but I can´t
Phil Hansen - Info wrote:
> Have just started using Sqlite and have got a simple database created
> and populated.
> Found that OO base can be used to access Sqlite.
> However the literature is a bit vague.
> I downloaded the .zip file which should be copied to
> openoffice1.1
Have just started using Sqlite and have got a simple database created
and populated.
Found that OO base can be used to access Sqlite.
However the literature is a bit vague.
I downloaded the .zip file which should be copied to
openoffice1.1/user/uno_packages.
No such folder. Did find
So, if I understand correctly, SQLite does not support these two operators
"out of the box".
Is there an easy way to get user-defined functions for regexp and match? Or
has no one developed those yet?
Regards,
Rick van der Lans
-Oorspronkelijk bericht-
Van: Kees Nuyt [mailto:[EMAIL
The manual mentions the support for the MATCH and the REGEXP operators. But
if I use it, it doesn't work. Do I have to do something special to install
those operators?
Regards,
Rick van der Lans
-
To unsubscribe, send
Thanks for your help, guys,
It now makes sense.
Rick van der Lans
-Oorspronkelijk bericht-
Van: Doug Currie [mailto:[EMAIL PROTECTED]
Verzonden: Wednesday, January 31, 2007 4:16 PM
Aan: sqlite-users@sqlite.org
Onderwerp: Re: [sqlite] Does julianday work according to the manual?
On
] [mailto:[EMAIL PROTECTED]
Verzonden: woensdag 31 januari 2007 17:04
Aan: sqlite-users@sqlite.org
Onderwerp: Re: [sqlite] adding years,months, days with decimals using
datetime function
"info" <[EMAIL PROTECTED]> wrote:
> Hi,
>
> If I use the expression datetime('2000-01-
Hi,
If I use the expression datetime('2000-01-01','1.5 months'), SQLite returns
2000-02-16 00:00:00. This means that it added one month plus half a month.
Makes sense.
If I use the expression datetime('2000-01-01','1.5 days'), I get 2000-01-02
12:00:00. Again this makes sense: 1.5 days is equal
Hi,
The manual states that the function julianday returns the number of days
since noon in Greenwich on November 24, 4714 B.C. That would imply that the
statement:
Select julianday('-4714-11-24 12:00:00');
Should return 0.0. But it doesn't, it returns -365.0
Does this mean, that the manual
Hi list,
sqlite version: 3.3.8
I have 2 tables:
---
CREATE TABLE kereset (realid INTEGER NOT NULL, id INTEGER NOT NULL, datum
DATETIME, jogcim CHAR(1) NOT NULL, brutto INT NOT NULL, ado INT NOT NULL,
adoalap INT NOT NULL);
CREATE TABLE szemely (id INTEGER NOT NULL, nev VARCHAR(128)
SKORPIO-INFO ha scritto:
Accidents!! I do not succeed re-install pysqlite!!! they give always
this error to me!!
You can help me?
p.s. with all the versions, also the previous ones!!
ok :)
I have resolved this problem:
SLOT_SEARCH = BSS.execute("SELECT * FROM slot WHERE
data_slot='01-04-2005' AND ((num_slot > "+str(contatore[1])+") AND
(num_slot < "+str(contatore[0])+"))")
Thanks
SKORPIO-INFO ha scritto:
Hi to all,
I have the necessity to
Hi to all,
I have the necessity to carry out a query that it must find an
occurrence to me in which the date is x and that a data field is
comprised between y and z
This is the example:
contatore = [20,33]
SLOT_SEARCH = BSS.execute("SELECT * FROM slot WHERE
data_slot='01-04-2005' AND
and some other systems.
So to do the 'commit', you have to first do 'begin'. Otherwise each
SQL command is in it's own little transaction, automatically committed.
Dan.
--- SKORPIO-INFO <[EMAIL PROTECTED]> wrote:
ah!! opsss . this is the query
# Esecuzione delle modifiche selezion
Well, actually that's exactly what I need - compression of large fields, not
the whole database.
Dennis
// MCP, MCSD
// ASP Developer Member
// Software for animal shelters!
// www.smartpethealth.com
// www.amazingfiles.com
- Original Message -
From: <[EMAIL PROTECTED]>
To:
Thank you Roger,
I'm not against paying (that's why I said "commercial").
Have you (or anyone) used SQLite++? What are your thoughts on it?
Thank you,
Dennis
// MCP, MCSD
// ASP Developer Member
// Software for animal shelters!
// www.smartpethealth.com
// www.amazingfiles.com
- Original
Hello all,
First of all, allow me to wish everyone a Happy New Year and I hope it'll be a
good one for all.
My question is (and I've raised this topic back in September, but didn't get
back to it since), does anyone have a free/commercial add-on for SQLite v3 to
perform on-the-fly
21 matches
Mail list logo