[sqlite] error with authorizer, onecolumn and TCL

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 {

Re: [sqlite] what extension do you recommend

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 http

Re: [sqlite] Re: SQLite and nested transactions

regards, -- Compass Ing. y Sistemas Dr. Ramon Ribo http://www.compassis.com[EMAIL PROTECTED] c/ Tuset, 8 7-2 tel. +34 93 218 19 89 08006 Barcelona, Spain fax. +34 93 396 97 46 En Thu, 12 Apr 2007 00:37:21 +0200, Dennis Cote <[EMAIL PROTECTED]> es

[sqlite] New conflict clause: update

t? when a unique key contraint is hit. I think that it could have advantages over the "replace" conflict clause for the very usual case that a new record must be updated or inserted if it does not exist. What is your opinion on this? -- Compass Ing. y Sistemas

Re: [sqlite] "Data Dictionary" in SQLite?

>From what I know sqlite is not a DBRMS Thanks > Is there an Oracle data-dictionary equivalent in SQLite? > > > > Ie. Is there something similar to "SELECT * FROM ALL_TABLES" to get > information about tables in the database returned in row format? I know > that I can use .tables or .dump to find

[sqlite] aggregate funtion in the TCL binding

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] aggregate funtion in the TCL binding

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]

Re: [sqlite] limiting database size

> On 7/11/05, Ramon <[EMAIL PROTECTED]> wrote: >> I would like to know if there is a way to limit a sqlite database and then be >> able >> to change this limit later on? > > Stop inserting when it's full? > > I want to put a limit like 10mb then later o

[sqlite] limiting database size

I would like to know if there is a way to limit a sqlite database and then be able to change this limit later on?

Re: [sqlite] download db - security question

Thanks for all the help, I will be implementing this in the next couple of weeks in my project. Thanks again, Ramon > On Mon, 2005-01-24 at 11:46 -0500, Jason Morehouse wrote: > >> If using apache, this also works nice in your httpd.conf -- it allows >> you to put databases a

[sqlite] download db - security question

I was wondering if someone can just download off my webpage the sqlite database. And if they can is there a way to block this type of download throw apache? Any tips and advices are welcome. Thanks, Ramon