Re: [sqlite] [sqlite-dev] Error 25: column index out of range when binding for a DATETIME

On Thu, Oct 31, 2019 at 9:52 AM Keith Medcalf wrote: > On Thursday, 31 October, 2019 07:17, Jeffrey Walton > wrote: > ... > >/* negative for days in the past */ > >int days = 120; > >days = -days; > > >const char DELETE_STMT[] = "DELETE f

[sqlite] Clear sqlite3 terminal enhancement

Hi, When working in the Linux terminal we can clear the scrollback with the 'clear' command; and we can delete all history and scrollback with the 'reset' command. I am not able to do the same within the sqlite3 terminal. I'd like to request a '.clear' command and a '.reset' command to do the sam

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 >> and it k

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

[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?)

s-boun...@sqlite.org > [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Jeffrey Walton > Sent: 21 January 2014 17:54 > To: sqlite-users@sqlite.org > Subject: [sqlite] Differentiate between CREATE TABLE failures (Exists vs > Other Failures?) > > My startup routine at

[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] Question on VACCUUM, WAL, and Encryption Codecs

Hi All, Can anyone verify that VACCUUM and WAL uses encryption codecs if available? I think I found answers for other components such as rollback journals, but I'm not clear on the two items above. Jeff ___ sqlite-users mailing list sqlite-users@sqlite

Re: [sqlite] Building SQLIte Commands or Sanitzing User Input

Thanks for the quick response Simon. Happy holidays. On Fri, Dec 31, 2010 at 8:25 PM, Simon Slavin wrote: > > On 1 Jan 2011, at 12:35am, Jeffrey Walton wrote: > >> I'm using SQLite on embedded devices (iPhone and, SmartPhone, and >> PocketPC). Ichecked OWASP, and th

[sqlite] Building SQLIte Commands or Sanitzing User Input

Hi All, I'm using SQLite on embedded devices (iPhone and, SmartPhone, and PocketPC). Ichecked OWASP, and they don't have anything for SQLite or C/C++. http://www.owasp.org/index.php/SQL_Injection_Prevention_Cheat_Sheet. Does the SQLite API offer the ability to create a 'command object'. Or a call