> I think the enhancement is here:
> https://sqlite.org/src/timeline?c=ed0842c156ab1a78
>
> That would correspond to version 3.20.0.
>
> --
> D. Richard Hipp
Thank you. The upcoming Ubuntu LTS release (20.04) includes sqlite version
3.31.1, so the issue should disappear soon also for me.
On 3/9/20, Keith Medcalf wrote:
>>I use sqlite3 (sqlite3 --version = "3.11.0 2016-02-15 17:29:24
>>3d862f207e3adc00f78066799ac5a8c282430a5f" on Ubuntu 16.04.6 LTS) for
>
> Have you tried version more recent than 4 years and 1 month old?
> I think some of these issues may have been fixed in the
>I use sqlite3 (sqlite3 --version = "3.11.0 2016-02-15 17:29:24
>3d862f207e3adc00f78066799ac5a8c282430a5f" on Ubuntu 16.04.6 LTS) for
Have you tried version more recent than 4 years and 1 month old?
I think some of these issues may have been fixed in the last couple of years.
--
The fact that
softw...@quantentunnel.de, on Monday, March 9, 2020 04:02 PM, wrote...
>
> Hi
>
> I use sqlite3 (sqlite3 --version = "3.11.0 2016-02-15 17:29:24
> 3d862f207e3adc00f78066799ac5a8c282430a5f" on Ubuntu 16.04.6 LTS) for
> formatted output. '.width' does not behave as I expected when non-ASCII
>
Hi
I use sqlite3 (sqlite3 --version = "3.11.0 2016-02-15 17:29:24
3d862f207e3adc00f78066799ac5a8c282430a5f" on Ubuntu 16.04.6 LTS) for formatted
output. '.width' does not behave as I expected when non-ASCII Unicode
characters are printed. It seems that .width counts bytes and not characters.
Consider:
sqlite> .parameter init
sqlite> .parameter set :date '2019-11-15'
sqlite> .parameter list
:date 1993
How do I make it treat the value argument as a string and not as a numeric
expression that gets evaluated?
___
sqlite-users mailing list
I need sqlite3 to be built with -DSQLITE_ENABLE_DBPAGE_VTAB so that I can
use the ".recover" command. The ".dbinfo" command doesn't work either.
I add -DSQLITE_ENABLE_DBPAGE_VTAB to the sqlite recipe CFLAGS in various
ways but I never get sqlite3 built with the option. Example error: the
On Wed, 3 Jul 2019 20:48:42 -0500, Lewis Balentine wrote:
> *First, version numbers:*
> My desktop is running: Linux Mint 19.1 with the MATE 1.20.1 user interface,
> Kernel 4.15.0-52 Generic x86_64
> The network machine is running: Linux Mint 18.3 with the MATE 1.18.0 user
> interface, Kernel
On 7/3/19, Lewis Balentine wrote:
> When I open the file in DB Browser for SQLite I can browse the tables but I
> can not change anything.
> The error is: "attempt to write a readonly database"
Is the directory that contains the database file writable? It needs
to be in order to write to the
*First, version numbers:*
My desktop is running: Linux Mint 19.1 with the MATE 1.20.1 user interface,
Kernel 4.15.0-52 Generic x86_64
The network machine is running: Linux Mint 18.3 with the MATE 1.18.0 user
interface, Kernel 4.4.0-141 Generic x86_64
SQLite Version 3.22.0
DB Browser for SQLite
On Wed, 1 May 2019 at 19:30, Frank Kemmer wrote:
>
> https://github.com/xerial/sqlite-jdbc/blob/14839bae0ceedff805f9cda35f5e52db8c4eea88/src/main/java/org/sqlite/core/CoreResultSet.java#L86
>
> Here we see, that colsMeta == null results in throwing the seen exception.
>
> But how can colsMeta be
I looked into the JDBC driver source code and found the following two code
lines mentioned in the stack trace.
Sqlline is trying to get the tablename of the resultSet which results in
the invocation of:
Simon Slavin schrieb am Sa. 27. Apr. 2019 um 14:28:
> On 27 Apr 2019, at 10:47am, Frank Kemmer wrote:
>
> > I can connect to the database, create a table, select from the table,
> insert into the table, but the first time I try to read after an insert I
> get the following exception:
>
> >> Are
On 27 Apr 2019, at 10:47am, Frank Kemmer wrote:
> I can connect to the database, create a table, select from the table, insert
> into the table, but the first time I try to read after an insert I get the
> following exception:
Are you checking the result codes from all these operations ?
If
I am using:
- sqlline-1.7.0-jar-with-dependencies.jar
- sqlite-jdbc-3.27.2.jar
I can connect to the database, create a table, select from the table,
insert into the table, but the first time I try to read after an insert I
get the following exception:
0: jdbc:sqlite:/maxmin> SELECT * FROM
I was able to reproduce this behaviour using much shorter query (in
sqlite.exe 3.27.1):
SELECT + sum(0) OVER() ORDER BY + sum(0) OVER();
SELECT + avg(0) OVER() ORDER BY + avg(0) OVER();
SELECT 1 + avg(0) OVER() ORDER BY 1 + avg(0) OVER();
SELECT - - - - - avg(0) OVER()
?SELECT(+++ last_insert_rowid()++sum(0)oVER())ORDER BY
(+++ last_insert_rowid()++sum(0)oVER())ORDER BY
1,1,1,1,1,1?
Best regards
Longfei Fan from 360 Codesafe Team of Legendsec?
___
sqlite-users mailing
tasvgt
>Sent: Wednesday, 6 February, 2019 12:47
>To: sqlite-users@mailinglists.sqlite.org
>Subject: [sqlite] Sqlite3: create a database from file using one line
>command-line script
>
>Hi, I need to run a command to create a database and populate it from
>a
>.sql file at once
sqlite3 myDatabase.db ".read myCommands.sql"
On Wed, Feb 6, 2019 at 3:30 PM kostasvgt wrote:
> Hi, I need to run a command to create a database and populate it from a
> .sql file at once from command-line, not dot-commands.
> Is there any way to do this in one line?
>
> Thanks.
>
Hi, I need to run a command to create a database and populate it from a
.sql file at once from command-line, not dot-commands.
Is there any way to do this in one line?
Thanks.
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
Hi Simon Slavin,
Thank you for the reply. Yes I am using single thread and single connection.
Can you tell me what happen if i try with multiple thread and single connection
to write the data (Multiple thread trying to write into DB will it follow the
serialization because of the FULLMUTEX and
On 17 Dec 2018, at 9:01am, Prajeesh Prakash
wrote:
> What are the possible failure cases of DB write in case of single connection.
> Because in my application i needs to handle those cases. Can anyone help me
> for the same.
You state that you're using a single connection. I will assume
Hi Team,
What are the possible failure cases of DB write in case of single connection.
Because in my application i needs to handle those cases. Can anyone help me for
the same.
Thank you
___
sqlite-users mailing list
Dear,
> Le 27 nov. 2018 à 10:24, Prajeesh Prakash a
> écrit :
>
> I am using sqlite3 Asynchronous I/O on my application. So is there any way to
> get the status of the DB update (After the write operation) from the
> asyncWriterThread so that my application can do the proper error handling.
Yes it is, On sqlite3async.c file i found asyncWriterThread but i didn't find
any callback to let the application know the status of the DB update. How this
thread writing the data to DB, I am little bit confused.
>
> On November 27, 2018 at 3:12 PM Shawn Wagner
> wrote:
>
> By
Yes it is.
>
> On November 27, 2018 at 3:12 PM Shawn Wagner
> wrote:es
>
> By asynchronous i/o, do you mean the vfs module described here:
> https://www.sqlite.org/asyncvfs.html ?
>
> On Tue, Nov 27, 2018, 1:24 AM Prajeesh Prakash
>
> > >
> > Hi
By asynchronous i/o, do you mean the vfs module described here:
https://www.sqlite.org/asyncvfs.html ?
On Tue, Nov 27, 2018, 1:24 AM Prajeesh Prakash
Hi Members,
>
> I am using sqlite3 Asynchronous I/O on my application. So is there any way
> to get the status of the DB update (After the write
Hi Members,
I am using sqlite3 Asynchronous I/O on my application. So is there any way to
get the status of the DB update (After the write operation) from the
asyncWriterThread so that my application can do the proper error handling.
I am expecting a reply.
Thank you
Prajeesh P
Hi Ricardo,
On 15 August 2018 at 06:26, Ricardo Lima wrote:
> I built a straightforward program in C. It's just a STACK structure (first
> in, last out) that takes input from the user and stores it into the stack.
> After I close the program, all the data vanishes since I don't have a
>
On 15 Aug 2018, at 6:26am, Ricardo Lima wrote:
> I don't get any compilation errors and the SQLite source files/header files
> are implemented correctly into the code. I know this because I'm using SQLite
> Studio ( SQLite GUI) and I see all the attributes from the wallet DB, but
> they are
I built a straightforward program in C. It's just a STACK structure (first in,
last out) that takes input from the user and stores it into the stack. After I
close the program, all the data vanishes since I don't have a database
implemented into the program. Even so, the program runs fine. It
Some ideas:
Sqlite may return that the database is locked immediately if it detects a
deadlock situation. Something like: a different connection holds a reserved
lock (waiting for read connections to close so it can promote to exclusive),
and the current connection tries to promote from a read
On 3 Jul 2018, at 8:08pm, Phani Rahul Sivalenka
wrote:
> As per our observation, the initial write operations on the sqlite db file
> throw "db is locked" error. After a certain time (around an hour) write
> operations start working and we are able to do all the operations as
> required. [...]
As per our observation, the initial write operations on the sqlite db file
throw "db is locked" error. After a certain time (around an hour) write
operations start working and we are able to do all the operations as
required.
On Mon, Jun 25, 2018 at 7:37 PM Phani Rahul Sivalenka
wrote:
> >
> SQLiteConnectionStringBuilder connBuilder = new
> SQLiteConnectionStringBuilder();
We are setting these configs via the connection string in xml. This is same as
the above. The following is the connection string that we are using:
“data
On 21 Jun 2018, at 10:01pm, Phani Rahul Sivalenka
wrote:
> When we do a read operation and write/update operation on the SQLite DB,
> the write operation gets timed out saying the “db is locked”.
[...]
> - Busy Timeout : 30sec
> - Default Timeout : 30sec
I'm going to assume you're doing
Hello,
We have an ASP.NET Web application running with Mono on Linux. Uses
System.Data.SQLite library with an interop generated with a specific set
configuration to interact with the SQLite file.
When we do a read operation and write/update operation on the SQLite DB,
the write operation gets
On Tue 08 May 2018 9:32 AM, Domingo Alvarez Duarte wrote:
> Hello !
>
> Today I tried to update my sqlite3 repository but somehow it seems not
> working properly, I execute "fossil update" as usually and it contacts the
> server and exchange info with it but it only see till this commit
>
On Tue, May 8, 2018 at 2:11 PM, Richard Hipp wrote:
> On 5/8/18, Francis Kus wrote:
> > I am able to open my database file if the path contains no accents.
> However,
> > if I change even one letter to an accented letter (e.g. replace 'e' with
> > 'é'),
On 5/8/18, Francis Kus wrote:
> I am able to open my database file if the path contains no accents. However,
> if I change even one letter to an accented letter (e.g. replace 'e' with
> 'é'), the database does not open and I get the error message "unable to open
>
Hi,
I am experiencing the following issue using SQLite 3.22.0:
I am able to open my database file if the path contains no accents. However, if
I change even one letter to an accented letter (e.g. replace 'e' with 'é'), the
database does not open and I get the error message "unable to open
On 5/8/18, Domingo Alvarez Duarte wrote:
>
> Still it seems that there is more than one fossil server and they seem
> to lag from the main one.
>
There are three. They sync with each other hourly, via cron job.
--
D. Richard Hipp
d...@sqlite.org
Hello !
I just retried again and now it got updated to the same content I can
see on the web.
Still it seems that there is more than one fossil server and they seem
to lag from the main one.
Cheers !
___
sqlite-users mailing list
Hello !
Today I tried to update my sqlite3 repository but somehow it seems not
working properly, I execute "fossil update" as usually and it contacts
the server and exchange info with it but it only see till this commit
http://www.sqlite.org/src/info/c381f0ea57002a264fd958b28e .
There is
HI every one
i use sqlite3 3.22.0 verison on embeded arm9 system
when i insert a lot of data like this
begin_transaction
sqlite3_prepare_v2();
for(i = 0;i<2040;i++)
{
sqlite3_bind_text();
sqlite3_bind_blob();
sqlite3_step();
sqlite3_reset();
sqlite3_clear_bindings();
}
length indicator and are not
>> zero-terminated.
>>
>> ---
>> The fact that there's a Highway to Hell but only a Stairway to Heaven
>> says a lot about anticipated traffic volume.
>>
>>
>> >-Original Message-
>> >From: sqlite-user
t anticipated traffic volume.
>
>
> >-----Original Message-
> >From: sqlite-users [mailto:sqlite-users-
> >boun...@mailinglists.sqlite.org] On Behalf Of J Decker
> >Sent: Thursday, 19 April, 2018 16:41
> >To: SQLite mailing list
> >Subje
ticipated traffic volume.
>-Original Message-
>From: sqlite-users [mailto:sqlite-users-
>boun...@mailinglists.sqlite.org] On Behalf Of J Decker
>Sent: Thursday, 19 April, 2018 16:41
>To: SQLite mailing list
>Subject: Re: [sqlite] SQLite3 - Search on text field with \0 b
On Thu, Apr 19, 2018 at 3:37 PM, J Decker wrote:
>
>
> On Thu, Apr 19, 2018 at 3:22 PM, Keith Medcalf
> wrote:
>
>>
>> Actually, nothing in the C or C++ world will "go past" the NULL byte
>> since the very definition of a C string is a "bunch-o-bytes that
On Thu, Apr 19, 2018 at 3:22 PM, Keith Medcalf wrote:
>
> Actually, nothing in the C or C++ world will "go past" the NULL byte since
> the very definition of a C string is a "bunch-o-bytes that are non-zero
> followed by one that is".
>
> that doesnt' mean you can use a
re's a Highway to Hell but only a Stairway to Heaven says a
lot about anticipated traffic volume.
>-Original Message-
>From: sqlite-users [mailto:sqlite-users-
>boun...@mailinglists.sqlite.org] On Behalf Of J Decker
>Sent: Thursday, 19 April, 2018 14:09
>To: SQLite ma
users-boun...@mailinglists.sqlite.org]
> On Behalf Of MARCHAND Loïc
> Sent: Thursday, April 19, 2018 8:27 AM
> To: sqlite-users@mailinglists.sqlite.org
> Subject: [sqlite] SQLite3 - Search on text field with \0 binary data
>
> I index a file in a SQLite DB.
> I create my table with
Loïc
Sent: Thursday, April 19, 2018 8:27 AM
To: sqlite-users@mailinglists.sqlite.org
Subject: [sqlite] SQLite3 - Search on text field with \0 binary data
I index a file in a SQLite DB.
I create my table with this:
CREATE TABLE Record (RecordID INTEGER,Data TEXT,PRIMARY KEY (RecordID))
I read
On 19 Apr 2018, at 1:27pm, MARCHAND Loïc wrote:
> CREATE TABLE Record (RecordID INTEGER,Data TEXT,PRIMARY KEY (RecordID))
>
> I read a file, and for each line I add a row on the table. Each line can have
> binary data at end. It's not a problem for many chars, but
are you testing this in the sqlite3 shell or in your own program?
You should have no issue getting thisdata,
sqlite3_column_text followed by sqlite3_column_bytes (the byte count is
set when the data is fetched in some format).
without modification, you can either excape \0 with'||char(0)||'
I index a file in a SQLite DB.
I create my table with this:
CREATE TABLE Record (RecordID INTEGER,Data TEXT,PRIMARY KEY (RecordID))
I read a file, and for each line I add a row on the table. Each line can have
binary data at end. It's not a problem for many chars, but \0 char make a
problem.
If
On 03/20/2018 02:31 PM, zheng xiaojin wrote:
(I am not sure whether you have seen my message, so resend again)
Hi,
When I use FTS5, I have met that, there are some cases which will get mis-match
results with prefix search.
Like "select * from tbl_fts where tbl_fts match 'lucy*';",which I want
(I am not sure whether you have seen my message, so resend again)
Hi,
When I use FTS5, I have met that, there are some cases which will get mis-match
results with prefix search.
Like "select * from tbl_fts where tbl_fts match 'lucy*';",which I want to get
records like "lucya","lucyabc" etc, and
Dan Kennedy wrote:
> To: SQLite mailing list ,
I didn't get your mail because I am not subscribed and was not CCed.
> In frame 0 of thread 1, what do the following gdb commands say?
>
>print *pCache
>print *pPage
I can't provide that easily
Hi all,
last sqlite 322 does not build with -DSQLITE_OMIT_AUTHORIZATION because
shell.c in sqlite3_expert_new use it.
I suggest the next patch to solve the problem.
Regards
diff --git a/shell.c b/shell.c
--- a/shell.c
+++ b/shell.c
@@ -7702,7 +7702,9 @@ sqlite3expert
On 12/23/2017 08:41 AM, Paul Wise wrote:
On Fri, 2017-12-22 at 20:09 -0500, Richard Hipp wrote:
Nevertheless, we will investigate from the SQLite side,
just in case.
If you need any information from the core dump, please let me know
which gdb commands to run. I still have one available from
On Fri, 2017-12-22 at 20:09 -0500, Richard Hipp wrote:
> Nevertheless, we will investigate from the SQLite side,
> just in case.
If you need any information from the core dump, please let me know
which gdb commands to run. I still have one available from the latest
crash and have marked it
On Fri, 2017-12-22 at 20:09 -0500, Richard Hipp wrote:
> There are no known issues like this with any recent version of SQLite.
> Usually these kinds of things end up being heap corruption in the
> application. Nevertheless, we will investigate from the SQLite side,
> just in case.
I see,
On 12/22/17, Paul Wise wrote:
> Hi all,
>
> I got a couple of random crashes GNOME's tracker-store daemon that
> appear to be related to sqlite3. I use 3.21.0-1 from Debian buster.
>
> Is this a bug in sqlite3 or is it caused by data corruption?
>
There are no known issues
Hi all,
I got a couple of random crashes GNOME's tracker-store daemon that
appear to be related to sqlite3. I use 3.21.0-1 from Debian buster.
https://bugzilla.gnome.org/show_bug.cgi?id=791243
The short backtraces are available here:
>From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On
>Behalf Of Simon Slavin
>Sent: Monday, December 11, 2017 12:50 PM
>To: SQLite mailing list <sqlite-users@mailinglists.sqlite.org>
>Subject: Re: [sqlite] SQLite3 on WinCE platform
>
>On 11
On 11 Dec 2017, at 8:59am, Ertan Küçükoğlu wrote:
> Error I am getting when application runs is: EInOutError: Can not load
> SQLite client library "sqlite3ce.dll". Check your installation.
Given this page
Hello,
I am using SQLite3 on handheld barcode scanners. Development platform of my
choice is Lazarus (free pascal).
These handheld devices run WinCE operating system. I have found a
sqlite3ce.dll which I have downloaded from Lazarus forums. That DLL is
version 3.9.2.0 compiled for WinCE 5+
On Sat, Oct 14, 2017 at 10:47 PM, Phoenix
wrote:
> Dominique wrote:
> Not to sound too snarky, but both questions can easily be answered
> through experimentation.
> You can also use http://www.dependencywalker.com/ to inspect DLL and
> EXE dependencies. --DD
Sorry I have not responded to the raised questions on this post but I
have not received any Digests since the 8th (Volume 118 Issue 8).
Dominique wrote:
Not to sound too snarky, but both questions can easily be answered through
experimentation.
You can also use
err.. that should be Embarcadero 10.1 Berlin... ugh.. PROOFREAD!!!
On Tue, Oct 10, 2017 at 4:20 PM, Stephen Chrzanowski
wrote:
>
> Based purely on my experience with Delphi (From Borland Version 5 to
> Emarcadero 10.5 Berlin);
>
1> Standalone
2.a> If you're referring to the DLL from an application you're building, it
must be either the Path, or, in the "Directory" your shortcut points to,
which is either something custom, or, the EXEs current directory. Its
already been mentioned where that DLL should be placed.
2.b> If
> simultaneously you need to be careful where you put them of use the default
> System directories.
>
> ---
> The fact that there's a Highway to Hell but only a Stairway to Heaven says
> a lot about anticipated traffic volume.
>
>
> >-Original Message-----
> &g
al Message-
>From: sqlite-users [mailto:sqlite-users-
>boun...@mailinglists.sqlite.org] On Behalf Of Warren Young
>Sent: Tuesday, 10 October, 2017 08:57
>To: SQLite mailing list
>Subject: Re: [sqlite] SQLite3 on Windows
>
>On Oct 10, 2017, at 3:49 AM, Phoenix <rwm.phoe...@btinternet.com>
>
On Oct 10, 2017, at 3:49 AM, Phoenix wrote:
>
> 2) Does the .dll need to be in a specific folder or is it okay if the
> folder is listed in my PATH?
https://msdn.microsoft.com/en-us/library/windows/desktop/ms682586(v=vs.85).aspx
On Tue, Oct 10, 2017 at 11:49 AM, Phoenix
wrote:
> I've downloaded the dll-win32 version of SQLite3 and have a couple of
> questions.
>
> 1) Does sqlite3.exe require the .dll file or is it stand-alone?
>
> 2) Does the .dll need to be in a specific folder or is it okay
I've downloaded the dll-win32 version of SQLite3 and have a couple of
questions.
1) Does sqlite3.exe require the .dll file or is it stand-alone?
2) Does the .dll need to be in a specific folder or is it okay if the
folder is listed in my PATH?
___
On 10/4/17, Hegde, Deepakakumar (D.) wrote:
>
>
> 1) Open the Database in the two process
>
> 2) Both the link are added the busy handler and busy handler function is
> retries for 1 times with 10ms second of delay.
>
> 3) In one thread there is a continuous record
gt; on behalf of
Simon Slavin <slav...@bigfraud.org>
Sent: Thursday, October 5, 2017 8:00:31 AM
To: SQLite mailing list
Subject: Re: [sqlite] Sqlite3 Multi-process handling with continuous begin and
commit in one thread cause error for other thread sqlite3_exec.
On 5 Oct 2017,
On 5 Oct 2017, at 3:17am, Hegde, Deepakakumar (D.)
wrote:
> 2) Both the link are added the busy handler and busy handler function is
> retries for 1 times with 10ms second of delay.
> sqlite3_busy_handler(psRaceSqlite->sSqliteInfo.pSqlHandle,
>
On 10/4/2017 10:17 PM, Hegde, Deepakakumar (D.) wrote:
There is a problem we are facing with the multiple DB process write operation.
Following the procedure:
1) Open the Database in the two process as:
sqlite3_open_v2 (pcDbName, >sSqliteInfo.pSqlHandle,
(SQLITE_OPEN_READWRITE |
Hi All,
There is a problem we are facing with the multiple DB process write operation.
Following the procedure:
1) Open the Database in the two process as:
sqlite3_open_v2 (pcDbName, >sSqliteInfo.pSqlHandle,
(SQLITE_OPEN_READWRITE | SQLITE_OPEN_CREATE | SQLITE_OPEN_FULLMUTEX),
Thanks for the report.
Thanks to Simon for verifying that these are all associated with the
command-line shell only and not with the SQLite core.
Note to Ryan: Please make sure your fuzzer is running inside a
sandbox, in case the fuzzer discovers pernicious dot-commands like
".sy rm -rf ~"
On
On 24 Jun 2017, at 2:29am, Ryan Whitworth wrote:
> GDB backtrace details and input files can be found here:
> https://github.com/rwhitworth/sqlite-fuzz/tree/master/2017-06-23-sqlite3.
For those interested, all the faults found seem to concern dot commands. Here
is an
Hello all,
I was using American Fuzzy Lop (afl-fuzz) to fuzz test stdin to the sqlite3
interactive shell. AFL found a few inputs that cause segmentation faults
(mostly due to failed assertions, I think?). Is this sort of thing worth
investigating further or a non-issue?
GDB backtrace details
Like this it works.
OK, building the temporary table takes some seconds with a table of 10 mio
records, but the queries are really fast then, 10 to 30 ms!!
Thanks so much guys for helping me with this :)
Tom
Am 24.05.2017 um 18:42 schrieb Keith Medcalf:
On Wednesday, 24 May, 2017 07:21
On Wednesday, 24 May, 2017 07:21
> > there is no system in existence that will do
> I was working a lot with Valentina-DB and they have a cursor class:
>
> var cursor=database.SqlSelect( "SELECT... WHERE... ORDER...");
>
> then you can just get any the ListView wants, forward and backwards,
nal Message-
From: sqlite-users
[mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of
Thomas Flemming
Sent: Wed 24 May 2017 10:37
To: sqlite-users@mailinglists.sqlite.org
Subject: Re: [sqlite] SQLite3.Step fast forward / skipping rows
Almost, but when you compare to a telephone directory, then th
On 5/24/17, Thomas Flemming wrote:
> Hi Ron,
>
> > there is no system in existence that will do
> I was working a lot with Valentina-DB and they have a cursor class:
>
> var cursor=database.SqlSelect( "SELECT... WHERE... ORDER...");
>
> then you can just get any the ListView
f Of Thomas Flemming
Sent: Wed 24 May 2017 14:21
To: sqlite-users@mailinglists.sqlite.org
Subject: Re: [sqlite] SQLite3.Step fast forward / skipping rows
Hi Ron,
> there is no system in existence that will do
I was working a lot with Valentina-DB and they have a cursor class:
var cursor=data
ge-
From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On
Behalf Of Thomas Flemming
Sent: Wed 24 May 2017 10:37
To: sqlite-users@mailinglists.sqlite.org
Subject: Re: [sqlite] SQLite3.Step fast forward / skipping rows
Almost, but when you compare to a telephone directory, then the use cas
4 May 2017 10:37
To: sqlite-users@mailinglists.sqlite.org
Subject: Re: [sqlite] SQLite3.Step fast forward / skipping rows
Almost, but when you compare to a telephone directory, then the use
case of
fast scrolling down in a listbox would be going directly to page 800
and not
going to "Smit
I might be wrong, but to me this sounds like an application coding problem
to do with your listview.
You will need to code in such a way that the listview doesn't get updated
when it doesn' t have to.
Does the data come directly from the DB or is there an intermediate eg an
array?
RBS
On Wed,
te-users-boun...@mailinglists.sqlite.org] On
Behalf Of Thomas Flemming
Sent: Wed 24 May 2017 10:37
To: sqlite-users@mailinglists.sqlite.org
Subject: Re: [sqlite] SQLite3.Step fast forward / skipping rows
Almost, but when you compare to a telephone directory, then the use case of
fast scrolling down in a
t page of results.
-Ursprüngliche Nachricht-
Von: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] Im
Auftrag von Thomas Flemming
Gesendet: Mittwoch, 24. Mai 2017 10:09
An: sqlite-users@mailinglists.sqlite.org
Betreff: [sqlite] SQLite3.Step fast forward / skipping rows
Hi
age-
From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On
Behalf Of Thomas Flemming
Sent: Wed 24 May 2017 10:37
To: sqlite-users@mailinglists.sqlite.org
Subject: Re: [sqlite] SQLite3.Step fast forward / skipping rows
Almost, but when you compare to a telephone directory, then
:09
To:sqlite-users@mailinglists.sqlite.org Subject: [sqlite] SQLite3.Step
fast forward / skipping rows
Hi SQLite Users,
I have a SELECT query, which returns some 10 records and is
displayed in a scrollable ListView.
When the user scrolls down the list, each new row is loaded with
SQLite3.Step().
The probl
unique key for the list?
--
˙uʍop-ǝpısdn sı ɹoʇıuoɯ ɹnoʎ 'sıɥʇ pɐǝɹ uɐɔ noʎ ɟı
> -Original Message-
> From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org]
> On Behalf Of Thomas Flemming
> Sent: Wednesday, 24 May, 2017 02:09
> To: sqlite-users@mailinglists.sqli
Hi SQLite Users,
I have a SELECT query, which returns some 10 records and is displayed in a
scrollable ListView.
When the user scrolls down the list, each new row is loaded with SQLite3.Step().
The problem is, when the user scrolls fast with the scroll-slider, lots of
rows are skipped,
While checking something else I came across this.
SQLite version 3.16.0 2016-11-04 19:09:39
Enter ".help" for usage hints.
Connected to a transient in-memory database.
Use ".open FILENAME" to reopen on a persistent database.
sqlite> PRAGMA foreign_keys = ON;
sqlite> PRAGMA foreign_keys;
1
sqlite>
1 - 100 of 1359 matches
Mail list logo