Dear all:
1. Will SQLite run sqlite3_open_v2 if I call sqlite3_open with 4
arguments ? I mean, Did SQLite pick up the interface depends on number of
parameter ?
2. How to assign flag parameter in sqlite3_open_v2() with combination of
黃楨民 huangchen...@gmail.com wrote:
1. Will SQLite run sqlite3_open_v2 if I call sqlite3_open with 4
arguments ? I mean, Did SQLite pick up the interface depends on number of
parameter ?
Your compiler won't let you pass four arguments to a function delcared with
two, whether this function
AFAIK, before deleting journal file SQLite writes some zeroed header
into it. This kind of header means that transaction is finished. And
even if after power shutdown SQLite finds this journal persisting on
disk it will see the header and will understand that this journal just
needs to be deleted.
Hi,
I accidently stumbled on a repeatable crash in sqlite3.exe, here is what I do
to reproduce it:
$ sqlite3 temp.db
SQLite version 3.7.10 2012-01-16 13:28:40
Enter .help for instructions
Enter SQL statements terminated with a ;
sqlite select 1 from (select *);
CRASH
It this known or
On Feb 23, 2012, at 6:21 PM, Levi Haskell wrote:
sqlite select 1 from (select *);
Wow, wicked :)
Confirmed on sqlite3 -version
3.7.10 2012-01-16 13:28:40 ebd01a8deffb5024a5d7494eef800d2366d97204
___
sqlite-users mailing list
On Thu, Feb 23, 2012 at 12:29 PM, Petite Abeille
petite.abei...@gmail.comwrote:
On Feb 23, 2012, at 6:21 PM, Levi Haskell wrote:
sqlite select 1 from (select *);
Wow, wicked :)
Confirmed on sqlite3 -version
3.7.10 2012-01-16 13:28:40 ebd01a8deffb5024a5d7494eef800d2366d97204
Fixed
The header is overwritten with some zeros only if I change the
journal_mode to PERSIST :
http://www.sqlite.org/pragma.html#pragma_journal_mode
By default, the journal_mode is set to DELETE so the journal file is
valid if the file is present after an unlink + power shutdown.
(I have checked with
Yes. It's running on 64bit but I compiled it for 32 bit. I've tried using
the 64bit version however, when I reference the 64bit dll's the compiler
generates warnings about the image even when I set it to debug 64bit, and
when I try to run the 64bit version it crashes so I've opted to compile it
On 02/23/2012 06:02 PM, Florent Bayendrian wrote:
Hi,
I have a synchronization issue on an embedded device running Linux : if a
power shutdown is done just after a commit, sqlite will restore the
database to the previous state using the journal file. At the end of a
transaction the unlink of
On Thu, Feb 23, 2012 at 6:50 PM, Simon Slavin slav...@bigfraud.org wrote:
On 23 Feb 2012, at 1:16pm, Abhinav Upadhyay er.abhinav.upadh...@gmail.com
wrote:
I do not remember the
exact error message but it close to this. As per the documentation on
the compound select statements
Hi, would it be possible to reference a column in a table using other than
its name? For example, if I have : create table X ( a TEXT NOT NULL); would
it be possible to access x.a with something similar as x.field[0]? Thank's.
___
sqlite-users mailing
On 24 Feb 2012, at 1:45am, Rick Guizawa guizaw...@gmail.com wrote:
Hi, would it be possible to reference a column in a table using other than
its name? For example, if I have : create table X ( a TEXT NOT NULL); would
it be possible to access x.a with something similar as x.field[0]?
Hello
Is it possible to find out in xFilter or xBestIndex which columns were
selected? That is, if I do SELECT a, b, c FROM t where t is a
virtual table, I would like to know in xFilter or xBestIndex that the
result will only consist of the rows a, b and c.
I know that xColumn will only get
On Wed, Feb 22, 2012 at 11:14 PM, Petite Abeille
petite.abei...@gmail.comwrote:
http://www.sqlite.org/lang_keywords.html
@sqlite3 committers: there's a minor error on that page: is says There are
three ways of quoting... and then goes on to show four ways.
--
- stephan beal
I'm trying to add ICU to my Sqlite static library, compilation is ok, and I
have file of library, but when I try to use it I've got some errors,
anybody can help me what I do wrong ?
..\..\Library\SQLCIPHER\libSQLCIPHER.a(SqlCipher.o):SqlCipher.c|| undefined
reference to `ucol_strcoll_3_8'|
*Hi,
*
I want to store some access policy inside kernel. Is it possible to use
sqlite inside kernel code?
Thanks
Jinesh
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Hi,
I have a synchronization issue on an embedded device running Linux : if a
power shutdown is done just after a commit, sqlite will restore the
database to the previous state using the journal file. At the end of a
transaction the unlink of the journal file is not enough, the journal could
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Wed, 22 Feb 2012 17:10:39 -0800
Roger Binns rogerb-jfdgoz7s+bwwqnjq7v0...@public.gmane.org wrote:
Just start using SQLite and see what happens.
Good one. We'll try to (artificially) populate our sqlite database and
then play with it.
You
On Wed, 22 Feb 2012 23:04:55 +0100
Petite Abeille petite.abei...@gmail.com
wrote:
Are you actually trying to solve a concrete problem?
Yes.
Or creating one out of thin air instead?
No.
http://blogs.tedneward.com/2006/06/26/The+Vietnam+Of+Computer+Science.aspx
Thank you. It seems
On Wed, 22 Feb 2012 20:52:54 -0500
Richard Hipp d...@sqlite.org wrote:
Here http://www.sqlite.org/cvstrac/wiki?p=UndoRedo is a write-up
from 2005 in which I describe a technique I used to implement
unlimited-depth undo/redo in a application that used SQLite as its
file format. There was no
I have a database with a table name containing a quote and a space.
Let's say it's called “Ben's table”
I have created it with:
CREATE TABLE Ben's table ([column_spec]);
I tried the following in the SQLite shell:
.import 'file_name.txt' Ben's table
But that does not work. So I had to
Hi,
I have a single column table, in which I wish to store around several
thousands of rows. I was wondering if I could insert them using a
single INSERT query and came across this Stackoverflow answer:
http://stackoverflow.com/a/1734067/348637 . According to that answer
it is possible to insert
On 23 Feb 2012, at 1:16pm, Abhinav Upadhyay er.abhinav.upadh...@gmail.com
wrote:
I do not remember the
exact error message but it close to this. As per the documentation on
the compound select statements
(http://www.sqlite.org/lang_select.html) on Sqlite website, there is
no mention of an
On Feb 23, 2012, at 2:16 PM, Abhinav Upadhyay wrote:
I would like to know the exact limit
on this, so that I could my code to work within this limit :)
See Maximum Number Of Terms In A Compound SELECT Statement:
http://www.sqlite.org/limits.html
On Feb 23, 2012, at 2:16 PM, Abhinav Upadhyay wrote:
. I was wondering if I could insert them using a
single INSERT query
Ah, also, there is not much benefit in using a compound insert.
You could as well simply insert all your values in one transaction and be done.
On the other hand, the
On Thu, Feb 23, 2012 at 8:25 AM, Petite Abeille petite.abei...@gmail.comwrote:
On Feb 23, 2012, at 2:16 PM, Abhinav Upadhyay wrote:
. I was wondering if I could insert them using a
single INSERT query
Ah, also, there is not much benefit in using a compound insert.
You could as well
Robert Gdula robert.gd...@gmail.com wrote:
I'm trying to add ICU to my Sqlite static library, compilation is ok, and I
have file of library, but when I try to use it I've got some errors,
anybody can help me what I do wrong ?
..\..\Library\SQLCIPHER\libSQLCIPHER.a(SqlCipher.o):SqlCipher.c||
Yes, that should work.
Thanks!!
Dave Watkinson wrote, On 2/22/2012 5:33 PM:
Did you mean something like
SELECT ''||text_field||'' FROM table;
so that your column's data is quoted?
~~~
Dave Watkinson
On Wed, Feb 22, 2012 at 6:26 PM, Igor Tandetnikitandet...@mvps.org wrote:
On 2/22/2012
The same, escaping double quotes inside the double quotes:
SELECT '' || replace(replace(text_field,'\','\\'),'','\') || ''
On Thu, Feb 23, 2012 at 15:16, Bill McCormick wpmccorm...@gmail.com wrote:
Yes, that should work.
Thanks!!
Dave Watkinson wrote, On 2/22/2012 5:33 PM:
Did you mean
29 matches
Mail list logo