Re: [sqlite] Writing SQL with special characters

You can use the hex code of the non-printable character: update tableA set field1 = "line1 x'0a' line2" -Toby >Are there any docs for how to write SQL for special characters like >return and linefeed? > >On some systems (eg. http://www.wilsonmar.com/1eschars.htm) return is >\n so an SQL might

Re: [sqlite] Formatting to "Sentence case"?

Perhaps by doing an UPDATE with: set booktitle = upper(substr(booktitle,1,1)) || lower(substr(booktitle,2)) Regards, -Toby >Hello > >A column holds book titles which are all in capital letters ("MY BOOK >TITLE"), and I'd like to reformat them as "My book title". > >Is there a function in

Re: [sqlite] How to get the specific row?

-- get the Nth record from the top: select * from tblname order by id asc limit N-1,1 -- get the Nth record from the bottom: select * from tblname order by id desc limit N-1,1 Regards, -Toby >Hi all >I create a table like this: >sqlite3_exec(db, "CREATE TABLE TBLNAME (ID >INTEGER PRIMARY KEY ,

Re: [sqlite] from access to sqlite

>I want express gratitude to Olaf Schmidt, that he is a great professional >and available with everybody specially with ignorant people such me! Olaf is, in a word, a genius! >Set ds = m_db.Execute("SELECT * FROM tabella WHERE data_ora BETWEEN " & >ieri_inizio & " and " & ieri_fine & "