Re: [sqlite] Re: SQLite and nested transactions

2007-04-12 Thread Ramon Ribó
cribió: Ramon Ribó wrote: Imagine one application that can import data from a file. You want that, in case of computer crash, either all the data of the file is imported or none. At the same time, you want the user to manually accept or reject every section of the file. This examp

Re: [sqlite] what extension do you recommend

2007-10-24 Thread Ramon Ribó
You should consider the extension for, at least, three situations: - Anti virus can check files differently depending on the extension - Backup programs can also react on this - Windows takes it into account when indexing files Compass Ing. y Sistemas Dr. Ramon Ribo

[sqlite] New conflict clause: update

2006-08-31 Thread Ramon Ribó
Hello, I was thinking on a new option that could be useful for sqlite. A new conflict clause called "update" so that the following SQL command: insert or update into table1 (a,b) values (1,2) was equivalent to update table1 set a=1,b=2 where ?unique-key-constraint? when a

[sqlite] aggregate funtion in the TCL binding

2005-08-24 Thread Ramon Ribó
advantage of the new features of sqlite version 3 with the integers and doubles, as it convert everything to one string. Are there any plans to change it? Regards, Compass Ing. y Sistemas Dr. Ramon Ribó http://www.compassis.com <http://www.compassis.com/> [EMAIL PROTECTED]

[sqlite] aggregate funtion in the TCL binding

2005-08-25 Thread Ramon Ribó
t(, sqlite3_value_text(argv[i])); } } rc = Tcl_Eval(p->interp, Tcl_DStringValue()); if( rc ){ sqlite3_result_error(context, Tcl_GetStringResult(p->interp), -1); }else{ sqlite3_result_text(context, Tcl_GetStringResult(p->interp), -1, SQLITE_TRANSIENT); } } So, it uses

[sqlite] error with authorizer, onecolumn and TCL

2010-01-23 Thread Ramon Ribó
The following sequence gives an incorrect result value: (ramsan) package require sqlite3 3.6.22 (ramsan) 2 % sqlite3 db :memory: (ramsan) 3 % db authorizer myauth (ramsan) 4 % proc myauth { cmd args } { return SQLITE_OK } (ramsan) 6 % db eval { create table t(a,b) } (ramsan) 7 % db onecolumn {