Re: [sqlite] Date time input

On Tue, Oct 8, 2019 at 2:40 PM James K. Lowden wrote: > On Tue, 8 Oct 2019 09:06:24 -0700 > Jens Alfke wrote: > > > I think the idea of a semi-official ?SQLite++? has been floated here > > before > > OK, but it needs a better name. -- > SQLiteXTD -- -- --Ö¿Ö-- K e V

Re: [sqlite] [EXTERNAL] Re: Documentation update request

ipp) > > -Ursprüngliche Nachricht- > Von: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] > Im Auftrag von Kevin Benson > Gesendet: Donnerstag, 15. August 2019 20:40 > An: SQLite mailing list > Betreff: [EXTERNAL] Re: [sqlite] Documentation updat

Re: [sqlite] Documentation update request

On Thu, Aug 15, 2019 at 2:33 PM Jose Isaias Cabrera wrote: > Richard Hipp, on Thursday, August 15, 2019 01:32 PM, wrote... > > > > On 8/15/19, Simon Slavin, on > > > On 15 Aug 2019, at 5:20pm, Richard Damon, on > > > > > >> You under quote, the faq says it “can not be changed (except under > >

Re: [sqlite] SQLITE_LOCKED means "database table is locked"?

On Wed, Jun 19, 2019 at 12:12 PM Carsten Müncheberg < carsten.muencheb...@native-instruments.de> wrote: > Am 19.06.2019 um 16:47 schrieb Igor Tandetnik: > > On 6/19/2019 10:39 AM, Carsten Müncheberg wrote: > >> Is there really something like a table lock? > > > > Yes there is:

Re: [sqlite] Usage of temporary files of SQLite3 on Android / SQLite commands fail

On Sun, Jun 10, 2018 at 12:45 PM skywind mailing lists < mailingli...@skywind.eu> wrote: > Hi, > > but to which directory should I set it? There is no general tmp directory > accessible. > > Regards, > Hartwig > > > Am 2018-06-10 um 02:30 schrieb Bob Friesenhahn < > bfrie...@simple.dallas.tx.us>:

Re: [sqlite] ROWID....

On Sat, Jun 9, 2018 at 7:03 AM Luuk wrote: > > In the docs (https://www.sqlite.org/autoinc.html) it says: > In SQLite, table rows normally have a 64-bit signed integer ROWID > > > Question: > Why it this a signed integer, and not an

Re: [sqlite] Fwd: Problem on Windows 10 machines

I wonder if the answer at this following inquiry is suggesting that your last posted results are unremarkable: https://stackoverflow.com/questions/11872539/windbg-crash-dump-analysis and that suggested alternative approach may be more helpful than WinDbg ? -- -- -- " --Ö¿Ö--

Re: [sqlite] Problem compiling 3.17.0 in MSVS 12

On Tue, Feb 14, 2017 at 7:56 PM, Bart Smissaert wrote: > I had to install WinZip though and at the first unzip I got directly to the > files whereas now I had a .tar file first and had to unzip that. > Following on from David Empson's post... the WinZip docs show an

Re: [sqlite] Retrieve INTEGER PRIMARY KEY

On Tue, Feb 7, 2017 at 4:11 PM, Clyde Eisenbeis wrote: > int iKeyID = (int)sqliteCmd.ExecuteScalar(); > I believe the type of last_insert_rowid() is *always* INT64 -- -- -- --Ö¿Ö-- K e V i N ___

Re: [sqlite] new user seeking help

On Thu, Jan 5, 2017 at 1:26 PM, Chen, Hui wrote: > Hi there, > > I just recently started integrating System.Data.SQLite.dll into my > project, I started with a very simple winform application. > > I have a very simple method to create a connection, txtSqliteFile is >

Re: [sqlite] Out of date online documents

On Sat, Dec 31, 2016 at 4:04 PM, Simon Slavin <slav...@bigfraud.org> wrote: > > On 31 Dec 2016, at 8:59pm, Kevin Benson <kevin.m.ben...@gmail.com> wrote: > > > > The Home page Search *DOES* result in linking to > > "other dot commands" but *NOT* >

Re: [sqlite] Out of date online documents

On Sat, Dec 31, 2016 at 3:20 PM, Paul Lambert wrote: > Web search. In fact I cannot find any link on the sqlite.org page that > links to the (dot) functions, alias special functions. > > The Home page Search *DOES* result in linking to "other dot commands" but *NOT* "special

Re: [sqlite] enabling FK in VisualStudio

On Sat, Sep 24, 2016 at 5:14 AM, denis wrote: > Hello all, I want enabling foreign key in the file app.config of visual > studio 2015 is-it possible? if yes, what is the string? > I tested connectionString = "data source=d:\db.sqlite; ForeignKeys=true;" > but the FK does not

Re: [sqlite] Conversion failure

-- -- -- --Ô¿Ô-- K e V i N On Thu, Jun 23, 2016 at 10:38 AM, Igor Korot wrote: > Hi, Clemens, > > On Thu, Jun 23, 2016 at 10:33 AM, Clemens Ladisch > wrote: > > Igor Korot wrote: > >> I am trying to find out why the following

[sqlite] Order with another sequence

> On Fri, Oct 9, 2015 at 5:08 AM, Cecil Westerhof > wrote: > > > When I use ORDER BY an ? comes after a z. Is it possible to make an ? > come > > after a z? > > > > If it is important I am using SQLite 3.8.6 and Python 3.4.1. > Perhaps you might garner some insight from looking at other's code?

[sqlite] DbFunctions.TruncateTime

On Sun, Aug 23, 2015 at 10:53 PM, Joe Mistachkin wrote: > > The LINQ provider for System.Data.SQLite does not provide this function > directly; however, it may be possible to use one of the core date-time > related SQL functions to do it? > > https://www.sqlite.org/lang_datefunc.html >

[sqlite] : it seems to be only orber by and group

On Sat, Aug 22, 2015 > afriendandmore wrote: > > The table shall be ordered according to A. (Order by A) > > But if C ist true and to the value B1 in this Record, there exists > another Record with B2 and B2 = B1, then B1 should be ordered in the row > above B2. If the B1 and B2, to which you

[sqlite] Database sybchronisation

On Thu, Aug 13, 2015 at 4:05 AM, Chris Parsonson wrote: > So can someone give me a working example of two database ATTACHed and a > simple select using columns from a table in each database C:\SQLite3>sqlite3 C:\SQLite3\UpdateWolfpro.db3 SQLite version 3.8.11.1 2015-07-29 20:00:57 Enter

[sqlite] System.Data.SQLite encryption

On Thu, Aug 6, 2015 at 4:16 AM, Marco Bambini wrote: > Anyone know which encryption algorithm is used in System.Data.SQLite? > Seems like it doesn?t use the standard SEE sqlite extension. > https://www.mail-archive.com/sqlite-users at sqlite.org/msg87770.html -- -- -- --???--

[sqlite] ATTACH Problem

On Fri, Jul 31, 2015 at 3:38 AM, Chris Parsonson wrote: > Forgot to add the code > Public Function SynchroniseDB() As Boolean > Dim dbConnection As New SQLiteConnection > Dim dbDataSet As New DataSet > Dim SQLStmt As String > Dim sDBPath As String =

[sqlite] SQLite transaction time limit

http://permalink.gmane.org/gmane.comp.db.sqlite.general/91411 'In the connection string, please use "Default Timeout"...' *SNIP* 'Also, the "Default Timeout" value is measured in seconds, so it would be...' *SNIP* -> 30 in your case. -- -- -- --???-- K e V i N On

[sqlite] Weird FTS bugs (wrong, missing and false positive results)

On Mon, Jul 6, 2015 at 8:23 AM, wrote: > > > --- ? --- > ?? : "Dan Kennedy" > : 2 2015, 14:26:05 > > > > On 07/02/2015 09:24 PM, Kevin Benson wrote: > >> FTFY, you're welcome ;-) > > Now *MAYBE* some

[sqlite] Weird FTS bugs (wrong, missing and false positive results)

FTFY, you're welcome ;-) Now *MAYBE* someone can read it and possibly reply. -- -- -- --???-- K e V i N On Thu, Jul 2, 2015 at 9:11 AM, wrote: > We use SQLite for indexing and searching the text contents of our app > using FTS4 > (about 27k unique words, about 1

[sqlite] VBA Sqllite blob data

On Tue, May 12, 2015 at 7:41 AM, Preston King wrote: > I have been able to use SQLite2009 Pro Management Studio to export the > specific record from the DB3 file into Excel without any issues, the entire > record appears correctly. I was trying to create VBA code within Excel to > do the same

[sqlite] Error while creating view through command line

Original Message- > From: sqlite-users-bounces at mailinglists.sqlite.org [mailto: > sqlite-users-bounces at mailinglists.sqlite.org] On Behalf Of Kevin Benson > Sent: Thursday, April 23, 2015 2:43 PM > To: General Discussion of SQLite Database > Subject: Re: [sqlite] Error while cr

[sqlite] Error while creating view through command line

On Thu, Apr 23, 2015 at 4:58 AM, Manoj Kumar Pasumarthi < manojkumar.pa at hcl.com> wrote: > Thanks for the reply Kevin. But it didn't worked. > If you issue the following after you do your ATTACH: PRAGMA database_list; do you see a row returned for that database you are ATTACHing? -- --

[sqlite] Error while creating view through command line

On Wed, Apr 22, 2015 at 11:49 AM, Manoj Kumar Pasumarthi < manojkumar.pa at hcl.com> wrote: > Hi, > > I am trying to create a new view through command line script (sqlite3) as > follow: > > > attach 'SP_R3.s3db' as sprdb; > > BEGIN TRANSACTION; > > > CREATE view sprdb.[view1] as select model from

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

On Sun, Mar 15, 2015 at 5:19 AM, Petr L?z?ovsk? wrote: > As far as I understood you comment (english is not my first language), > executing script could not provided specified resultcode because many fails > can occur and exitcode is only one? > Essentially, yes. The result code of 1 appears to

[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%

Re: [sqlite] Client/Server Best Practices

On Wed, Jan 7, 2015 at 11:47 PM, Keith Medcalf wrote: > On Wednesday, 7 January, 2015 20:01, James K. Lowden < > jklow...@schemamania.org> said: > >On Fri, 02 Jan 2015 21:41:02 -0700 > >"Keith Medcalf" wrote: > >> On Friday, 2 January, 2015 16:26, James

Re: [sqlite] Encrypted database

On Sat, Dec 13, 2014 at 9:08 PM, Igor Tandetnik wrote: > > On 12/13/2014 2:29 PM, Mujtaba Ali Panjwani wrote: > >> I have created an encrypted database using visual studio plugin of >> system.data.sqlite. Now whichever other database management software than >> VS, I try to

Re: [sqlite] sqlite data source not available

On Tue, Oct 14, 2014 at 11:47 AM, coffeenkfc wrote: > Thanks Joe, > > I removed the line, cleaned the solution, rebuilt, and still don't see > 'System.Data.Sqlite Database File' in the 'Choose Data Source' window. :( > Is there a way to get older versions of the setup bundle?

Re: [sqlite] Unicode support in SQLite

On Tue, Oct 14, 2014 at 4:37 AM, Aleksey Tulinov wrote: > Hello, > > I'm glad to announce that nunicode SQLite extension was updated to support > Unicode-conformant case folding and was improved on performance of every > component provided to SQLite. > > You can read

Re: [sqlite] sqlite data source not available

On Fri, Oct 10, 2014 at 11:55 AM, Ben Lam wrote: > Hi, > > Really appreciate any help, spent a day and a half trying to figure this > out without success. I can't get 'System.Data.SQLite Database File' to show > up as an option I the 'choose data source' window. > > My

Re: [sqlite] Version info in doc pages

http://www.sqlite.org/changes.html 2014-02-03 (3.8.3) •Added support for common table expressions and the WITH clause. -- -- -- --Ô¿Ô-- K e V i N On Sun, Sep 21, 2014 at 8:46 AM, HarryD wrote: > I find it something of a shortcoming that the doc

Re: [sqlite] Does the Connection string support UNC paths?

On Sun, Sep 7, 2014 at 12:46 AM, Chris wrote: > I am old database programmer that just came across SQLite and am working on > a small project for a PVR that uses SQLite as it's db provider. I try > specifying a UNC path to the database for the datasource in the

Re: [sqlite] User-visible doc anchors [WAS: Severe performance degradation]

On Fri, Aug 22, 2014 at 3:13 AM, Dominique Devienne wrote: > On Thu, Aug 21, 2014 at 8:44 PM, Richard Hipp wrote: > > > Additional discussion can be found at: > > > > http://www.sqlite.org/optoverview.html > >

Re: [sqlite] Need help on SQLite In-Memory Mode

On Mon, Aug 11, 2014 at 9:19 PM, Nick Bao wrote: > Thanks, Joe! > > But it did not work for me. > > Still got the error: > System.ArgumentException: Invalid ConnectionString format for parameter > "FullUri" > > > Are you using System.Data.SQLite version > *1.0.81.0 ?*

Re: [sqlite] error "malformed database schema" on view in attached table

On Tue, Jul 1, 2014 at 5:07 AM, Gert Van Assche wrote: > All, > > I get this error message: > > malformed database schema (WrongTargetLang) - view [WrongTargetLang] cannot > reference objects in database main > > when I try to attach a database containing a view. If I delete

Re: [sqlite] Error: database is locked

On Wed, Jun 18, 2014 at 6:17 PM, JohnG <4par...@gmail.com> wrote: > gelmjw@voyager /var/www/sqlite3/finviz $ cd /var/www/sqlite3/finviz/; > sqlite3 -init finviz.init finviz.db > ~SNIP~ > How do I clear this lock condition? > > Maybe try it like this instead: gelmjw@voyager

Re: [sqlite] Bug report: column name includes table alias when CTE is used

On Mon, Apr 21, 2014 at 8:29 AM, Richard Hipp wrote: > On Mon, Apr 21, 2014 at 1:16 AM, Andre wrote: > > > Hi, > > > > Apparently when a CTE is used, the column name includes the table alias. > > However, when no CTE is used, the alias is not present in

Re: [sqlite] Syntax diagram in draft docs for sqlite 3.8.3 confuses me

On Thu, Jan 30, 2014 at 10:58 AM, Richard Hipp wrote: > Documentation on SELECT statements at > http://www.sqlite.org/draft/lang_select.html has now been updated and > amplified. > > > On Thu, Jan 30, 2014 at 5:52 AM, Zsbán Ambrus wrote: > > > Hi! > > > >

Re: [sqlite] "Common Table Expression"

On Fri, Jan 24, 2014 at 10:09 AM, Clemens Ladisch wrote: > Richard Hipp wrote: > > Please see http://www.sqlite.org/draft/lang_with.html for draft > > documentation of the new Common Table Expression implementation for > SQLite > > 3.8.3. Comments, criticism, and

Re: [sqlite] Fw: System.Data.SQLite.dll

On Thu, Jan 16, 2014 at 11:18 PM, Joe Mistachkin wrote: > > RadSolution wrote: > > > > The version info for this file states that it is version 91.0.77.0 dated > 31/01/2012 12:59 > > This is used in several of our legacy systems (without any problems that > I'm aware of). >

Re: [sqlite] Web application with SQLite

On Tue, Dec 31, 2013 at 6:17 PM, Tim Johnson wrote: > * Eduardo [131231 07:11]: > > > > You can check mongoose webserver. It uses LUA for scripting web pages > > (similar to PHP but with LUA) and Sqlite for db access from LUA. > > I found what I believe

Re: [sqlite] minor typo in documentation

http://sqlite.org/faq.html#q1 CURRENTLY: "(If the largest possible integer key, 9223372036854775807, then an unused key value is chosen at random.)" SUGGESTED FIX: " (If the largest possible integer key 9223372036854775807 is in use, then an unused key value is chosen at random.)"

Re: [sqlite] Trouble with Journal_Mode Pragma

On Sat, Nov 16, 2013: > Stephen Chrzanowski wrote: > > I'm not sure why this code is breaking: > > > > procedure SaveDatabaseTo(fName:string); > > var > > TempDB:tsqlitedatabase; > > begin > > TempDB:=TSQLiteDatabase.Create(fName); > > TempDB.ExecSQL('PRAGMA journal_mode = OFF'); > >

Re: [sqlite] MATCH with punctuation in parenthesis causing error

On Mon, Nov 4, 2013 at 1:38 AM, David de Regt wrote: > I've worked around this issue a separate way, but I'd like to understand > what went wrong in the first place here. I have an FTS3 table, and if I > query with the following: > > SELECT * FROM table WHERE keywords MATCH

Re: [sqlite] sqlite3_last_insert_rowid() problem

On Sat, Oct 19, 2013 at 6:05 AM, Igor Korot <ikoro...@gmail.com> wrote: > Hi, Kevin, > > > On Sat, Oct 19, 2013 at 2:59 AM, Kevin Benson <kevin.m.ben...@gmail.com > >wrote: > > > On Sat, Oct 19, 2013 at 5:46 AM, Igor Korot <ikoro...@gmail.com> wrote: >

Re: [sqlite] Query "select date(\"now\")" show EPOCH time on ARM- Coertex A15 board

On Sat, Oct 19, 2013 at 5:32 AM, Drake Wilson wrote: > Quoth jitendar kumar , on 2013-10-19 14:48:46 +0530: > > but the same compiled with ARM - Cortex A15 cross compiler and the query > > executed on arm board it gives the output of EPOCH time. i

Re: [sqlite] sqlite3_last_insert_rowid() problem

On Sat, Oct 19, 2013 at 5:46 AM, Igor Korot wrote: > but on Mac I am getting the warning: > > "Implicit conversion loses integer precision" > > So my question is: how do I build my program on Mac without such warning > and so that it will work properly. >

Re: [sqlite] Hints for the query planner

On Tue, Sep 10, 2013 at 3:26 PM, Richard Hipp wrote: > SURVEY QUESTION: > > The question for today is what to call this magic hint function: > > (1) unlikely(EXPR) > (2) selective(EXPR) > (3) seldom(EXPR) > (4) seldom_true(EXPR) > (5) usually_not_true(EXPR) (6)

Re: [sqlite] SQLite Linq not being loaded

any support for translating Linq statements to valid Sqlite statements > in System.Data.SQLite. For that you seem to use a third party solution. > > -Steve > > > > On 9 September 2013 12:00, Kevin Benson <kevin.m.ben...@gmail.com> wrote: > > > On Sun, Sep 8, 2013

Re: [sqlite] SQLite Linq not being loaded

On Sun, Sep 8, 2013 at 2:36 AM, Steve Palmer wrote: > Hi! > > Has anybody successfully used System.Data.SQLite.Linq in their project and > can perhaps help me with this? > > Even after including this DLL in my project reference, it is apparent that > Linq is calling the wrong

Re: [sqlite] Query preperation time does not scale linearly with growth of no. of tables

On Fri, Sep 6, 2013 at 1:29 PM, Harmen de Jong - CoachR Group B.V. < har...@coachr.com> wrote: > On 6 sep. 2013, at 18:42, "Igor Tandetnik" wrote: > > If I recall correctly, query planner's behavior is worst-case quadratic > in the number of tables participating in the query.

Re: [sqlite] please help me; i need sqlite-netFx35-setup-bundle-x64-2008-1.0.84.0.exe

On Thu, Aug 15, 2013 at 12:00 PM, 木与萱ip/ wrote: > sqlite-netFx35-setup-bundle-x64 > http://system.data.sqlite.org/downloads/1.0.84.0/sqlite-netFx35-setup-bundle-x64-2008-1.0.84.0.exe -- -- -- --Ô¿Ô-- K e V i N

Re: [sqlite] float to string conversion problem

On Fri, Jun 14, 2013 at 6:34 PM, Filipe Madureira < filipe.madure...@sysdevsolutions.com> wrote: > Hi, > > Thanks for the great help. > I tracked the problem to et_getdigit() > More precisely to: > digit = (int)*val; > > So, SQLite is assuming that "double" to "int" cast will truncate the >

Re: [sqlite] Header Application-ID list

> > On Thu, Jun 6, 2013 at 8:15 AM, Richard Hipp wrote: > > Ideally, this content would be picked up by unix "file" command and be > distributed to all unix systems. However, my repeated emails to the > maintainer Christos Zoulas about this have gone unanswered. > > Sounds like

Re: [sqlite] sqlite-users Digest, Vol 66, Issue 3

On Mon, Jun 3, 2013 at 9:39 PM, YAN HONG YE wrote: > if i use : > sqlite3 D:\yeyh\sqlite\mmaa.db " select > datetime(CURRENT_TIMESTAMP,'localtime');" >mdate.html > in dos command, it could be get the result file: mdate.html > > but when I use c++ to run the createprocess

Re: [sqlite] Correct way to open multiple in memory databases

On Tue, May 28, 2013 at 8:31 AM, Kevin Benson <kevin.m.ben...@gmail.com>wrote: > On Tue, May 28, 2013 at 7:57 AM, Roland Hughes < > rhug...@cincinnati-test.com> wrote: > >> ":memory:" is a one-shot wonder. The example from the documentation >> allowed m

Re: [sqlite] Correct way to open multiple in memory databases

On Tue, May 28, 2013 at 7:57 AM, Roland Hughes wrote: > ":memory:" is a one-shot wonder. The example from the documentation > allowed multiple threads to use the _same_ in memory database. > Am I not understanding the explanation on that page correctly? My

Re: [sqlite] Query optimizer bug?

> > On Tue, 30 Apr 2013 12:59:17 -0400 > Richard Hipp wrote: > > > http://www.sqlite.org/draft/queryplanner-ng.html > > Just a "heads-up" that the paragraph has a couple of accidental transpositions: *IS* "TCP-H Q8" is a test query from the Transaction Processing Performance

Re: [sqlite] [SQLite.Net] Right way to install precompiled binaries?

http://sqlite.1065341.n5.nabble.com/Newbie-issues-with-SQLite-amp-C-td65823.html -- -- -- --Ô¿Ô-- K e V i N On Thu, Apr 18, 2013 at 9:22 AM, Gilles Ganault wrote: > Hello, > > I'm having a problem getting VB Express to find SQLite .Net: > > 1.

Re: [sqlite] SQL Logic error or missing database

On Fri, Apr 5, 2013 at 10:08 AM, Rob Collie wrote: > Yeap, I'm on Visual Studio 2012. I've created a console app: > > > sqlite3 *oDatabase; > int returnValue; > returnValue = sqlite3_open_v2("file://C:/Newfolder/testing.db", > & oDatabase, SQLITE_OPEN_CREATE, NULL); >

Re: [sqlite] SQLite 3.7.16 beta

On Mon, Mar 11, 2013 at 11:48 AM, Richard Hipp wrote: > > > On Sat, Mar 2, 2013 at 11:29 AM, Richard Hipp wrote: > > > > Please report any problems encountered. > > > > -- > > D. Richard Hipp > > d...@sqlite.org Some lunchtime reading resulted in this

Re: [sqlite] Report Bugs Against SQLite

https://groups.google.com/forum/?fromgroups#!topic/csharp-sqlite/HQO0OwDm0kk http://code.google.com/p/csharp-sqlite/issues/detail?id=151 -- -- -- --Ô¿Ô-- K e V i N On Thu, Mar 7, 2013 at 9:32 AM, 源子陌 wrote: > Hello! I'm Chinese,please forgive my

Re: [sqlite] Bullzip ms Access to MySql

On Wed, Mar 6, 2013 at 4:36 PM, wrote: > > Hi, > > > *SNIP > one more thing, is there a way to search through the archived forums? > > Vance > Here's one way: http://www.mail-archive.com/search?a=1=sqlite-users@sqlite.org=1d==datenewest=Search -- -- --

Re: [sqlite] Informal question

On Sat, Mar 2, 2013 at 11:37 AM, Simon Slavin wrote: > Although there are many hobbyist programmers here, many of us are clearly > using SQLite for our serious day jobs, and not just for playing with. So > why is this list busy over the weekends rather than during the

Re: [sqlite] "SQLite" Pronunciation

http://www.youtube.com/watch?v=jN_YdMdjVpU -- -- -- --Ô¿Ô-- K e V i N On Wed, Feb 27, 2013 at 6:28 PM, wrote: > OK, how does one pronounce "SQLite"? "see-kwel-lite"? "ess-kyoo-lite"? > "ess-kyoo-ell-lite"? "see-kwel-ite"? "ess-kyoo-ell-ite"? Or...?

Re: [sqlite] [SQLite.ADO.Net] Upgrading XP to SQLite version?

On Tue, Feb 26, 2013 at 5:37 PM, Gilles Ganault <gilles.gana...@free.fr>wrote: > On Tue, 26 Feb 2013 13:09:10 -0500, Kevin Benson > < kevin.m.ben...@gmail.com> wrote: > > Because there are actually a number of different ways the (CLR)untime > > locates assemb

Re: [sqlite] [SQLite.ADO.Net] Upgrading XP to SQLite version?

On Tue, Feb 26, 2013 at 11:34 AM, Gilles Ganault wrote: > Next, just to check, I reinstalled a fresh Windows7 + VS Express 201 > to try the "Precompiled binaries no bundle" this time. > > Even with the VC++ 2012 runtime, it still complained about > "SQLite.Interop.dll :

Re: [sqlite] [SQLite.ADO.Net] Upgrading XP to SQLite version?

On Tue, Feb 26, 2013 at 3:43 AM, Gilles Ganault wrote: > I'll uninstall the one from Phoenix Software Solutions, but I'm > puzzled at which package to install from here: > > http://system.data.sqlite.org/index.html/doc/trunk/www/downloads.wiki >

Re: [sqlite] Unable to use table alias inside parenthesis on right side of join

I wonder if this earlier mention is related? http://osdir.com/ml/sqlite-users/2012-07/msg00054.html -- -- -- --Ô¿Ô-- K e V i N On Thu, Jan 31, 2013 at 12:04 PM, Ryan Johnson wrote: > Hi all, > > Strange one here... consider the following

Re: [sqlite] FTS problem with 'NOT term' queries

The explanation right above that table of examples contains these important (I believe) phrases: ...BINARY SET operators... ...TWO operands to an operator... (emphasis mine) On Tue, Jan 29, 2013 at 11:30 PM, Alexey Pechnikov wrote: > SELECT * FROM docs WHERE docs MATCH

Re: [sqlite] parameters in a view, disallowed? (docs issue)

On Fri, Dec 21, 2012 at 12:53 AM, Larry Brasfield wrote: > On 12/20/2012 4:10 PM, Larry Brasfield wrote: >> > Igor Tandetnik wrote: >> [regarding where parameters allowed, "where literals are"] >> >> > >> >> > How did you discern this? >> >> >> >> I know from

Re: [sqlite] Simple SQLite-based spreadsheet?

On Fri, Dec 7, 2012 at 7:04 AM, Gilles Ganault wrote: > Hello > > I need to enter a bunch of items into a table that I can later read > from a web app. > > I was wondering if someone had come up with a Windows application that > would... > - use Sqliteto host the data

Re: [sqlite] SQLite converts all unicode characters into ANSI

On Sun, Nov 18, 2012 at 8:57 PM, ZikO wrote: > Hello, > thanks for your answers. > > I downloaded both precompiled binaries and shell for windows from > www.sqlite.org. > > The script looks like this: > CREATE TABLE IF NOT EXISTS imiona ( > id INTEGER PRIMARY KEY, >

Re: [sqlite] Seemingly random Access violation errors

On Thu, Oct 11, 2012 at 6:07 AM, Joe Mistachkin wrote: > > Matthew Dumbleton wrote: > > > > I have managed to get hold of a HTC HD2 device to do testing on and have > > unfortunately found the error still occurs using the small test > application > > I sent you a while

Re: [sqlite] Seemingly random Access violation errors (resent)

On Mon, Oct 8, 2012 at 12:32 PM, Matthew Dumbleton wrote: > > Thanks Kevin. > I will see if I can find some sort of registry hack or something to > disable this and see if it makes any difference. > Actually, you might investigate how to access the RTLog Manager to examine

Re: [sqlite] Seemingly random Access violation errors (resent)

On Mon, Oct 8, 2012 at 11:57 AM, Matthew Dumbleton wrote: > Joe, > > > It's worked on every device that I've used in the past. > > I hope you see the funny side when I say, this doesn't fill me with a > great amount of confidence as according to your previous messages you

Re: [sqlite] Seemingly random Access violation errors (resent)

On Mon, Oct 8, 2012 at 10:54 AM, Matthew Dumbleton wrote: > So does this mean therefore SQLite will not currently work on a compact > framework device? (Or at least not on mine.) > There's nothing else installed or running apart from the test app I sent > you using SQLite and

Re: [sqlite] export html error

On Fri, Sep 21, 2012 at 4:30 AM, YAN HONG YE wrote: > C:\t9>sqlite3 -html -header t9_engine.db "select id,partnumber,'img > src= > t'||pic||'height=120px',pcs from engine where id>7 " >> n.html > C:\t9>sqlite3 -html -header t9_engine.db "select id,partnumber,'img

Re: [sqlite] 1.0.76 Version

On Sat, Sep 15, 2012 at 2:32 PM, wrote: > Hi, > > Please i need sqlite-netFx40-setup-bundle-**x64-2010-1.0.76.0.exe. Does > anyone have it in his archive? > > Regards, > > Tope. The SQLite downloads wiki is conveniently set up with file URLs that allow for

Re: [sqlite] about sqlite3_create_function

Thgat should have been "...the file func.c." -- -- -- --Ô¿Ô-- K e V i N On Thu, Aug 30, 2012 at 11:10 PM, Kevin Benson <kevin.m.ben...@gmail.com>wrote: > the file*func.c*." > ___ sqlite-user

Re: [sqlite] about sqlite3_create_function

On Thu, Aug 30, 2012 at 10:25 PM, YAN HONG YE wrote: > who give me a sample about function sqlite3_create_function,I can't search > by google. > thank you! > sqlite3_create_function(db, "hello_newman", 0, SQLITE_UTF8, 0, > hello_newman, 0, 0); >

Re: [sqlite] Import at first unhappy - then happy after all

On Sun, Aug 26, 2012 at 11:30 AM, Udi Karni wrote: > The following scenario happens occasionally. > > At first the import fails on mismatched columns - as if the "end-of-line" > marker is off. > > You run it again right away and everything completes successfully. > >

Re: [sqlite] Import at first unhappy - then happy after all

On Sun, Aug 26, 2012 at 11:30 AM, Udi Karni wrote: ***SNIP*** > > As an aside - not a big deal - this is on Windows - the file specifications > in the ".import" and ".read" commands require 2 back slashes in the syntax > - can that be fixed? > > Thanks ! > > The explanation

Re: [sqlite] SQLite support on windows

On Sun, Aug 26, 2012 at 9:23 AM, Arbol One wrote: > [Quote] > *There are a number of devices that run Windows CE > > That is the vortex in this issue. > > The app is being developed on Win7. Using C++ and Gtkmm as the GUI toolkit, > the libraries used

Re: [sqlite] How to connect to an in-memory, shared cache db via SQLiteConnection

On Fri, Aug 17, 2012 at 8:51 PM, Wayne Bradney wrote: > > > > I'm using System.Data.SQLite version 1.0.81.0, and I'm trying the > following connection string: FullUri='file::memory:?cache=shared; when I > Open() the SQLiteConnection, I get: Invalid ConnectionString format

Re: [sqlite] SQLite Shell Bug, Ignores Separators in Quotes Sometimes When Importing Data

On Mon, Jul 23, 2012 at 12:05 PM, Richard Hipp wrote: > On Mon, Jul 23, 2012 at 8:37 AM, Hayes, Michael - IS < > michael.ha...@exelisinc.com> wrote: > > > > > The documentation says that the separator will be honored even inside of > > quotes. ("The SQLite shell will always

Re: [sqlite] Error indicated through SQLITE_CONFIG_LOG callback but sqlite3_step() does not fail

On Fri, Jun 29, 2012 at 3:26 PM, Jeff Archer wrote: > I have been puzzling on this for a couple of days now and am at a loss. I > hate to let something like this go because it appears so much like an > error, I feel like it will just bite me at a later time. > > Any

Re: [sqlite] order by clause should come after union not before

On Fri, Jun 15, 2012 at 5:56 AM, YAN HONG YE wrote: > > select * from hbc order by cmc desc limit 10 > union > select * from hbc where qph>0 > union > select * from hbc where hctl=1 > > this sql cmd cause the error: > order by clause should come after union not before >

Re: [sqlite] FTS Example Fails (matchinfo arguments)

On Thu, Jun 14, 2012 at 4:27 PM, Kees Nuyt wrote: > On Thu, 14 Jun 2012 13:13:58 -0700, Sergei G > wrote: > > >Is there a way I can obtain documentation that matches my version? > >Online documentation is for the most current version. > >I have found

Re: [sqlite] Specifying a nullable column

On Mon, Jun 11, 2012 at 10:35 AM, Paul Medynski wrote: > Hi folks, > > I notice that the syntax diagram for 'create table' shows the > 'column-constraint' definition as requiring 'null' to always be preceded by > 'not'. I don't see any definition that supports just 'null'.

Re: [sqlite] Question about the SQLITE_API

On Thu, Jun 7, 2012 at 11:05 PM, 天牙 wrote: > First, thanks for adding me to this mailing list. Here I want to ask a > question about the SQLITE_API. When i was running the ios programe use the > sqlite3 database , it said that " unknown type ‘SQLITE_API’". Thank you for >

Re: [sqlite] SQLite3.dll for OS x64

On Wed, Jun 6, 2012 at 8:33 AM, NOCaut wrote: > In the offical site i have not found dll for x64 OS. Where can I download > it? > > -- > Maybe try downloading the .ZIP archive for the appropriate .NET Framework (with "-static-binary-bundle-x64-" as part of its archive name -

Re: [sqlite] how to?

On Tue, Jun 5, 2012 at 12:43 PM, Jonas Malaco Filho < jonasmalacofi...@gmail.com> wrote: > I think that session info is stored in sessionrestore.js, in your Firefox > profile data folder. There is also a sessionrestore.bak, that may help you. > You can check if you have other (older) versions of

Re: [sqlite] Cascade deletes in .Net FW 4 + EF

On Tue, May 29, 2012 at 9:26 AM, Peter Litsegård wrote: > Hi! > > I have a very simple database hsoted by SQLite v1.0.80.0. I'm struggling > to get cascade deletes to work using EF. I have set the OnDelete to > 'Cascade' on the "one end" but it fails to execute. Is this a

Re: [sqlite] What does "The use of the amalgamation is recommended for all applications." mean, precisely?

On Fri, May 25, 2012 at 8:08 PM, Jonas Malaco Filho < jonasmalacofi...@gmail.com> wrote: > Just curious, what dev language are you using? > I ~believe~ he's using LiveCode: http://www.runrev.com/products/livecode/livecode-platform-overview/ -- -- -- --Ô¿Ô-- K e V i N

Re: [sqlite] sqlite-users Digest, Vol 53, Issue 9

On Wed, May 9, 2012 at 9:28 PM, YAN HONG YE wrote: > On Wed, 9 May 2012 02:24:58 +0100 > Simon Slavin wrote: > > > alter table myref add stkcode varchar(30); > > update myref set stkcode = dzhhq.stkcode; > > > > this sql command couldn't run in my

  1   2   >