> On Jul 20, 2018, at 10:06 AM, Victor Da Costa
> wrote:
>
> After building the library my application seems to detect it but I get this
> error on the Password field :
>
> System.EntryPointNotFoundException: Unable to find an entry point named
> "sqlite3_rekey" in DLL "sqlite3"
SQLite 3.24.0 fails to build on Solaris 9 (a.k.a. Solaris 2.9) due to
not finding fchmod, fchown, readlink, lstat, usleep, struct timeval, and
gettimeofday.
To correct, do not #define _XOPEN_SOURCE. There's already a check for
Mac OS X, so I would suggest extending the check to also exclude
There is very little pressure to keep the shell tool small. So the check for
views which refer to non-existent tables could be put into there, as part of
one of the dot-commands which do checking.
As for the code, it doesn't require anything more than SQL commands. There's
no need for access
On 2018/07/27 1:59 PM, Dominique Devienne wrote:
Sigh. We already have 4 different check pragmas (cell-size, fk, integrity,
quick).
One more for views seems perfectly in line with those. Did anyone raise the
same
old light-code-bloat argument for those too, in the past? I for one cringe
every
On Fri, Jul 27, 2018 at 11:33 AM R Smith wrote:
> On 2018/07/27 10:40 AM, Dominique Devienne wrote:
> > On Fri, Jul 27, 2018 at 1:58 AM Richard Hipp wrote:
> >> On 7/26/18, Tomasz Kot wrote:
> >>> Beneath sql shall throw an error on CREATE VIEW statement (as invalid
> >>> column is
On 2018/07/27 12:51 PM, Richard Hipp wrote:
Seem right. If a change happens to the database in the middle of a
backup, the backup automatically restarts, so that at the end of a
backup you are guaranteed to have a consistent copy from a single
point in time (something that you are not
On 7/25/18, Rune Torgersen wrote:
> Management wants to know if we're doing it correctly, or if there are
> faster/easier ways to do backup (and check).
> Also wants to know if a backup done using the live backup API gives us an
> exact copy (with any possible corruption) or if the backup is
Thanks for that. A QuotedString function will be useful indeed and will add
that.
In this case my language is B4A, which is similar to the old VB6.
Very good and much recommended.
RBS
On Fri, Jul 27, 2018 at 11:32 AM, R Smith wrote:
> On 2018/07/27 11:15 AM, Bart Smissaert wrote:
>
>> xxx is
On 2018/07/27 11:15 AM, Bart Smissaert wrote:
xxx is an identifier. It has no meaning at all in SQL and needs to be
replaced by the app.
Ok, so your app needs to replace xxx with 'A', 'B', 'C' then?
Well, that depends on what language your App is?
For example, assuming the query 'SELECT *
Yes, that works indeed. I made a silly mistake and that is that the replace
took already place in the table insertion SQL!
Idea is that users can make a shortcut in the SQL and not type out a long
string every time.
All sorted now.
RBS
On Fri, Jul 27, 2018 at 10:25 AM, Hick Gunter wrote:
>
On 2018/07/27 10:40 AM, Dominique Devienne wrote:
On Fri, Jul 27, 2018 at 1:58 AM Richard Hipp wrote:
On 7/26/18, Tomasz Kot wrote:
Hello,
Beneath sql shall throw an error on CREATE VIEW statement (as invalid
column is specified), but it passes (SQLite 3.23.1).
The error is deferred
Insert into sql_replace values ('xxx','''A'',''B'',''C''');
Note: All single quotes. To include a single quote in a single quoted string,
it needs to be doubled.
Not sure what you are trying to do here. Build SQL queries on the fly?
-Ursprüngliche Nachricht-
Von: sqlite-users
xxx is an identifier. It has no meaning at all in SQL and needs to be
replaced by the app.
I have given the SQL string before and after the replacement:
select * from table1 where a in(xxx)
then after the string replacement it should be this:
select * from table1 where a in('A', 'B', 'C')
The
On 2018/07/27 10:38 AM, Bart Smissaert wrote:
Have a table like this:
create table sql_replace(string_old text, string_new text)
The idea is to do automatic string replacements in SQL.
Say we have this SQL:
select * from table1 where a in(xxx)
then after the string replacement it should be
On Fri, 27/7/18, Simon Slavin wrote:
Subject: Re: [sqlite] Backup and integrity check questions
To: "SQLite mailing list"
Date: Friday, 27 July, 2018, 6:35
On 27 Jul 2018, at 6:02am, Rowan
Worth
wrote:
> (any writes to
a DB are
Have a table like this:
create table sql_replace(string_old text, string_new text)
The idea is to do automatic string replacements in SQL.
Say we have this SQL:
select * from table1 where a in(xxx)
then after the string replacement it should be this:
select * from table1 where a in('A', 'B',
On Fri, Jul 27, 2018 at 1:58 AM Richard Hipp wrote:
> On 7/26/18, Tomasz Kot wrote:
> > Hello,
> >
> > Beneath sql shall throw an error on CREATE VIEW statement (as invalid
> > column is specified), but it passes (SQLite 3.23.1).
>
> The error is deferred until you try to use the view. The
17 matches
Mail list logo