> For which OS platform is the generated binary?
> for 32bits win OS or 64bits win OS?
32 bits.
Charles
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
0)
To: General Discussion of SQLite Database
Subject: Re: [sqlite] Segfault during FTS index creation from huge data
No, I'm sure that is not a problem in my software, it exactly
error of the SQLite library. My software is very simple - it creates
simple connection to the database with connection s
(GMT+00:00)
To: General Discussion of SQLite Database
Subject: Re: [sqlite] Segfault during FTS index creation from huge data
No, I'm sure that is not a problem in my software, it exactly
error of the SQLite library. My software is very simple - it creates
simple connection to the database with co
duction, because if the quality of
sqlite3 is indication, I'm going to really enjoy using it!
Charles
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
.cpp:41 (gdb) print pNext
> $1 = (ShmChunk *) 0x
>
>
>
> It's a pity that LSM isn't ready for production, because if the quality of
> sqlite3 is indication, I'm going to really enjoy using it!
>
> Charles
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
atabase file mid-transaction.
I'm also seeing a similar problem in which it silently discards entries, but I
haven't been able to narrow down an example for you. Let me know if that would
be helpful and I'll try harder.
What could I do to improve LSM?
Charles
______
.c:472)
==1741==by 0x4046C5: lsmMallocZero (lsm_mem.c:50)
==1741==by 0x404730: lsmMallocZeroRc (lsm_mem.c:69)
In a more complex program, lsm seems to leak memory to no bounds, causing my
application.
Are bug reports against LSM even helpful?
Charles
______
Test.
--
Joe Mistachkin
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
On Wed, Oct 28, 2015 at 11:22 AM, General Discussion of SQLite Database <
sqlite-users at mailinglists.sqlite.org> wrote:
> On 28.10.2015 18:52, General Discussion of SQLite Database wrote:
>
>> Hence, we have token the radical approach of denying the sender email
>
On Wed, Oct 28, 2015 at 1:32 PM, General Discussion of SQLite Database <
sqlite-users at mailinglists.sqlite.org> wrote:
> On 2015-10-28 10:52 AM, General Discussion of SQLite Database wrote:
>
>> The reason for this change is to combat the "Alexa" spam. For the
: @sandersonforens
Tel +44 (0)1326 572786
http://sandersonforensics.com/forum/content.php?195-SQLite-Forensic-Toolkit
-Forensic Toolkit for SQLite
email from a work address for a fully functional demo licence
On 28 October 2015 at 19:42, SQLite
wrote:
> On Wed, Oct 28, 2015 at 11:22 AM, General Discuss
On Wed, Oct 28, 2015 at 1:46 PM, SQLite <
sqlite-users at mailinglists.sqlite.org> wrote:
> Is this over-reacting a bit. I have had one email from alexa (about
> 3/4 weeks ago). If it starts to become a real problem then do
> something about it - until then I would think w
Actually looking at this thread (in gmail) since the policy change is
a very retrograde step - all messages are displayed as from SQLite.
There are numerous scenarios where I want to see the name of the
sender (not necessarily the email address) so that I can pick and
choose which messages I
On 28 Oct 2015, at 7:36pm, General Discussion of SQLite Database wrote:
> Has anybody received email from Alexa since the policy change? I have not
Nor me. I reliably got one for every post I made for about a week before the
change.
Simon.
Hello.
I am a newbie both to sqlite and tcl. I would like to learn how to run the
test suite, so that later, when I start modifying the source code (e.g. to
make a customized subset), I can verify that I have not broken anything.
Is there a document somewhere that describes how to run
writes:
Howdy all!
I am just writing tonight to let you know that a project of mine has
opened up to being open source -- ManagedSQLite. It is a light wrapper
around SQLite 3.4.0 that was originally written by Rob Groves. I have
added support for Unicode to his wrapper, then added my Managed
Dear All,
I have just started using the SQLite Db in my applications. My application
runs under MIPS processor. I have generated the Sqlite3.dll and Sqlite3.lib
file for the MIPS processor and it is geting compiled. When i use
Sqlit3_Open function to open a DB, it fails with the error message
Dear All,
i have developed an application using SQLite which runs in the pocket pc
device. My application has to show some messages in a list box (custom
build) while moving forward im able to move the records one by one in the
recordset. But when i move upwards im not able to move
the query does
it mean the execution time for our query is 40 secs because we are
retrieving the records soon once gets executed.
Regards
Kartthi
Stephen Oberholtzer wrote:
>
> On Tue, May 27, 2008 at 9:06 AM, sqlite <[EMAIL PROTECTED]>
> wrote:
>
>>
>> Dear All,
>
Dear All,
We are using SQLite for our application development which would be deployed
in a pocket pc.Here we are using a query which has three Inner joins and
using sqlite3_prepare and sqilte3_step function to prepare the records and
to fetch the records.By executeing the Query and we moves
Igor Tandetnik wrote:
>
> "sqlite" <[EMAIL PROTECTED]> wrote
> in message news:[EMAIL PROTECTED]
>> We are using SQLite for our application development which would be
>> deployed in a pocket pc.Here we are using a query which has three
>> Inner joins
Dear All,
We are using SQLite for our application development which would be
deployed in a pocket pc.Here we are using a inner join query which takes
different time during different executions, the query which we using in our
application is
"SELECT DISTINCT MT.PcNo, MT.SubPcNo, MT.Br
Igor Tandetnik wrote:
>
> "sqlite" <[EMAIL PROTECTED]> wrote
> in message news:[EMAIL PROTECTED]
>> We are using SQLite for our application development which would be
>> deployed in a pocket pc.Here we are using a inner join query which
>> takes
Dear All,
We are using SQLite for our application development which would be
deployed in a pocket pc of type DTX 10 processor ARMV4T.Also we have
generated the lib file specific for ARM processor using the LIB.exe with the
parameters DEF:sqlite3.def MACHINE:ARM and the sqlite3.lib and sqlite3
Dear Virgilio,
Thanks for your Quick reply, we dont know how to enable the funtional level
linking using SQLite with eVC, so kindly tell us how to enable the same.
Thanks & Regards,
kartthikeyan
Virgilio Alexandre Fornazin-2 wrote:
>
> IF you are using SQLite with eVC, you mu
Dear Virgilio,
We enabled the functional level linking using SQLIte, but we are getting
the "unresolved exteral symbol sqlite3_open referenced in function" error
which means the sqlite3.lib file we have generated is not valid? if so
kindly help us to generate the lib file for ARMV4T
Dear Virgilio,
We enabled the functional level linking using SQLIte, but we are getting
the "unresolved exteral symbol sqlite3_open referenced in function" error
which means the sqlite3.lib file we have generated is not valid? if so
kindly help us to generate the lib file for ARMV4T
:
>
> IF you are using SQLite with eVC, you must enabled function level linking,
> because
> ARM linkers had a bug before eVC SP4 that generated corrupt image files.
>
> On Thu, Jun 12, 2008 at 9:39 AM, sqlite <[EMAIL PROTECTED]>
> wrote:
>
>>
>> De
n one
name...
What is the recommended way to do this with SQLite?
PS: I'm not wrong in thinking that IF EXISTS (...) THEN ...
isn't implemented, am I? I couldn't get the sqlite3 interpreter
to accept any statements of that form ("syntax error near IF").
__
r you can specify that the name/id pair is unique ...
> PRIMARY KEY (name, id)
>
> Regards,
> MikeW
Excellent!
Thanks, I didn't know that...
_______
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
All:
For comparison I tried several combinations of query orders and indices.
I found both indices and the join clause sequence make significant
differences in execution time. Using SQLiteSpy with SQLite v3.6.1 on
Windows XP.
I have two tables:
GPFB with 34830 rows, 10 columns with a 4-column
Hello all,
I'm compiling sqlite 3.6.13 with Visual 2003, and RunTime Check
activated, and it gives this error :
Run-Time Check Failure #1 -
A cast to a smaller data type has caused a loss of data. If this was
intentional, you should mask the source of the cast with the appropriate
bitmask
> This is probably not a bug. There are places in the SQLite code where
> we deliberately discard all but the lower 8 bits of an integer. But,
> if you like to tell us *where* in the code this occurs, I'll be happy
> to verify it for you.
In sqlite3.c big file, it's
D. Richard Hipp a écrit :
> This is not error in the SQLite code. The code here is correct. The
> bug is in your compiler.
Sorry but I don't agree at all.
> Adding a work-around so that this will work in your compiler makes the
> code rather more complicated:
>
&
Hello,
When using sqlite-3.3.4 with windows I get the following strange behaviour.
create table Muppet (Kermit float);
insert into Muppet values (100);
select * from Muppet;
100.0
As you see it returns 100.0 instead of only 100. This happens in windows
xp but not in win ce.
Anyone know how
I want to know the type of a column, ie.:
INTEGER, TEXT, REAL or BLOB
There seems to be no function to do this.
I can get the "declared type" of a column but
that's not easy to decipher as SQL has a zillion
data types.
I tried "sqlite3_column_type()" but that function
only works when there's
Eric Scouten wrote:
No such thing, really. In SQLite the data types are associated with the
cell, not the column.
Yes, I saw that. I'm not sure it's a good "feature".
The "declared type" of a column that you've found is used to establish
preferences for
Eric Scouten wrote:
SQLite derives that by parsing the string that you've already found.
I found the method in section 2.1 of this page:
http://www.sqlite.org/datatype3.html
> I think it does store that in some internal fashion, so
> it's not *re-parsing* it cons
[EMAIL PROTECTED] wrote:
sqlite <[EMAIL PROTECTED]> wrote:
Eric Scouten wrote:
SQLite derives that by parsing the string that you've already found.
I found the method in section 2.1 of this page:
http://www.sqlite.org/datatype3.html
> I think it does store that in some internal fa
Eric Scouten wrote:
On 10 May 2006, at 16:31, sqlite wrote:
Eric Scouten wrote:
No such thing, really. In SQLite the data types are associated with
the cell, not the column.
Yes, I saw that. I'm not sure it's a good "feature".
Depends on your application. For us, it's been a ve
in 'SQLite in 5 Minutes Or Less'.
I think real problem is that you have a function
called "column_type" which doesn't actually return
the type of a column. This is counter-intutive.
If you could make it return the column "affinity"
between the call to prepare() and th
Roger Binns wrote:
The types point still baffles me. If your code already
knows which column it is dealing with then surely the
code should know what type to expect. (Eg if you are
dealing with a column named 'title' then you would
expect a string)
Let me explain what I was doing...
I was
John Stanton wrote:
As you postulated, Sqlite's approach is indeed more rational.
Most SQL implementations use fixed-size records
so it makes more sense for them to enforce each
column's data type exactly - inserting a string
into a column which can only hold a single char
isn't very useful.
Joe Wilson wrote:
I also agree with Ralf's proposal for sqlite3_column_affinity().
(Not that a vote on this topic will likely make a difference. ;-)
I don't think you need a new function, just make
the existing one do the obvious thing right after
you call "prepare".
--- Ralf Junker
.
PS C:\rev\src\sqlite3\src> fossil info
project-name: SQLite
repository: c:\rev\fossil\sqlite3.f
local-root: C:/rev/src/sqlite3/
user-home: : C:/Users/rev/AppData/Local
project-code: 2ab58778c2967968b94284e989e43dc11791f548
server-code: 2fa7c8b2762294d28396292f74c7b94c9c50af75
check
el,1,"test",4,NULL);
if(SQLITE_ROW != sqlite3_step(sel)) {
printf("no results? %s\n",sqlite3_errmsg(db));
} else {
printf("Got ID %d\n",sqlite3_column_int(sel,0));
}
return 0;
}
t",4,NULL);
if(SQLITE_ROW != sqlite3_step(sel)) {
printf("no results? %s\n",sqlite3_errmsg(db));
} else {
printf("Got ID %d\n",sqlite3_column_int(sel,0));
}
sqlite3_reset(sel);
return 0;
}
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
s all fine, until it makes a call to SQLite.
Not sure this dump of WerFault.exe helps me much as all I got is Stopped
working and APPCRASH.
At least it shows all the dependencies that are involved.
MSVCR120.dll is present and version is 12.0.40660.0.
RBS
On Thu, Sep 7, 2017 at 9:58 AM, Chris Locke
I have some proposals for feature requests for virtual table mechanism of
SQLite. Some of this can be useful when accessing remote data over the
internet or whatever. Here is the list:
* A new method "xInterrupt", called when sqlite3_interrupt() is called.
This can be used to cancel
The documentation for the xCreate and xConnect methods for virtual tables give
the incorrect type.
It says "char**argv" but the actual type should be "const char*const*argv".
___
sqlite-users mailing list
sqlite-users@mailingl
a table name within the select_stmt. Both of these
are separate from table-valued functions (parameterized views) though.
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
it if it doesn't already.
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
argv) {
if(argc!=3) return 1;
if(sqlite3_open(":memory:",)) return 1;
count=strtol(argv[1],0,0);
sqlite3_set_authorizer(db,xAuth,0);
printf("%d\n",sqlite3_exec(db,argv[2],0,0,0));
return 0;
}
_______
sqlite-users mailing list
s
ing the sqlite3_interrupted() function (or whatever you want to call
it) should be very easy to implement. However, it must be added into the
extension loading mechanism, so if I do it by myself then it will be
incompatible.
___
sqlite-users mailing list
sqlite-us
particular
database.
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
_expr.html, and lang_select.html mention window functions at all
except as part of the syntax diagram in lang_expr.html (although window
definitions are also mentioned in lang_select.html, not window functions)
_______
sqlite-users mailing list
sq
sqlite-users@mailinglists.sqlite.org wrote:
> It's quite often (for me, at least) the case I need to do something like this
> from the command line:
>
> >sqlite3.exe my.db "insert into t values(`simple field','multi-line text
> >copied
> >from some other app')
&
sqlite-users@mailinglists.sqlite.org wrote:
> Your schema implies that there can be more than one TIME for any GNAME and AN
> combination (otherwise the primary key would not need to include alle three
> fields). This contradicts your statement that AN and TIME are "the
uot; will be the same order.
(I also have a table "ART" where "AN" is the rowid, and again the order by
"TIME" will be the same order.)
How can you make SQLite to make that assumption in order to optimize the query?
(It should be done presumably without adding another
Hello,
I have two sqlite databases. (db1, db2)
I try to write a trigger in db1 which inserts data to a table in db2.
In the sqlite docu there is a section about "Temp Triggers".
"...Except, it is possible to create a TEMP TRIGGER on a table in another
database."
CREATE TE
CREATE TABLE ad(id INTEGER PRIMARY KEY, name TEXT);
>
> CREATE TABLE aconstrained(
> id INTEGER PRIMARY KEY,
> a_id INTEGER NOT NULL,
> b_id INTEGER NOT NULL,
> c_id INTEGER NOT NULL,
> d_id INTEGER NOT NULL,
> CONSTRAINT constrained_fkey_aa_id FOREIGN KEY(
Hello again !
I forgot also to mention that sqlite do not check for duplicates table
constraint declarations see the extended example bellow:
-
PRAGMA foreign_keys=OFF;
BEGIN TRANSACTION;
CREATE TABLE aa(id INTEGER PRIMARY KEY, name TEXT);
CREATE TABLE ab(id INTEGER PRIMARY KEY
trace_explain_query" that
would also show at high level the internal sqlite3 operations a kind of mix
of sqlite3_trace + "explain" that would give for this database example an
output like this:
---
/test-sqlite-bug
SQL: INSERT INTO "aa"("id","name&quo
ield (most of then without an
index) deleting anything on res_users become a very costly operation.
It also shows that sqlite is not capable to merge table scans for the same
value on more than one column and execute several table scans (optimization
opportunity), but I'm still not sure why it
Hello !
Here is a small patch that adds ".dumpdata" for "shell.c" in sqlite3.
This command should behave exactly like ".dump" but without the database
schema.
I 'm giving it with the same license as sqlite.
Cheers !
uot;.fullschema" with a transaction with this extended patch.
Again the same license of sqlite apply to this patch.
=patch to shell.c
--- shell.c
+++ shell.c
@@ -550,10 +550,12 @@
?? sqlite3_stmt *pStmt;?? /* Current statement if any */
?? FILE *pLog;??? /* Write log output he
Hello !
Working with sqlite3 I noticed that sqlite3 ".dump", ".schema" and
".fullschema" outputs the contents of the field "sql" stored in
"sqlite_master" and if the sql statement ends with a comment the resulted
dump will be invalid see example:
=== valid sql statement stored on
Hello !
?
This request is a common requirement and in my opinion would be better solved
by an extension to the actual sqlite3 api functions.
?
Actually there is sqlite3_trace that can be used to watch all sql statements
executed on a given session.
?
One possible way would be to
d.
This is a link to a gist on github
https://gist.github.com/mingodad/f32b680c901e360803bb
The license for this contribution is the same of sqlite.
Cheers !
====
diff -urB sqlite-src-3081101/src/loadext.c sqlite-src-3081101-2/src/loadext.c
--- sqlite-src-3081101/src
Hello !
The query you mention is not the same as:
INSERT INTO table_of_intergers SELECT seqno FROM generate ORDER BY seqno;
Cheers !
> Mon Aug 17 2015 17:44:58 CEST from "John McKown"
> Subject: [sqlite] Enhance the SELECT
>statement?
>
> I use both SQLite3
Hello !
Do you have foreign keys on your tables ? And if so do you have indexes on
then ?
A database with foreign keys and no indexes can run very slow for mas
insert/update/delete ?
Cheers !
?
> Tue Aug 18 2015 12:38:51 CEST from "Paolo Bolzoni"
> Subject: Re:
is performed on
all dependent tables and that can be a lot time consuming depending on the
number of records on then.
? I've got this problem on a heavily foreign key constrained database and it
took me a bit to realize that !
Cheers !
> @nameless person known as sqlite-mail,
> Yes, I d
(id integer primary key, a_id integer references a(id), name
text);
CREATE VIEW aview AS select * from a;
CREATE VIEW bview AS select b.*, a.name from b left join a on b.a_id =aid;
===
?
Now if we do "alter table a rename to a2;" actually sqlite only rename the
"a&q
Hello !
Here I'm fixing some typos and I also tested on postgresql and there all
views are updated properly then I'll say is a bug in sqlite.
Does anybody knows how to rename a table and all it's dependencies in one go
?
?
The problem: a database has several tables and views
Hello !
Today I'm working with sqlite3 with attached databases and when I tried to
get info about a tbale using "PRAGMA TABLE_INFO" I discovered that pragmas do
not work with qualified/prefixed names like:
PRAGMA table_info(attached_db.one_table)
?
Is this a bug ?
Cheers !
Thank you !
That's what I want and looking back in the sqlite documentation I can see now
that I was misinterpreting it, in reality I was applying the same principle
used on other places to qualify/prefix tables/views/... objects but with your
help I could realize that pragmas are an exception
Then do you think this is a bug ?
> Fri Aug 21 2015 18:57:33 CEST from "Simon Slavin"
>Subject: Re: [sqlite] Is this a bug ? How to rename a table and all
>dependencies ?
>
> On 21 Aug 2015, at 12:20pm, sqlite-mail wrote:
>
>
>>Does anybody kno
Thanks for your attention!
Only to remark on this I tested on postgresql and somehow it knows how deal
with it ! "so few (none?)"
Cheers !
?
> Fri Aug 21 2015 19:08:58 CEST from "J Decker" Subject:
>Re: [sqlite] Is this a bug ? How to rename a table and all
Thank you for your attention !
I'm pointing this here because postgresql do manage this case properly !
And I'm creating a tool to prototype database applications and I'm using
sqlite as the primary database, when we are prototyping things can change
drastically at any point and if we
That's why I think that expose a basic SQL ANSI catalog would make this kind
of work and others a lot easier.
?
> Fri Aug 21 2015 22:13:00 CEST from "Simon Slavin"
>Subject: Re: [sqlite] Is this a bug ? How to rename a table and all
>dependencies ?
>
> On 21 A
Hello !
I'm testing the new json functions and when I tried this:
select json_array(*) as json from one_table;
I've got :
[]
[]
..
Then I tried with some custom functions accepting variable number of
parameters and realize that "*" is not expanded for function calls.
There
eric user
defined functions.
Anyone have any idea about this ?
?
Cheers !
?
> Sat Aug 22 2015 13:01:32 CEST from "Richard Hipp"
>Subject: Re: [sqlite] There is any reason to sqlite not expand "*" in
>function calls ?
>
> On 8/22/15, sqlite-m
Hello !
When querying views sqlite shows qualified column names if they are specified
individually.
Is this the expected result or a bug ?
This behavior breaks some of my code that uses column names for other
purposes.
Cheers !
output of "test-view-alias"
SQL: SELEC
e Aug 25 2015 19:45:27 CEST from "Simon Slavin"
>Subject: Re: [sqlite] Why sqlite show qualified column names when selecting
>from views ?
>
> On 25 Aug 2015, at 6:13pm, sqlite-mail wrote:
>
>
>>When querying views sqlite shows qualified column names if they
Hello? !
?
I'm using sqlite for a project and with this specific database
https://dev.dadbiz.es/tmp/odoo.db.zip (12MB compressed / 38MB uncompressed)
this is happening:
?
-1 Registering an sqlite3_trace function when trying to delete a record just
inserted on the table "res_users" the
Hi,
we are happy to announce a final release of SqliteDog: a modern SQLite
database manager.
http://sqlitedog.com
--
Regards,
SqliteDog support team
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman
mmar errors in the website text. I
> suggest you may want to have a native English speaker proof it.
>
>
> On Wed, Oct 23, 2013 at 12:21 PM, Sqlite Dog <sqlite...@gmail.com> wrote:
>
> > Hi,
> >
> > we are happy to announce a final release of SqliteD
Hi,
perhaps, this can help:
1) download zip with latest SQLite DLL from http://sqlite.org/download.html;
2) unzip it to c:\temp;
3) copy c:\temp\sqlite3.dll to Windows\System32 folder;
4) if there is already sqlite3.dll in Windows\System32 and it's locked,
overwrite it with InUse.exe (http
- Original Message
> MemPage bitfield patch below.
>
> sizeof(MemPage) on Linux:
>
> original: 84
> patched: 76
> ...
> Break-even for memory is 904/8 = 113 MemPage structs allocated.
I didn't look at the code, so mind me :)
If the MemPage are malloced individually (instead of
- Original Message
> From: Dennis Cote <[EMAIL PROTECTED]>
> To: sqlite-users@sqlite.org
> Sent: Wednesday, May 30, 2007 12:09:25 PM
> Subject: Re: [sqlite] sqlite internal structs don't make use of C bitfields?
> You may want to look at how the isInited field is
Hi all
I am trying to put in place a simple replication process to copy a database
from one machine to an other.
The table I have is something like
CREATE TABLE sn2uid(sn VARCHAR(100) NOT NULL, uid INTEGER NOT NULL, PRIMARY KEY
(sn));
CREATE INDEX uidindex on sn2uid ( uid )
Where the (sn,uid)
> - Original Message
> From: Joe Wilson <[EMAIL PROTECTED]>
> To: sqlite-users@sqlite.org
> Sent: Monday, June 11, 2007 8:36:32 PM
> Subject: Re: [sqlite] Database replication question
>
>
> Large bulk inserts with more than one index (implicit or expli
- Original Message
From: Martin Jenkins <[EMAIL PROTECTED]>
To: sqlite-users@sqlite.org
Sent: Friday, June 22, 2007 2:00:45 PM
Subject: Re: [sqlite] Capturing output from SQLlite with variables in a BASH
script
litenoob wrote:
> Hi, I'm wondering how to write a BA
Hello, everybody
I have the following problem: I have the following tables:
Months
--
CREATE TABLE 'Months'
(
IDMonth INTEGER PRIMARY KEY NOT NULL,
MonthRef INTEGER
);
(where MonthRef is the date of the first day of the month - created in the code)
>
> - Original Message
> From: Zbigniew Baniewski <[EMAIL PROTECTED]>
> To: sqlite-users@sqlite.org
> Sent: Thursday, July 26, 2007 4:12:00 PM
> Subject: Re: [sqlite] Problem with SQLite FastCGI module "malformed database
> schema"
>
>
>
- Original Message
> From: "[EMAIL PROTECTED]" <[EMAIL PROTECTED]>
> To: sqlite-users@sqlite.org
> Sent: Tuesday, September 4, 2007 3:32:38 PM
> Subject: Re: [sqlite] 3.5.0 alpha TryEnterCriticalSection linker error
>
>
> =?ISO-8859-1?Q?Daniel_
- Original Message
> From: John Stanton <[EMAIL PROTECTED]>
> To: sqlite-users@sqlite.org
> Sent: Wednesday, November 14, 2007 11:43:48 AM
> Subject: Re: [sqlite] Re: Threads
>
> If you machine has a single disk it fundamentally does not have parallel
>
수신자가 sqlite-users@sqlite.org 로부터 오는 메일의 수신을 거부하였습니다.
_
--- Begin Message ---
Hi there,
Im trying to run a Python based program which uses MySQL with python-sqlite
and Im recieving this error,
'Connection' object has no attribute 'autocommit
Hi there,
Im trying to run a Python based program which uses MySQL with python-sqlite
and Im recieving this error,
'Connection' object has no attribute 'autocommit'
I´ve had a google for this and its seems like it may be a bug python-sqlite or
sqlite bug , but also I tried searching
Hi all,
Hopefully you can help, while running sqlite version 3.5.5
Two seperate threads each attempt to run a vacuum command against the same db.
Each thread has an independent connnection to the db.
One thread succeeds and the other gets a return code of 1 (SQLITE_ERROR) from
1 - 100 of 235 matches
Mail list logo
