Re: [sqlite] New wrapper library: QUINCE

2014-09-02 Thread Michael Shepanski
Hello, I've just found the page http://www.sqlite.org/cvstrac/wiki?p=SqliteWrappers , which says If you know of a driver or wrapper for SQLite that is not listed below, please feel free to add it to the list. I would like to add an entry for quince, but I need to log in. Log in to what?

Re: [sqlite] Integrity check

2014-09-02 Thread Jan Slodicka
Thanks, Simon. Simon Slavin-3 wrote If possible, you should try to do your synchronisation when your app is frontmost only. However, I understand that this may not be appropriate for your app. Exactly, under normal circumstances the synchronization of our app is the topmost priority, hence

Re: [sqlite] HELP sqlite3 used in vxworks has some problem

2014-09-02 Thread 王庆刚
firstly : Even if I used #if OS_VXWORKS || osAccess(zPath,0) != 0 #endif or I used #if OS_VXWORKS }else if(errno == 0x380003 || errno == 13 ) rc = SQLITE_IOERR_DELETE_NOENT: #endif Without the SQLITE_ENABLE_LOCKING_STYLE compile option, I tried the above two

Re: [sqlite] Integrity check

2014-09-02 Thread Simon Slavin
On 2 Sep 2014, at 9:50am, Jan Slodicka j...@resco.net wrote: Simon Slavin-3 wrote If possible, you should try to do your synchronisation when your app is frontmost only. However, I understand that this may not be appropriate for your app. Exactly, under normal circumstances the

Re: [sqlite] HELP sqlite3 used in vxworks has some problem

2014-09-02 Thread Andy Ling
-Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users- boun...@sqlite.org] On Behalf Of ??? Sent: 02 September 2014 13:41 To: General Discussion of SQLite Database Subject: Re: [sqlite] HELP sqlite3 used in vxworks has some problem firstly : Even if I

Re: [sqlite] HELP sqlite3 used in vxworks has some problem

2014-09-02 Thread 王庆刚
Thank Andy Ling. best wishes. regards Wang Qinggang. At 2014-09-02 09:45:47, Andy Ling andy.l...@quantel.com wrote: -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users- boun...@sqlite.org] On Behalf Of ??? Sent: 02 September 2014 13:41 To:

Re: [sqlite] Cannot retrieve SQLite Db Data Immediately After Application Startup

2014-09-02 Thread Roger Binns
On 29/08/14 12:55, Bob Moran wrote: The return code (rc) is SQLITE_OK, but stmnt is NULL (0) if I start the application and wait for at least 1 minute, everything works. You get NULL back from prepare with SQLITE_OK if the statement doesn't do anything. Examples are empty strings or

[sqlite] Selecting dates...

2014-09-02 Thread jose isaias cabrera
Greetings! I know that SQLite dates are of the form -MM-DD and I like that. :-) I want to find out why these are working. create table t (a date, val integer); insert into t values ('2010-01-01', 10); insert into t values ('2010-1-1', 10); insert into t values ('2010-1-01', 10); insert

Re: [sqlite] Selecting dates...

2014-09-02 Thread Petite Abeille
On Sep 2, 2014, at 9:48 PM, jose isaias cabrera jic...@cinops.xerox.com wrote: Thoughts? Thanks. SQLite doesn’t have date per se. You are free to store dates as either text or number, or anything you please. But it’s your responsibility to keep it straight.

Re: [sqlite] Selecting dates...

2014-09-02 Thread Richard Hipp
On Tue, Sep 2, 2014 at 3:48 PM, jose isaias cabrera jic...@cinops.xerox.com wrote: Greetings! I know that SQLite dates are of the form -MM-DD and I like that. :-) I want to find out why these are working. SQLite does not have a special date type. SQLite stores dates as either

Re: [sqlite] Selecting dates...

2014-09-02 Thread jose isaias cabrera
Richard Hipp wrote... On Tue, Sep 2, 2014 at 3:48 PM, jose isaias cabrera jic...@cinops.xerox.com wrote: Greetings! I know that SQLite dates are of the form -MM-DD and I like that. :-) I want to find out why these are working. SQLite does not have a special date type. SQLite

Re: [sqlite] Selecting dates...

2014-09-02 Thread jose isaias cabrera
Petite Abeille wrote... On Sep 2, 2014, at 9:48 PM, jose isaias cabrera jic...@cinops.xerox.com wrote: Thoughts? Thanks. SQLite doesn’t have date per se. You are free to store dates as either text or number, or anything you please. But it’s your responsibility to keep it straight.

Re: [sqlite] Cannot retrieve SQLite Db Data Immediately After Application Startup

2014-09-02 Thread Bob Moran
Found more of what the issue is. I noticed that my SQL text was being overwritten on the return from the call to prepare_v2. Stepping through the SQlite3 code I discovered that a malloc call for 500+ bytes was returning a pointer 8 bytes below my SQL string. Don't have the foggiest notion as to

Re: [sqlite] Cannot retrieve SQLite Db Data Immediately After Application Startup

2014-09-02 Thread Simon Slavin
On 3 Sep 2014, at 5:24am, Bob Moran bmo...@cicaccess.com wrote: Found more of what the issue is. I noticed that my SQL text was being overwritten on the return from the call to prepare_v2. Stepping through the SQlite3 code I discovered that a malloc call for 500+ bytes was returning a