[sqlite] Documentation clarification

2011-04-20 Thread Dennis Cote
d to be the same thing. Which of these is the correct name, or are they equivalent? -- Dennis Cote ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite and nested transactions

2007-04-11 Thread Dennis Cote
savepoints. Dennis Cote - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] Re: SQLite and nested transactions

2007-04-11 Thread Dennis Cote
nformation its nearly impossible decide if it must be done this way or not. Dennis Cote - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] Re: SQLite and nested transactions

2007-04-11 Thread Dennis Cote
transaction support would help *that* problem. Likewise. Dennis Cote - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] Re: SQLite and nested transactions

2007-04-11 Thread Dennis Cote
[EMAIL PROTECTED] wrote: I'm not sure if I can make intelligent decisions about choosing what I commit to the database. Things don't look too bright for you or your users then. ;-) I couldn't resist. :-) Dennis Cote

Re: [sqlite] Re: SQLite and nested transactions

2007-04-11 Thread Dennis Cote
complicated. Dennis Cote - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] Failed subquery (possible bug?)

2007-04-11 Thread Dennis Cote
und a real bug. You should open a bug report at http://www.sqlite.org/cvstrac/tktnew HTH Dennis Cote - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] Re: SQLite and nested transactions

2007-04-12 Thread Dennis Cote
h as swapping files on open and save rather than using transactions, so that real transactions can be used to update the active file atomically. Dennis Cote . - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] Re: SQLite and nested transactions

2007-04-12 Thread Dennis Cote
in the discussion. Again, I agree fully. Dennis Cote - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] Re: SQLite and nested transactions

2007-04-12 Thread Dennis Cote
Can you explain the difference? Dennis Cote - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] Re: SQLite and nested transactions

2007-04-12 Thread Dennis Cote
Darren Duncan wrote: At 3:33 PM -0600 4/11/07, Dennis Cote wrote: You have lost me here. If this transaction is considered successful without executing the middle step (which is the same as executing it and then undoing that execution) then that step does not belong in this transaction

Re: [sqlite] Performance analysis of SQLite statements

2007-04-12 Thread Dennis Cote
download a free trial. HTH Dennis Cote - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] SQLite join-mechanisms question

2007-04-12 Thread Dennis Cote
p2004/page-001.html The discussion of indexes starts about slide 40 and joins are on slide 57. HTH Dennis Cote - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] Help with SQL syntax. Ticket #2296

2007-04-12 Thread Dennis Cote
a FROM t1 UNION SELECT b, a from t1 ORDER by a, b SELECT a as c, b as d FROM t1 UNION SELECT b as c, a as d from t1 ORDER by c, d HTH Dennis Cote - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] Help with SQL syntax. Ticket #2296

2007-04-12 Thread Dennis Cote
I read it) and backwards compatibility seems to be the most important thing here.. This behavior is prohibited by the standard. Dennis Cote

Re: [sqlite] Help with SQL syntax. Ticket #2296

2007-04-13 Thread Dennis Cote
for that missing nugget. Dennis Cote - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] Still getting "Insertion failed because database is full." errors

2007-04-13 Thread Dennis Cote
file system such as http://sourceware.org/jffs2/ that uses "wear leveling" algorithms to spread the writes over all the flash devices blocks if you are writing often. HTH Dennis Cote - To unsubscribe,

Re: [sqlite] trim available ??

2007-04-16 Thread Dennis Cote
Stef Mientki wrote: I don't know which version I'm running, how can I detect that ? Stef, You can call sqlite3_libversion (see http://www.sqlite.org/capi3ref.html#sqlite3_libversion for details). HTH Dennis Cote

Re: [sqlite] Is this a valid syntax

2007-04-17 Thread Dennis Cote
is non standard. If you want your SQL code to be portable to other database engines you should use the standard syntax that Paul suggested. HTH Dennis Cote - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] Is this a valid syntax

2007-04-17 Thread Dennis Cote
the comparisons of the fields from both tables should affect the join. HTH Dennis Cote - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] Re: Re: One statement column to column copy

2007-04-20 Thread Dennis Cote
a different value for each row in the parameters table. for each row in table parameters set value = same as the current row of parameters> HTH Dennis Cote - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] Re: Show and describe

2007-04-20 Thread Dennis Cote
definitions. HTH Dennis Cote - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] beginner: Is posible inside a result of a function call another function for delete or update the row??

2007-04-20 Thread Dennis Cote
for details. HTH Dennis Cote - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] Submitting patches?

2007-04-23 Thread Dennis Cote
the Contributed Code section here http://www.sqlite.org/copyright.html HTH Dennis Cote - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] TRANSACTION

2007-04-23 Thread Dennis Cote
multiple SQL statements, so you might be able to use a trigger to do what you want if you execute a trigger in a transaction. HTH Dennis Cote - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] An explanation?

2007-04-23 Thread Dennis Cote
. Can you retry the test after running an ANALYZE command? Are the a and b values in your sample code uniformly distributed? Dennis Cote - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] An explanation?

2007-04-23 Thread Dennis Cote
and then looking up 150,200 records in the main table is simply more work than scanning the entire table of 300,000 records once. This case does not benefit from indexing, and in fact it is slowed down on both lookups and inserts. Dennis Cote

Re: [sqlite] An explanation?

2007-04-23 Thread Dennis Cote
portion of the entire database to pay for their overhead. Dennis Cote - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] Copy records from one DB to another

2007-04-24 Thread Dennis Cote
, You have it correct. Open the DB1 sqlite3 db1.db > attach db2.db as db2; > insert into table1 select * from db2.table1; > .quit You do basically the same thing using the C API. Open one database, then issue an attach command for the other. HTH De

[sqlite] test fixture tcl errors on Windows

2007-04-24 Thread Dennis Cote
ts using MinGW/MSYS. I haven't had any problems before, but I haven't built sqlite from source since around version 3.3.12. Do any of you TCL experts have any idea what could be wrong? TIA Dennis Cote - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] test fixture tcl errors on Windows

2007-04-24 Thread Dennis Cote
is a subtle bug here or not. I suspect that perhaps the file isn't really being closed until the script exits.Does this seem possible? Dennis Cote - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] Borland C++Builder linking issue

2007-04-25 Thread Dennis Cote
Dennis Cote - To unsubscribe, send email to [EMAIL PROTECTED] -

[sqlite] another test suite failure under Windows

2007-04-25 Thread Dennis Cote
I think it should be skipped much like the tests that depend upon the SQLITE_MEMDEBUG being defined. Does anyone with better TCL knowledge have any recommendations for either making these tests work under Windows, or detecting the OS so the tests can be skipped when not running under that OS?

[sqlite] yet another test suite problem on Windows

2007-04-25 Thread Dennis Cote
call from within TCL, or does this command have to be written in C? Dennis Cote - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] more test suite problems on Windows

2007-04-26 Thread Dennis Cote
thought someone would have let you know about that long ago. Dennis Cote - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] An explanation?

2007-04-26 Thread Dennis Cote
There is nothing to be gained by adding it to the index again. Your first query will be satisfied by a binary search in the title table looking for the id. It won't use the index. Your second query will be satisfied by a binary search in the TitleIdx index looking for a matching title. It won

Re: [sqlite] License Queries

2007-04-26 Thread Dennis Cote
to do any changes to sqlite, but i am more concerned about the licensing issues of the modules which are accesing sqlite. Sqlite is public domain. You can apply any license you want to any program that access sqlite. HTH Dennis Cote

Re: [sqlite] Import quoted and NULL values with .import

2007-04-26 Thread Dennis Cote
s a string 'NULL' not as a null value. There is no way to get SQLite to import null values. All you can do is run a few update statements after you do the import that change the empty strings into real nulls. update table t set coln = null where coln = ''; HTH D

Re: [sqlite] more test suite problems on Windows

2007-04-26 Thread Dennis Cote
for the new test. Anyway, misc7 works now. Have you tried to run the latest laststmtchanges.test on Windows? I am still getting a failure that shows the same double counting that was originally reported on the mailing list. laststmtchanges-1.2.1... Expected: [5] Got: [10] Dennis Cote

Re: [sqlite] more test suite problems on Windows

2007-04-27 Thread Dennis Cote
[EMAIL PROTECTED] wrote: Dennis Cote <[EMAIL PROTECTED]> wrote: Have you tried to run the latest laststmtchanges.test on Windows? I am still getting a failure that shows the same double counting that was originally reported on the mailing list. laststmtchanges-1.2.1... Ex

Re: [sqlite] more test suite problems on Windows

2007-04-27 Thread Dennis Cote
system? Dennis Cote - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] more test suite problems on Windows

2007-04-27 Thread Dennis Cote
LITE_NO_SYNC=1 $(TEMP_STORE) \ -o testfixture $(TESTSRC) $(TOP)/src/tclsqlite.c \ libsqlite3.la $(LIBTCL) Are you suggesting that -DSQLITE_NO_SYNC=1should be added to TCC so it affects all compiles? Dennis Cote

Re: [sqlite] sqlite and borland c++ builder

2007-04-30 Thread Dennis Cote
sqlite3.h header into a C++ source file. It might help to post to the newsgroups saying you are also having problems, or to vote on the bug in the QC system. HTH Dennis Cote - To unsubscribe, send email to [EMAIL

Re: [sqlite] SQL query help (mutiple joins)

2007-05-01 Thread Dennis Cote
oTable as r on r.TestID=t.ID where f.EVC > 2.0 and r.FVC > 2.0; HTH Dennis Cote - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] SQL query help (mutiple joins)

2007-05-01 Thread Dennis Cote
RelaxedSpiroTable as r on r.TestID=t.ID where f.EVC > 2.0 and r.FVC > 2.0; HTH Dennis Cote - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] SQL query help (mutiple joins)

2007-05-01 Thread Dennis Cote
Allan, Mark wrote: Excellent, thanks for your help. Mark, For future reference, your posts could use a little more trimming. There is no need to quote the entire string of messages from your original post on each reply. :-) Dennis Cote

Re: [sqlite] FW: Performance problem with complex where clause

2007-05-02 Thread Dennis Cote
urce.Id" = '06d15df5-4253-4a65-b91f-cca52da960fe' This should run in a reasonable time given that you have indexes on Link("Target.Id") and Link("Source.Id") HTH Dennis Cote - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] FW: Performance problem with complex where clause

2007-05-02 Thread Dennis Cote
S ne on l."Source.Id" = ne.Id Where l."Target.Id" = '06d15df5-4253-4a65-b91f-cca52da960fe' UNION Select ne.* From Link AS l Join Entity AS ne on l."Target.Id" = ne.Id Where l."Source.Id&quo

Re: [sqlite] Best way to optimize this query?

2007-05-02 Thread Dennis Cote
ements but will build two records (one in the table and one in the index) for each record. I seem to be rambling so I will stop now. HTH Dennis Cote - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] FW: Performance problem with complex where clause

2007-05-02 Thread Dennis Cote
Id" = '06d15df5-4253-4a65-b91f-cca52da960fe' The extra join gives sqlite an opportunity to use the source id index for the first join and the target id index for the second join. HTH Dennis Cote - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] create trigger on view

2007-05-03 Thread Dennis Cote
or modify the required rows in your view cache table whenever a record is inserted or modified in the base tables. A trigger on the view will only fire when you access the view. HTH Dennis Cote - To unsubscribe, send

Re: [sqlite] May I ask why the source distribution mechanism was changed starting with 3.3.14?

2007-05-04 Thread Dennis Cote
makes many peoples lives at least a little easier and hence better. I hope the rewards have been worth the effort. Dennis Cote - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] Conditional table select

2007-05-09 Thread Dennis Cote
a query that references the view. HTH Dennis Cote - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] perfomance degradation for expr "foo = X or bar =X"

2007-05-09 Thread Dennis Cote
= 5 intersect select rowid from ex4 where y = 7 ); The intersect operation allows each of the sub-selects to be executed using an independent index, and the outer select uses the implicit index on the rowi

Re: [sqlite] perfomance degradation for expr "foo = X or bar =X"

2007-05-09 Thread Dennis Cote
) This will find points in a circumscribed square around the center of the circle. The distance calculation would eliminate those points outside the circle (i.e. the points in the corners of the squares). Dennis Cote - To unsubscribe

Re: [sqlite] The need for sqlite3_encode_binary and sqlite3_decode_binary

2007-05-10 Thread Dennis Cote
data to an SQL statement without worrying about special quoting. Dennis Cote - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] left outer join optimization

2007-05-23 Thread Dennis Cote
out of the services table. select id as cust_id, service as service_id from customers where service not null; HTH Dennis Cote - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] index using and explain using question

2007-05-25 Thread Dennis Cote
elect * from t; order from detail -- -- -- 0 0 TABLE t HTH Dennis Cote - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] Why doesn't this UPDATE work?

2007-05-28 Thread Dennis Cote
for each row in table 1. Each evaluation returns the value of column3 from a different row in table2, the row where the column2 and column2 values match the row being updated. HTH Dennis Cote - To unsubscribe, send email

Re: [sqlite] Why doesn't this UPDATE work?

2007-05-28 Thread Dennis Cote
. Dennis Cote - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] sqlite internal structs don't make use of C bitfields?

2007-05-30 Thread Dennis Cote
platform applications. I suspect that is the reason they aren't used. Dennis Cote - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] sqlite internal structs don't make use of C bitfields?

2007-05-30 Thread Dennis Cote
in the first byte and the code only checks for zero vs nonzero values on that byte (then again that may not be safe if other combined bitfield are set nonzero before the isInited field is set). If its safe, you could save another byte per structure. Dennis Cote

Re: [sqlite] sqlite internal structs don't make use of C bitfields?

2007-05-30 Thread Dennis Cote
. Dennis Cote - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] Age calculation on literal

2007-05-31 Thread Dennis Cote
RB Smissaert wrote: Thanks to Dennis Cote I got a nice way to get the age from the date in the form '-nmm-dd'. It works fine when I run it on a field, but when I run it on a literal date it gives me 100 too much: select case when date('2002-01-01', '+' || (strftime('%Y', 'now') - strftime

Re: [sqlite] Age calculation on literal

2007-06-01 Thread Dennis Cote
006-10-14'))) end end HTH Dennis Cote

Re: [sqlite] Step Query

2007-06-20 Thread Dennis Cote
r framework is freely licensed open source so others could use it as well? It sounds interesting, and I would like to take a look at it if that is possible. Is there a link to the source? Dennis Cote - To uns

Re: [sqlite] How do I close the command line window

2007-06-20 Thread Dennis Cote
a .read command on the command line instead of the -init option like this: sqlite3 mydatabasefile ".read BulkinsertItems.sql" with the BulkinsertItems.sql file containing: .separator \t .import BulkItems.txt items .quit HTH D

Re: [sqlite] Worked perfectly!

2007-06-26 Thread Dennis Cote
litenoob wrote: -- #/bin/sh ROW_ID=`sqlite3 test.db < FYI, the last part of the select is superfluous. You can simply do this: insert into t values(1,2); select last_insert_rowid(); HTH Dennis C

Re: [sqlite] Crashes and random wrong results with certain column names

2007-06-26 Thread Dennis Cote
zy. Is this a bug or am I simply not supposed to use such column names? (I was reading the formal SQL-92 syntax definition recently and thought, why not just try it out...) Yves, You should file a bug ticket at http://www.sqlite.org/cvstrac/captcha?nxp=/cvstrac/tktnew since these are all valid quoted SQL identifiers. Dennis Cote - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] Crashes and random wrong results with certain column names

2007-06-26 Thread Dennis Cote
this was fixed so quickly. Dennis Cote - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] Re: Why "Offset" only not supported?

2007-06-27 Thread Dennis Cote
I believe that something along the line of PostgreSQL’s syntax is readable and compact. Proposed Solution: None provided with comment. HTH Dennis Cote - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] Extremely new to SQLite

2007-08-07 Thread Dennis Cote
that shows how to use the wrapper to do the things you need to do. The CppSQLite wrapper library is available to download from the site as well. HTH Dennis Cote - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] last_row_id() after insert via trigger

2007-08-07 Thread Dennis Cote
rt_rowid(); end; insert into "Test View" (rowid) values (null); select rowid || ' from view after insert' from "Test View" where rowid=(select id from last_inserted_row); HTH Dennis Cote - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] Extremely new to SQLite

2007-08-07 Thread Dennis Cote
primarily for backward compatibility. You should really look at the prepare/bind/step/column set of API functions introduced in version 3 which is described at http://www.sqlite.org/capi3.html Dennis Cote - To unsubscribe

Re: [sqlite] Extremely new to SQLite

2007-08-07 Thread Dennis Cote
ally the callback mechanism that has been depreciated, not sqlite3_exec itself. The callback mechanism is still supported for backwards compatibility, which is why the quickstart code (along with lots of other existing sqlite client code) still works, but it should not be

Re: [sqlite] Extremely new to SQLite

2007-08-07 Thread Dennis Cote
te,/ in the sense "to belittle or mildly disparage," as in /He deprecated his own contribution./ In an earlier survey, this newer sense was approved by a majority of the Usage Panel. Dennis Cote - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] Object Oriented Question About Adding a vector inside the callback function

2007-08-09 Thread Dennis Cote
ile( isspace((unsigned char)zSql[0]) ) zSql++; } break; } } sqliteFree(azCols); azCols = 0; } HTH Dennis Cote - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] Object Oriented Question About Adding a vector inside the callback function

2007-08-10 Thread Dennis Cote
is executed only once. The inner loop will be executed once for each result row. HTH Dennis Cote - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] Re: very slow inserts

2007-08-14 Thread Dennis Cote
IFO table in sqlite http://article.gmane.org/gmane.comp.db.sqlite.general/16230/match=fifo and this one gives some more info on the fifo id reset problem http://article.gmane.org/gmane.comp.db.sqlite.general/16248/match=fifo This should help you build a table with a maximum number of entries. HTH D

Re: [sqlite] Dump with where clause

2007-08-16 Thread Dennis Cote
ert statements. .mode insert select * from table1 where ID > 1000; This doesn't generate the transaction wrapper, or the table's create statement, but you can add those yourself if needed. HTH Denni

Re: [sqlite] example of import/copy for Windows?

2007-08-21 Thread Dennis Cote
rmutations. It usually give me an error saying 'syntax error at' the start of my Try sqlite3 DBfile.db3 The .sql file contains SQL commands that must be executed by sqlite to create the database, not data to be imported into the database. HTH D

Re: [sqlite] Spatial searches

2007-08-23 Thread Dennis Cote
gitude indexes, one in each of the subselects), and the indexes contain the id field so it does not have to lookup any records in the points table until the last step, this query should run fairly quickly. HTH Dennis Cote

Re: [sqlite] Date comparison on UTC

2007-08-27 Thread Dennis Cote
way to round off the datestamp to the beginning of the day, or maybe do you know if there is a list of built-in date functions somewhere? Andre, Check out this page http://www.sqlite.org/cvstrac/wiki?p=DateAndTimeFunctions I'm sure it will clear up lots of your questions. HTH Dennis C

Re: [sqlite] Towards SQLite version 3.5.0

2007-08-28 Thread Dennis Cote
rch criteria. I wonder if it might not be better to change this API to accept an empty string, in addition to a NULL pointer, to find the default VFS. It seems to me this might make life easier for those writing wrappers in languages that don't have a concept of a NULL pointer. Dennis C

Re: [sqlite] CURRENT_TIMESTAMP value in single transaction

2007-08-28 Thread Dennis Cote
. HTH Dennis Cote - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] BestMatch and SqliteStatment Clash

2007-08-29 Thread Dennis Cote
you think the first such match is the best match, but that is another issue for you to look at. Another point, you should be using double quotes around your table name, not single quotes. HTH Dennis Cote

Re: [sqlite] More on Column types

2007-09-07 Thread Dennis Cote
the column. HTH Dennis Cote - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] ANSI order by

2007-09-07 Thread Dennis Cote
and register your own collation function which does exactly what you want. :-) HTH Dennis Cote - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] Re: Re: Merging two tables

2007-09-10 Thread Dennis Cote
and the func.c source file at http://www.sqlite.org/cvstrac/fileview?f=sqlite/src/func.c=1.174 which uses these APIs to implement all the built in SQL functions. HTH Dennis Cote - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] loadext bug

2007-10-12 Thread Dennis Cote
big will not load into sqlite. Ken, You should file a bug report at http://www.sqlite.org/cvstrac/captcha?nxp=/cvstrac/tktnew so this gets fixed. Dennis Cote - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] Detecting the change from inside a trigger

2007-10-18 Thread Dennis Cote
ore detail. HTH Dennis Cote - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] sqlite3_update_hook

2007-10-18 Thread Dennis Cote
efore update on table" or "before delete on table" trigger to get the rowid of the row before it is deleted. You can access the value old.rowid from within the trigger and save it into another table for example. See http://www.sqlite.org/lang_createtrigger.html for more detail

Re: [sqlite] it seems sqlite3_prepare_v2 disappeared for me

2007-10-25 Thread Dennis Cote
to sqlite3_libversion(). The prepare_v2 API was added in version 3.3.9 so it will not not be present in earlier versions. HTH Dennis Cote - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] INSERT OR IGNORE and sqlite3_last_insert_rowid()

2007-10-29 Thread Dennis Cote
handle the failure in an appropriate manner. Dennis Cote - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] INSERT OR IGNORE and sqlite3_last_insert_rowid()

2007-10-29 Thread Dennis Cote
ct * from tmp; 2|2 1|1 sqlite> Simon, If you change your query to; select rowid, * from tmp; it will display the rowid which is different than either of the fields in the table. When doing a replace sqlite deletes the exi

Re: [sqlite] Retrieve bound host parameters from statement?

2007-10-30 Thread Dennis Cote
insert statement, to a select statement. When you run the select it returns the values bound to the parameters as the result of the select. This lets you see the values that will be used if you run the first insert statement. I thought it was a brilliant example of thinking outside the b

Re: [sqlite] Problem using POSIX semaphores and triggers to signal updates

2007-11-01 Thread Dennis Cote
#sqlite3_commit_hook). If the flag is set the commit hook can post to the semaphore and wakeup your GUI process, and then clear the flag. HTH Dennis Cote - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] How to get 3.4.2 code

2007-11-09 Thread Dennis Cote
you want. All the old files are still on the server, there just aren't any links so you have to type them in manually. HTH Dennis Cote - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] How to get 3.4.2 code

2007-11-09 Thread Dennis Cote
the server, they just don't have clickable links on the download page, so you have to enter the filename with the desired version manually (or by editing a very similar URL using copy and paste to minimize typing errors). HTH D

Re: [sqlite] One line batch file?

2007-11-12 Thread Dennis Cote
this overhead for a one-liner. Owen, Try this instead: sqlite3 test "insert into testable values ('value1','value2')" HTH Dennis Cote - To unsubscribe, send email to [EMAIL PROTECTED] -

  1   2   3   4   5   6   7   8   9   10   >