Re: [sqlite] Clang 3.3 and Scan-Build results

Hello, To have more windows beta-testers, would it be possible ton include during beta phase : - a downloadable sqlite3.8.3beta.exe ? - a downloadable sqlite3.8.3beta.dll ? Other alternative nice to have feature on the download page would be : - a md5 signature and a sha-256 signature , - a

Re: [sqlite] latest sqlite 3 with Delphi 5 professional

On 23/01/2014 02:52, Bogdan Ureche wrote: you may want to take a look at UTF-8VCL. Again that's very useful information and thank you for the link. ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] latest sqlite 3 with Delphi 5 professional

If you want to support UTF-8 in Delphi 5 then you may want to take a look at UTF-8VCL. I have been using with Delphi 2007 with no major issues. http://sourceforge.net/projects/utf8vcl/ Bogdan Ureche On Wed, Jan 22, 2014 at 5:11 PM, dean gwilliam wrote: > On

Re: [sqlite] Clang 3.3 and Scan-Build results

On Wed, Jan 22, 2014 at 4:48 PM, Jeffrey Walton wrote: > > Please let me know if you would like some independent testing. I'd be > happy to oblige. > Please go to http://www.sqlite.org/download.html and download the latest snapshot. Compile it into any and every application

Re: [sqlite] latest sqlite 3 with Delphi 5 professional

On 22/01/2014 22:56, RSmith wrote: Hope some of this helps! Yes that's extremely helpful information Ryan. Thanks very much indeed. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] latest sqlite 3 with Delphi 5 professional

On 2014/01/22 23:33, dean gwilliam wrote: I'm just wondering what my options are here? Any advice much appreciated. Firstly, high-five on using D5 - All the High-speed Pascal/C /Assembler coding goodness with none of the fat (as far as 32-bit goes anyway) - I use it all the time for

Re: [sqlite] Clang 3.3 and Scan-Build results

On Wed, Jan 22, 2014 at 4:31 PM, Richard Hipp wrote: > > On Wed, Jan 22, 2014 at 3:46 PM, Jeffrey Walton wrote: >> >> Here are some results from Clang 3.3 and its scan-build engine on >> sqlite-amalgamation32k-201401171527.zip. Its a pretty good analyzer >>

[sqlite] latest sqlite 3 with Delphi 5 professional

I'm just wondering what my options are here? Any advice much appreciated. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Clang 3.3 and Scan-Build results

On Wed, Jan 22, 2014 at 3:46 PM, Jeffrey Walton wrote: > Here are some results from Clang 3.3 and its scan-build engine on > sqlite-amalgamation32k-201401171527.zip. Its a pretty good analyzer > and it keeps getting better. > Thank you for sending us all the Clang warnings.

[sqlite] Clang 3.3 and Scan-Build results

Here are some results from Clang 3.3 and its scan-build engine on sqlite-amalgamation32k-201401171527.zip. Its a pretty good analyzer and it keeps getting better. The analyzer will perform interprocedural analysis, but only if the procedures reside within the same translation units. So it will

[sqlite] Potential memory issue in sqlite3.c under Clang 3.3 and memory sanitzier

I'm running my program under Clang 3.3 and its address sanitzers (-fsanitze=address). I noticed there's a persistent memory issue flagged in sqlite3.c: sqlite3.c:60249:22: runtime error: member access within null pointer of type 'Mem' (aka 'struct Mem') 60249 is shown below, and the

Re: [sqlite] Differentiate between CREATE TABLE failures (Exists vs Other Failures?)

On Wed, Jan 22, 2014 at 8:19 AM, Dave Wellman wrote: > Hi, > Why not use the "create table if not exists" syntax, that way any error must > be classed as 'other'. > Cheers, Thanks Dave. I'll try it. Jeff > -Original Message- > From:

Re: [sqlite] Command line shell not flushing stderr when interactive

Microsoft seems to only make the stderr stream unbuffered when writing to a character device: "The stdout and stderr functions are flushed whenever they are full or, if you are writing to a character device, after each library call."  It doesn't seem to consider pipe that emacs is reading from

Re: [sqlite] Simple data conversion in SQLite - please help

On Jan 22, 2014, at 8:21 AM, Richard Hipp wrote: > I seem to recall seeing some SMS databases off of an iPhone that used unix > timestamps for the date/time. That would be seconds since 1970. You can > use the 'unixepoch' modifier on the date functions within SQLite to do >

[sqlite] System.Data.SQLite - System.MissingMethodException was unhandled

I have been working with SQLite on a WIndows CE project using System.Data.Sqlite (1.0.87) for about 8 months now. It has worked very well until recently. Early this week, I returned to the project to make some changes to the GUI, totally unrelated to the database and began receiving

Re: [sqlite] Simple data conversion in SQLite - please help

On Wed, Jan 22, 2014 at 10:46 AM, Kees Nuyt wrote: > On Wed, 22 Jan 2014 12:42:27 -, "DJ Small Paul" < > i...@djsmallpaul.co.uk> wrote: > > >Hi everyone, > > > > > > > >I hope this is an easy one for you! > > > > > > > >I've got an SQLite 3 database from an iphone app. I've

Re: [sqlite] Simple data conversion in SQLite - please help

On Wed, 22 Jan 2014 12:42:27 -, "DJ Small Paul" wrote: >Hi everyone, > > > >I hope this is an easy one for you! > > > >I've got an SQLite 3 database from an iphone app. I've pulled a table out >and the "date" column is in double binary - How do I see it as the

Re: [sqlite] Differentiate between CREATE TABLE failures (Exists vs Other Failures?)

Hi, Why not use the "create table if not exists" syntax, that way any error must be classed as 'other'. Cheers, Dave Ward Analytics Ltd - information in motion Tel: +44 (0) 118 9740191 Fax: +44 (0) 118 9740192 www: http://www.ward-analytics.com Registered office address: The Oriel, Sydenham

[sqlite] Differentiate between CREATE TABLE failures (Exists vs Other Failures?)

My startup routine attempts to create all needed tables in my database. For example: sqlite3_extended_result_codes(db, 1); ... int rc; char* err = NULL; const char* stmt = "CREATE TABLE users ( " " userid INTEGER PRIMARY KEY AUTOINCREMENT, " " username TEXT, usergroup TEXT,

[sqlite] Simple data conversion in SQLite - please help

Hi everyone, I hope this is an easy one for you! I've got an SQLite 3 database from an iphone app. I've pulled a table out and the "date" column is in double binary - How do I see it as the actual "date"?? Thank in advance for your help, Paul

[sqlite] [ANNOUNCEMENT] Updated: sqlite3-3.8.3-1 (beta, as test package) for Cygwin/Cygwin64

SQLite is a software library that implements a self-contained, serverless, zero-configuration, transactional SQL database engine Changes since 3.8.2-3 = * Updated to upstream 3.8.3 beta release. Main feature: Added support for CTE (Common Table Expressions) and