On 10/18/2018 04:58 PM, Maziar Parsijani wrote:
Hi,
how could I ignore syntax errors like this?
*SELECT *,*
* highlight(searchsimpleenhanced, 2, '', '') text*
* FROM searchsimpleenhanced*
* WHERE searchsimpleenhanced MATCH 'sth][';*
You can use double quotes to search for a token that
On 10/18/2018 09:27 PM, Bob schwanzer wrote:
Hi,
I'm seeing hot journal frequently in our SQLite installation. We use VFS
which does some checksum and other operations. There are no abnormal
scenarios such as power off, process crash, abandoned transactions... DB is
opened by 10-20 processes
More specifically, in the "Simple Features for SQL" specification:
http://www.opengeospatial.org/standards/sfs
and if you have access (or gobs of money), there's the ISO spec (I'm
guessing it's the same) -
https://webstore.ansi.org/RecordDetail.aspx?sku=ISO+19125-1%3A2004
I'd also suggest
> I have a bunch of hyperlinks in an SQLite database, and need to read each
> page for validation before deleting the record.
> To make it easier, the DB manager should launch the default web browser
when
> I double click on a column that contains a hyperlink.
> Before I build a GUI, is there a
On 20 Oct 2018, at 17:05, "p...@geniais.com" wrote:
> I'm using a C compiled program to write exclusively to a database, and a php
> script for reading only (that communicates via socket).
> I know I can use sqlite3_open_v2() with SQLITE_OPEN_READONLY in C, but there
> is a way to open a
On 20 Oct 2018, at 5:05pm, p...@geniais.com wrote:
> I'm using a C compiled program to write exclusively to a database, and a php
> script for reading only (that communicates via socket).
> I know I can use sqlite3_open_v2() with SQLITE_OPEN_READONLY in C, but there
> is a way to open a
Hello,
I'm using a C compiled program to write exclusively to a database, and a php
script for reading only (that communicates via socket).
I know I can use sqlite3_open_v2() with SQLITE_OPEN_READONLY in C, but there is
a way to open a database for readonly in php (since just one C program is
On 20 Oct 2018, at 1:19pm, p...@geniais.com wrote:
> I'm using exec() to simply get true/false result (just reading) and I'm
> receiving this error, even in WAL mode:
> SQLite3::exec(): database is locked in ... on line 47
>
> Any help will be apreciated
I'm assuming that you are aware that
Hello,
I'm using exec() to simply get true/false result (just reading) and I'm
receiving this error, even in WAL mode:
SQLite3::exec(): database is locked in ... on line 47
Any help will be apreciated
Thank you
Ismael
___
sqlite-users mailing
9 matches
Mail list logo