[sqlite] Result code differs running commands from script file and from console

On Sat, Mar 14, 2015 at 7:33 AM, Petr L?z?ovsk? wrote: > Just discovered the resulcodes differ if perform: > > > sqlite3.exe %db% < script.sql > > the %errorlevel% is 1 > > > but by > > > sqlite3.exe %db% "

[sqlite] "=" should not be a word character

On 3/14/15, Skip Montanaro wrote: > > > Then I retrieved that statement with Ctl-P, then clear the id with Ctl-B > ESC-Del. I then entered the id of the next record to correct, backed up and > adjusted the date, and hit enter. > > Imagine my surprise when what I actually typed (without checking, >

[sqlite] "=" should not be a word character

On Mar 14, 2015, at 6:45 PM, Richard Hipp wrote: > On 3/14/15, Skip Montanaro wrote: >>> >> Then I retrieved that statement with Ctl-P, then clear the id with Ctl-B >> ESC-Del. I then entered the id of the next record to correct, backed up and >> adjusted the date, and hit enter. >> >> Imagin

[sqlite] "=" should not be a word character

Put spaces around your = signs? update swimmeet set start = "2008-11-20" where id = 1038; Also, strings in SQL are delimted by single-quotes (') not double-quotes ("). Double quotes mean that the thing so contained is an ill-formed symbol (that is, a table name, column name, etc) that contain

[sqlite] Weird (slow) TEMP B-TREE ORDER BY

> -Original Message- > From: sqlite-users-bounces at mailinglists.sqlite.org [mailto:sqlite-users- > bounces at mailinglists.sqlite.org] On Behalf Of Dinu Marina > Sent: donderdag 12 maart 2015 11:34 > To: sqlite-users at mailinglists.sqlite.org > Subject: Re: [sqlite] Weird (slow) TEMP B

[sqlite] How to code this Std_Call?

Been working with this project: https://sqliteforexcel.codeplex.com/ and further enhanced that SQLite3_StdCall.dll with more SQLite functions. As said before I don't know C, but can work things out by looking at other functions. Now stuck though on a complex one, sqlite3_create_function. In the SQ

[sqlite] How initialize a database file from unix shell without landing in SQLite command prompt?

I have a file DBDEFINITION.TXT that I want to use to initialize [execute on] the database DB.SQLITE. How do I do something like $ sqlite3 -exec DBDEFINITION.TXT DB.SQLITE $ ? All methods I tried end me up in the SQLite prompt, and that is what I don't want. Like, doing sqlite3 -init DBDEFINITI

[sqlite] How initialize a database file from unix shell without landing in SQLite command prompt?

On 2015-03-14 10:51 AM, Mikael wrote: > I have a file DBDEFINITION.TXT that I want to use to initialize [execute > on] the database DB.SQLITE. > > How do I do something like > > $ sqlite3 -exec DBDEFINITION.TXT DB.SQLITE > $ A piped file is always the answer - for anything really. If a piped fil

[sqlite] Result code differs running commands from script file and from console

Just discovered the resulcodes differ if perform: sqlite3.exe %db% < script.sql the %errorlevel% is 1 but by sqlite3.exe %db% "UPDATE table SET '='"; the errorlevel is 19 (correct as by "https:/

[sqlite] How initialize a database file from unix shell without landing in SQLite command prompt?

Just pipe the text file to sqlite3 # sqlite3 DB.SQLITE : >I have a file DBDEFINITION.TXT that I want to use to initialize [execute >on] the database DB.SQLITE. >How do I do something like >$ sqlite3 -exec DBDEFINITION.TXT DB.SQLITE >$ >? >All methods I tried end me up in the SQLite prompt, and tha

[sqlite] "=" should not be a word character

I'm not sure where to report bugs/surprising behavior. The support page on the website doesn't mention a bug tracker. I use SQLite 3 mostly through the Python interface. I am working on a database where I'm adapting a huge crufty old spreadsheet with incomplete data. I am thus frequently in the sq