On 9/7/2015 6:58 PM, Domingo Alvarez Duarte wrote:
> The create_collation functions have a signature similar to create_function
> but no mention abount add SQLITE_DETERMINISTIC to then, they do not need it ?
Collations are assumed to be deterministic - it makes no sense for them
not to be. What
SQL commands do not need to be on multiple lines (they only need a
semicolon after each command).
But dot commands do.
Have you tried the following?
(ECHO .bail on
ECHO %multiple commands%) | sqlite3.exe %dbname%
But, much more importantly (particularly since you included BEGINNER in big
letters
On 9/7/15, Domingo Alvarez Duarte wrote:
> Hello !
>
> The create_collation functions have a signature similar to create_function
> but no mention abount add SQLITE_DETERMINISTIC to then, they do not need it
> ?
That flag only works on functions.
--
D. Richard Hipp
drh at sqlite.org
On 9/7/15, Domingo Alvarez Duarte wrote:
> Hello !
>
> I'm converting a database from postgresql and when I tried to create this
> index it fails:
>
> CREATE UNIQUE INDEX country_name_idx on country(lower(name));
>
> Error: "non-deterministic functions prohibited in index expressions"
>
> Can the
Hi Simon and Stephan,
Thx for your answers, I was very busy the last week and I worked
on my program only saturday and yesterday. That's why I answering only
today, but I wanted to thank you.
I had some difficulties to use `sqlite_exec()` because I'm wrapping to
C++ all Sqlite3 functions I need
On 7 Sep 2015, at 8:00am, Petr L?z?ovsk? wrote:
> Uhgh Spent lot of time to made whole scripts bundle to use no tempfiles
> (avoiding I/Os), and not this ;-)
> OK, few more questions:
>
> Does sqlite3 expect exactly one statement per one line on input?
> Or put it into command line?
Hello !
Here is the parser code for the "SQL PROCEDURE" anyone have any comment on it
?
_
/ The SQL PREPARE statement /
%ifndef SQLITE_OMIT_SQL_PREPARED
cmd ::= create_prepared.? {sqlite3SqlPreparedFinishParse(pParse,0, 0);}
cmd
Hello !
I just cloned a fresh sqlite3 repository from
https://github.com/mackyle/sqlite and after executing "./configure
--disable-amalgamation; make" I'm get this error on ubuntu 14.04:
make: *** No rule to make target
`/home/mingo/dev/dadbiz++/third-party/sqlite3-git/manifest.uuid', needed
op 06-09-2015 22:42 schreef Scott Robison op scott at casaderobison.com:
> On Sun, Sep 6, 2015 at 10:54 AM, E.Pasma wrote:
>
>>
>> Op 6 sep 2015, om 16:44 heeft Scott Robison het volgende geschreven:
>>
>>>
>>> One, the argument wasn't whether or not column expressions were called
>>>
9 matches
Mail list logo