Re: [sqlite] Problem with close

Onnig Kouyoumdjian wrote: One reason is that with the Finisar, I can specify the PRAGMA synchronous=OFF and I don't see that as an option with Mono. Unless the wrapper specifically parses the SQL you provide and specifically prevents this from executing then it will work. These pragma comma

RE: [sqlite] Problem with close

At least for now, switching to the Mono wrapper isn't an option. I will put that on a "to look at" list, but there are several reason why I can't switch for now. One reason is that with the Finisar, I can specify the PRAGMA synchronous=OFF and I don't see that as an option with Mono. I need to

RE: [sqlite] Problem with EXPLAIN in Sqlite-3.3.5

Re: EXPLAIN is omitted by default. Recompile with -DSQLITE_DEBUG=1 to turn it on. That certainly explains it. - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] Problem with EXPLAIN in Sqlite-3.3.5

"Lowder, Brady M." <[EMAIL PROTECTED]> wrote: > Group, > > > Using sqlite-3.3.5 along with Tcl8.4.11 and Tk8.4.11, the EXPLAIN > command doesn't produce the desired result. EXPLAIN is used for > interpreting SELECT, INSERT, DELETE, UPDATE SQL commands. It appears to > be retrieving insufficent

[sqlite] Problem with EXPLAIN in Sqlite-3.3.5

Group, Using sqlite-3.3.5 along with Tcl8.4.11 and Tk8.4.11, the EXPLAIN command doesn't produce the desired result. EXPLAIN is used for interpreting SELECT, INSERT, DELETE, UPDATE SQL commands. It appears to be retrieving insufficent opcodes and erroneous data that don't return a result from

Re: [sqlite] [tclsqlite] problem with copy from tcl --[solved]

- Original Message - From: "Michel Salvagniac" <[EMAIL PROTECTED]> To: Sent: Thursday, September 28, 2006 10:59 PM Subject: [sqlite] [tclsqlite] problem with copy from tcl Hello, i wish to insert data in a table from a Tcl program i use this command: "db1 copy ignore mvt sbple92.txt

[sqlite] Re: Re: Re: Custom functions in GROUP BY?

Ron Stevens wrote: On 9/28/06, Igor Tandetnik <[EMAIL PROTECTED]> wrote: Ron Stevens wrote: The problem is that I can't produce a canonical representation of the entries in my database. Often times some entries are subsets of others, but considered equal. It's possible for an entry to be a s

Re: [sqlite] Problem with .import -- SOLVED

On Fri, 29 Sep 2006, Dennis Cote wrote: When all else fails, the source is the ultimate documentation. :-) Dennis, True. True. Thanks, Rich -- Richard B. Shepard, Ph.D. |The Environmental Permitting Applied Ecosystem Services, Inc.(TM)|Accelerator

Re: [sqlite] Re: Re: Custom functions in GROUP BY?

On 9/28/06, Igor Tandetnik <[EMAIL PROTECTED]> wrote: Ron Stevens wrote: > The problem is that I can't produce a canonical representation of the > entries in my database. Often times some entries are subsets of > others, but considered equal. It's possible for an entry to be a > subset of two l

Re: [sqlite] record size limit ???

RohitPatel wrote: Q1. Need to know if there is maximum limit for record size ? Q2. What are the consequence of using such large record size ? I may need large record size in two-three tables. In two or three of my tables, I may need to have 64 columns or more and maximum record size may re

Re: [sqlite] Multiple Updates

Trevor Talbot wrote: Just prepare/step a BEGIN before the loop, and a COMMIT afterward. Or even more simply, use sqlite3_exec(). It works very well for everything except queries. It already contains all the code to prepare the statement and execute it using sqlite3_prepare and sqlite3_step.

Re: [sqlite] record size limit ???

RohitPatel wrote: Q1. Need to know if there is maximum limit for record size ? Q2. What are the consequence of using such large record size ? I may need large record size in two-three tables. In two or three of my tables, I may need to have 64 columns or more and maximum record size may re

Re: [sqlite] Problem with .import -- SOLVED

Rich Shepard wrote: I tried to find documentation on the .import command (and the other metacommands), but couldn't. Nothing about them in Mike Owens' book, the man page, or a Google search. This must be one of the pieces of knowlege that's passed from generation to generation only when som

Re: [sqlite] Multiple Updates

Hi Trevor, Thanks, that makes a big difference to the way I thought it worked. Regards, Chris Trevor Talbot wrote: On 9/29/06, Chris Gurtler <[EMAIL PROTECTED]> wrote: A transaction has the select statements in one single string starting with a begin and ending with an end. I have a colu

Re: [sqlite] Multiple Updates

On 9/29/06, Chris Gurtler <[EMAIL PROTECTED]> wrote: A transaction has the select statements in one single string starting with a begin and ending with an end. I have a column which is a BLOB, and this may contain control characters like NULL. Think of BEGIN and COMMIT more like state-changing

Re: [sqlite] Multiple Updates

Hi Trevor, A transaction has the select statements in one single string starting with a begin and ending with an end. I have a column which is a BLOB, and this may contain control characters like NULL. Regards, Chris Trevor Talbot wrote: On 9/28/06, Chris Gurtler <[EMAIL PROTECTED]> wro