[sqlite] calculate difference of two times and show the result as double value

Dear SQLite users, I've created a Microsoft Access 2003 database with three complex queries written in pure SQL language. The function of the database is to document and calculate the daily work-time. Today I want to convert this database to SQLite but I have problems with my written queries:

[sqlite] How to use customize Rules & specific locale simultaneously for Sorting using ICU

Hi , For sorting , ICU use locale base sorting. Locale can be given using ucol_open(const char* loc,UErrorCode* status) function/API like : collator = ucol_open(en_US, ) Now i want to customize collation rule also like : const static char* rule = "& f < a " ; Now, for this customize rule ,

Re: [sqlite] ActiveX documentation

Steve, You might try installing this ODBC driver that allows you to query a Sqlite db just like Access, Excel, etc with Adodb. You can use VB6, VBA, vbscript. http://www.ch-werner.de/sqliteodbc/ The connection string is like this: objConn.Open "DRIVER=SQLite3 ODBC

Re: [sqlite] R: R: Crypto lib for Sqlite - suggest required

On 9 Jan 2011, at 5:29pm, Roger Binns wrote: > I think you misunderstand how the SQLite encryption extension works. The on > disk storage format for SQLite is a series of fixed sized pages. The > extension transparently encrypts each page on writing to disk and decrypts > on reading. To use

Re: [sqlite] More descriptive error

On Sun, Jan 9, 2011 at 7:21 PM, BareFeetWare wrote: > On 9 Jan 2011, at 2:48pm, BareFeetWare wrote: > > >> When I run this via C, using sqlite3_errmsg(), I get the error message: > >> > >> constraint failed > >> > >> but when I run it via the sqlite3 command line I get

Re: [sqlite] fill blank fields

CDN Mark wrote: > what I need to do is replace blank fields in a specific row, sort of > a double where where statement as in: > > UPDATE Aircraft SET CN = '*' where CN = '' or CN is null where (primary key) > is xyz UPDATE Aircraft SET CN = '*' where (CN = '' or CN is

Re: [sqlite] fill blank fields

>thanks Simon and Igor for your help on this a few weeks ago, but I >need an >addition to > >UPDATE Aircraft SET CN = '*' where CN = '' or CN is null; > >what I need to do is replace blank fields in a specific row, sort of >a double where where statement as in: > >UPDATE Aircraft SET CN = '*'

Re: [sqlite] R: R: Crypto lib for Sqlite - suggest required

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 01/09/2011 02:20 AM, Marco Turco wrote: > My app is an accounting system. > This accounting system must support the exchange of db between users that > work with the this application > so I think the only way is to use the same key for all users.

[sqlite] fill blank fields

hi there, thanks Simon and Igor for your help on this a few weeks ago, but I need an addition to UPDATE Aircraft SET CN = '*' where CN = '' or CN is null; what I need to do is replace blank fields in a specific row, sort of a double where where statement as in: UPDATE Aircraft SET CN = '*'

Re: [sqlite] A kind help-request.

Hi Simon, Olaf , Garry, Great news to you all,now i can able to insert 65k docs in second, only i had done as per Simon and Garry suggestion 1. i freed the array as per suggestion 2. remove 'cmd.Parameters.Add(myparam) as per Garry suggestion. *here are summary code :inserting 65k in 4-5 sec* *

Re: [sqlite] More descriptive error

On 9 Jan 2011, at 2:48pm, BareFeetWare wrote: >> When I run this via C, using sqlite3_errmsg(), I get the error message: >> >> constraint failed >> >> but when I run it via the sqlite3 command line I get a more descriptive: >> >> SQL error: columns First, Last are not unique >> >> How can I

[sqlite] More descriptive error

Hi all, I am trying to get as much detail on SQL errors generated by SQLite as possible. Here's a test: begin immediate; create table "Names" (First, Last, unique(First, Last)); insert into "Names" values ('Mickey', 'Mouse'); insert into "Names" values ('Mickey', 'Mouse'); rollback; When I run

Re: [sqlite] Disabling foreign key cascading during re-insertion of existing data

On 01/07/2011 09:19 PM, BareFeetWare wrote: >> pragma foreign_keys = no; On 08/01/2011, at 1:26 AM, Dan Kennedy wrote: > The command above should have disabled all foreign-key constraint checks > (including cascades etc.). Check it for typos perhaps. I thought it would too, but when my

Re: [sqlite] Embarassed Newbie

james630...@aol.com wrote, On 08/01/11 13:45: > Hi Peter, > > Thanks for your response. > > At the DOS command prompt I manually changed directory as suggested but to > no avail. > > I originally downloaded all 3 downloads as instructed by the download page. > Whilst I was able to unzip the

[sqlite] Hui assauts oïl kv

Jet ah, ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Read-only main database and ATTACH

On 9 Jan 2011, at 5:07am, Bill Zissimopoulos wrote: > I am wondering then whether there are any particular gotchas related to > attaching read-only and read-write databases that I should be aware of. I am > looking at one of the following ATTACH scenarios: > 1. Open the read-only

[sqlite] Read-only main database and ATTACH

Hello, list: I am looking to understand the implications of using ATTACH with databases with different read-write permissions. I have a scenario where I need to access a large database (approx. 512MB) that resides in a read-only filesystem. There is also a small read-write database with the

Re: [sqlite] Embarassed Newbie

Hi Peter, Thanks for your response. At the DOS command prompt I manually changed directory as suggested but to no avail. I originally downloaded all 3 downloads as instructed by the download page. Whilst I was able to unzip the first two folders my attempts to unzip the last results in

[sqlite] R: R: Crypto lib for Sqlite - suggest required

Hi, thank you for your suggests. My app is an accounting system. This accounting system must support the exchange of db between users that work with the this application so I think the only way is to use the same key for all users. This generate a lack of security of course but anyway my