There are two different types of insert that need to happen into a table,
one is where the rowid (EventNodeId) is part of the actual insert, the
other it is excluded so that AUTOINCREMENT will fill it in. There is an
insert triggers to set the audit fields on the table during the insert.
The
Yes, that was the case. The app has two databases, a system wide DB and
the active data DB. The system points to the active data DB but wasn't
configured to point to the active data. Live and learn:)
Pax vobiscum,
Sam Carleton
On Wed, Oct 15, 2014 at 6:01 AM, Dan Kennedy danielk1...@gmail.com
to access the EventNode table, so I am a bit mystified as to what
exactly is going on. Any thoughts?
--
Pax vobiscum,
Sam Carleton
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
row
particular ItemName should go to.
Pavel
On Thu, Jul 5, 2012 at 11:03 PM, Sam Carleton
scarle...@miltonstreet.com wrote:
I am working on converting my system table from one form to another. The
old form was one row per value with a category/key/value (DBLookup) , the
new form
Folks, I would like to thank one and all, I think this was a group effort.
I changed the double quotes to single, changed the value into a select and
then just ran the select part and found one NULL filed because I had the
wrong category. Fixed that and left it as a select and all is well! Thank
I am working on converting my system table from one form to another. The
old form was one row per value with a category/key/value (DBLookup) , the
new form is a separate column for each value (PP_VIEWER_SETTINGS). I am
trying to create an insert statement to run when the new table is created,
to the document db, the
triggers need to be off.
Sam
On Mon, Oct 3, 2011 at 4:51 AM, Simon Slavin slav...@bigfraud.org wrote:
On 3 Oct 2011, at 4:12am, Sam Carleton wrote:
Ok, how do I list what a trigger is so that I can add it back once I want
to
reactive it?
To list all triggers:
SELECT
Is there any way to disable a trigger in sqlite?
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Ok, how do I list what a trigger is so that I can add it back once I want to
reactive it?
On Sun, Oct 2, 2011 at 9:07 PM, Igor Tandetnik itandet...@mvps.org wrote:
Sam Carleton scarle...@miltonstreet.com wrote:
Is there any way to disable a trigger in sqlite?
DROP TRIGGER
--
Igor
On Thu, Sep 15, 2011 at 6:38 AM, Richard Hipp d...@sqlite.org wrote:
On Wed, Sep 14, 2011 at 9:03 PM, Sam Carleton scarle...@miltonstreet.com
wrote:
Forgive me, fore I have forgotten the term used to describe the behavior
if
a C if statement where it stops executing on the first false
On Thu, Sep 15, 2011 at 10:05 AM, Simon Slavin slav...@bigfraud.org wrote:
Documentation for COALESCE is here:
http://www.sqlite.org/lang_corefunc.html
It does not say whether it does short-circuit evaluation but the description
does imply testing one by one, rather than evaluating all the
On Thu, Sep 15, 2011 at 12:24 PM, Simon Slavin slav...@bigfraud.org wrote:
On 15 Sep 2011, at 5:00pm, Sam Carleton wrote:
I don't mean to be difficult, but I simply don't get any indication of
how exactly COALESCE actually functions from this description:
coalesce(X,Y,...) The coalesce
Forgive me, fore I have forgotten the term used to describe the behavior if
a C if statement where it stops executing on the first false statement,
but... Does coalesce do that?
I have to put together a query that has a coalesce such that if the row from
the table is null, it then does a
I have a select statement that is calculating the subTotal, Tax, and grand
total:
UPDATE Invoice
SET Sub_Total = (select sum(PRICE * QTY) from INVOICE_ITEM where
INVOICE_ID = @invoiceId),
Tax = (select round( sum(PRICE * QTY) * ( @tax / 100) + .005, 2) from
INVOICE_ITEM where INVOICE_ID
It is very clear to me that my expectations are wrong, please enlighten
me...
Here is the query:
update INVOICE
set SUB_TOTAL = (select sum(PRICE * QTY) from INVOICE_ITEM ii where
ii.INVOICE_ID = *INVOICE_ID*),
TAX = (select round( sum(PRICE * QTY) * ( 8.25 / 100) + .005, 2) from
release. There is a lot to come, I just need to get this out
the door as quickly as possible while providing useful information to my
users.
Sam
On Sun, Jun 5, 2011 at 8:17 PM, BareFeetWare list@barefeetware.comwrote:
On 06/06/2011, at 8:30 AM, Sam Carleton scarle...@miltonstreet.com
wrote
I have a invoice system where one invoice item can have one or more sum
items (images). Example is a CD... The invoice item is a CD, there are an
infinite numbers of images associated with that CD invoice item. So I have
the following:
CREATE TABLE Invoice_Item (
Invoice_Item_Id INTEGER
On Sun, Jun 5, 2011 at 1:04 PM, Simon Slavin slav...@bigfraud.org wrote:
Take a look at the group_concat() function:
http://www.sqlite.org/lang_aggfunc.html
That is PERFECT, thank you! If the person who thought of this function
originally is reading this, thank you!!! What a time saver!
On Sun, Jun 5, 2011 at 5:44 PM, Jay A. Kreibich j...@kreibi.ch wrote:
On Sun, Jun 05, 2011 at 12:47:47PM -0400, Sam Carleton scratched on the
wall:
In one select statement, I want to return a view of all the Invoice_Items
for a particular Invoice such that there is one column that contains
I just did a quick load test on my little web app that is using SQLite
in C code. Pretty quick it ran into a SQLITE_LOCKED while a
connection/user was logging in to the site. I have some code that
responds to SQLITE_BUSY by sleeping for 50 mills and retrying 4 times:
int rc =
How does one go about finding out how many rows a query returns? Is there a
way to find out the id of a particular column?
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
On May 8, 2011, at 11:09 AM, Jean-Christophe Deschamps j...@antichoc.net
wrote:
How does one go about finding out how many rows a query returns?
This is the number of time sqlite3_step can be called successfully
until it returns SQLITE_DONE.
I had it wrong in the email body, I meant how
On May 8, 2011, at 12:53 PM, Igor Tandetnik itandet...@mvps.org wrote:
Sam Carleton scarle...@gmail.com wrote:
I had it wrong in the email body, I meant how many columns are in query?
sqlite3_column_count. Don't even need to execute the query for that, just
prepare it.
Ah, thank you
On May 8, 2011, at 11:06 AM, Jay A. Kreibich j...@kreibi.ch wrote:
On Sun, May 08, 2011 at 11:00:29AM -0400, Sam Carleton scratched on the wall:
Is there a way to find out the id of a particular column?
sqlite3_column_name()
I want to go the other way: I have the string name, I need
On Sun, May 8, 2011 at 3:08 PM, Simon Slavin slav...@bigfraud.org wrote:
Out of interest, are you trying to analyse the results of a SELECT * ?
Because since it's your query in the first place, you should know what
columns you asked for.
Nope, I NEVER do SELECT *, very, very evil!
I am trying to track down an issue that I MIGHT have with the following
query. The explain query is a bit complex and I cannot tell if it is OK or
if there are issues. Here it is:
sqlite EXPLAIN QUERY PLAN
... SELECT DISTINCT f1.FolderId, f1.ImageId,
...(SELECT
On Fri, Apr 22, 2011 at 11:44 PM, Drake Wilson dr...@begriffli.ch wrote:
You probably need to sqlite3_reset the statement after stepping it.
Can someone then explain the purpose of sqlite3_clear_bindings()? If
I understand things correctly, you call sqlite3_reset() to reuse a
prepaired
I am implementing a dataset update process. There is a for loop going
through the dataset either doing an update on the row or deleting the
row. So there are two statements that are preparied, currently I am
using the same basic logic for both. The problem is the second time
around I get a
The system calls for an associative table, a table with two foriegn
keys to two other tables, allowing for a many to many relationship.
Is there any way to make the primary key be both the columns?
CREATE TABLE Invoice_Item_Favorite(
Invoice_Item_Id INTEGER,
FavoriteId INTEGER,
Is my impression correct that when calling sqlite3_step() on a query
that returns no rows, the result will be [SQLITE_DONE]? If that is
the case, might that be added to the documentation?
___
sqlite-users mailing list
sqlite-users@sqlite.org
On Tue, Mar 22, 2011 at 10:55 PM, BareFeetWare list@barefeetware.comwrote:
You have to drop the old table and create a new one with the changed
foreign keys.
This is a bummer. Is there any desire/plan to add an alter feature, in the
future?
Also, from a performance perspective, is
On Wed, Mar 23, 2011 at 12:20 PM, Nico Williams n...@cryptonector.comwrote:
I do think that SQLite3 will eventually need to grow ALTER support for
altering constraints. This whole copy-the-table thing is not really a
scalable solution. Without such ALTER functionality users will often
have
On Wed, Mar 23, 2011 at 2:00 PM, Nico Williams n...@cryptonector.comwrote:
Also, just to be clear, making the schema writable and then making any
updates to sqlite_master is completely unsupported, and should be.
This is good, very good, IMHO. Which is also why I won't do it:) hehehehe
I am looking for a good SQLite IDE, SQLite Maestro looks like a good
candidate with most all the features I need. The price is good, too.
The one feature I don't see is a tool that can do a diff on the DDL of
two SQLite db's. Does anyone know of any other SQLite IDE's that have
that ability?
On Tue, Mar 22, 2011 at 3:26 PM, Jonathan Allin
jonat...@jonathanallin.com wrote:
Would the diff have to do more than compare (in some nice graphical way) the
two sqlite_master tables?
What I am looking for is this: I have one version of the DB out in
the field, I have made changed to it in
On Tue, Mar 22, 2011 at 4:02 PM, Ben sqlite_l...@menial.co.uk wrote:
You don't mention which platform you're on, but for OS X there's a good
comparison table of SQLite editors here:
http://www.barefeetware.com/sqlite/compare/?ml
Ben,
I have a Mac, but I am currently targetting Windows.
I don't see any examples on http://www.sqlite.org/foreignkeys.html how to
either add or drop a foreign key to an existing table. What might that
syntax look like exactly?
Also, from a performance perspective, is there an advantage to using a
foreign key in SQLite verses just an index? (aka, is
Ok, a few weeks ago I posted an issue that I was having with the attach
commend because the path has a single quote in it. Someone suggested I use
the sqlite_attach() function which allegedly can be parametrized. Well, I
finally got around to it this evening but I am missing something. Here is
)
**
** If the optional KEY z syntax is omitted, an SQL NULL is passed as the
** third argument.
*/
--
--
--
--ΞΞ--
ô¿ô¬
K e V i N
/¯\
On Tue, Feb 22, 2011 at 9:35 PM, Sam Carleton scarle...@miltonstreet.com
wrote:
y KEY z
On Mon, Feb 21, 2011 at 9:42 AM, Sam Carleton scarle...@miltonstreet.comwrote:
On Sun, Feb 20, 2011 at 4:11 PM, Scott Hess sh...@google.com wrote:
You can also convert:
ATTACH DATABASE x AS y KEY z
to:
SELECT sqlite_attach(x, y, z)
where the parameters can be turned into bind arguments
This is a bit crazy and I know the ideal way would be to not allow the
apostrophy in the first place but, my focus is easy of use for my customers,
as compared to easy for me...
I had a customer that saved their SQLite database here:
D:/My Events/President's Day/event.sqlite
My software uses
On Fri, Feb 11, 2011 at 6:54 AM, Philip Graham Willoughby
phil.willoug...@strawberrycat.com wrote:
Hi Sam,
On 11 Feb 2011, at 05:29, Sam Carleton wrote:
I am sure it is bad form, but attached is one of the 3.6.23 DB, it is
only
12K.
The mailing list software strips attachments; can you
wrote:
On 02/11/2011 08:08 PM, Sam Carleton wrote:
On Fri, Feb 11, 2011 at 6:54 AM, Philip Graham Willoughby
phil.willoug...@strawberrycat.com wrote:
Hi Sam,
On 11 Feb 2011, at 05:29, Sam Carleton wrote:
I am sure it is bad form, but attached is one of the 3.6.23 DB, it is
only
12K
Just wondering, are the wal and shm files suppose to stick around after the
process exits?
Sam
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
I am in the process of upgrading my app from using SQLite.net w/ 3.6.23 to
SQLite.net w/ 3.7.5. When the .Net program starts in a fresh install state,
aka no system db exists and it builds one up via SQL script all works fine.
When it opens an existing 3.6.23 system db, it gets a database lock.
Currently I have two and sometimes three clients access the SQLite db, all
on the same machine.
* A C# program that doesn't ever stay connection all that long.
* An Apache application that stays connected all the time.
* A Qt application that stays connected when it is running.
I am getting
On Wed, Feb 9, 2011 at 1:46 PM, Igor Tandetnik itandet...@mvps.org wrote:
On 2/9/2011 1:42 PM, Sam Carleton wrote:
It is my understanding that SQLite is designed to allow multiple clients
from the same computer to access the DB file at one time.
Yes. But if one of those clients starts
I hacked the 3.6.23.1 amalgamation code a while back. I need to move
those hacks to 3.7.500, but I don't seem to have a copy of the
3.6.23.1 amalgamation code. Where can I find a copy?
Sam
___
sqlite-users mailing list
sqlite-users@sqlite.org
I am using SQLite in a Apache module on Windows. On Windows, Apache is a
single multi-threaded process. The Apache DBD is used to leverage
connection pooling.
At one point in the code, the web request gets a connection, creates a temp
table, used the temp table, and then deletes the temp table
I am adding some indexes to an existing database to improve performance. I
am 99.9% sure they are unique, but... it was a while ago that I was in that
code. Are there any performance reasons to make them unique or make them
not unique? From the stand point of risk, my inclination is to make
I am trying to optimize a query by using the EXPLAIN QUERY, but the
documentation on the web (http://www.sqlite.org/eqp.html) does not match the
version of SQLite I am using (v3.6.23.1). The documentation says there are
three columns, but I am only seeing two columns. What do the two columns
What is the best LINQ provider for SQLite?
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
When compiling sqlite for Windows desktop OS's (XP, Vista, Win7), should
SQLITE_ENABLE_ATOMIC_WRITE be set or not?
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
I just read over the Using the sqlite3_unlock_notify() API and it
looks like exactly what I need. The only catch is that currently I am
running everything on Windows.
Does anyone have a port of the supporting functions discussed on the
page for Windows?
Sam
site and it has been outstanding! Mind you, I am
using the C interface.
Sam Carleton
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
I just read the page on Shared-Cache Mode and it left me with some questions...
Q1: Is my understanding correct: Shared-Cache Mode is used within a
process to gain table locking, as compared to the normal file locking.
How to Enabling Shared-Cache Mode in the following situation:
SQLite is
I am having some issues with dead locks. Currently I have two
different processes access the sqlite db, one is an Apache module
using the dbd framework to manage connections, the other is a .Net
program using the standard .Net provider.
I wanted to just validate that both the providers can open
Tim,
I, like you, am using SQLite as the DB to a web server. But I have to agree
with Roger. I do so from the prospective that web client cannot make native
calls to SQLite. Thus the web server is the client. Further more I would
say that in all web server based solutions, the web server is
I am using SQLite inside of Apache. I am using the Apache connection pool
system, so as long as the server is running there is always one connection
to the database. I have one very high traffic table with lots of reads and
writes, it turns out that this info does *NOT* need to be resident
On Tue, Jul 20, 2010 at 8:34 PM, Simon Slavin slav...@bigfraud.org wrote:
On 21 Jul 2010, at 12:42am, Sam Carleton wrote:
There are two equally
important requires, one is to connect to the second EventDB, the other
is
that the system admin can change the EventDB at any time.
You mean
On Mon, Jul 19, 2010 at 9:46 PM, Simon Slavin slav...@bigfraud.org wrote:
On 20 Jul 2010, at 2:01am, Sam Carleton wrote:
On Mon, Jul 19, 2010 at 3:51 PM, Simon Slavin slav...@bigfraud.org
wrote:
You know, I think that the most efficient way to do what you want will
probably to always
How expensive is doing a PRAGMA database_list?
I am using the connection pooling in Apache APR's DBD system. Currently
there are multiple places with in one request that does the following:
- Get a connection to the DB
- Call PRAGMA database_list
- Iterate through the list looking for
On Mon, Jul 19, 2010 at 2:58 PM, Simon Slavin slav...@bigfraud.org wrote:
On 19 Jul 2010, at 3:50pm, Sam Carleton wrote:
I am using the connection pooling in Apache APR's DBD system. Currently
there are multiple places with in one request that does the following:
- Get a connection
On Mon, Jul 19, 2010 at 2:58 PM, Simon Slavin slav...@bigfraud.org wrote:
On 19 Jul 2010, at 3:50pm, Sam Carleton wrote:
- Connection to the second one if it is old (wrong physical file) or not
connected.
(Actually you will get other databases shown in 'PRAGMA database_list
On Mon, Jul 19, 2010 at 4:02 PM, Jay A. Kreibich j...@kreibi.ch wrote:
On Mon, Jul 19, 2010 at 01:27:52AM -0400, Sam Carleton scratched on the wall:
Is there any way to use the PRAGMA database_list in a query? What I would
like to do is:
SELECT * FROM (PRAGMA database_list) WHERE name
On Mon, Jul 19, 2010 at 3:51 PM, Simon Slavin slav...@bigfraud.org wrote:
You know, I think that the most efficient way to do what you want will
probably to always issue the 'ATTACH' command. If EventsDB is already
attached, you should get a specific error code, which you can notice but
I am working with an Apache module that is using the Apache DBD connection
pool system. The application always need to connect to two DB files, the
System DB and the Event DB. The System DB is the default, the Event
DB is always connected via an ATTACH DATABASE called EventDB. The system
admin
Is there any way to use the PRAGMA database_list in a query? What I would
like to do is:
SELECT * FROM (PRAGMA database_list) WHERE name = 'EventDB';
Sam
On Sun, Jul 18, 2010 at 11:56 PM, Simon Slavin slav...@bigfraud.org wrote:
On 19 Jul 2010, at 4:48am, Sam Carleton wrote:
It would
From: sqlite-users-boun...@sqlite.org on behalf of Sam Carleton
Sent: Sun 7/11/2010 8:42 PM
To: General Discussion of SQLite Database
Subject: EXTERNAL:[sqlite] binding an IN
Is there any way to bind to this query?
SELECT * FROM table WHERE tableId IN ( ? );
Where
I posted this over the weekend, I am assuming it was overlooked
because it was, well, the weekend:) Does anyone have any thoughts?
--
I am on Window 7, opening an existing database with these flags:
SQLITE_OPEN_EXCLUSIVE |
On Mon, Jul 12, 2010 at 10:36 AM, Jay A. Kreibich j...@kreibi.ch wrote:
Are you using sqlite3_exec() for all of these? My first guess is that
you're not finalizing the INSERT statement (or allowing it to run to
completion) before trying to drop the table.
I am using sqlite3_exec() for
I have some audit fields, one being updatedby, I would like to create an
update trigger that would prevent the row from being updated if this was not
set. Can I do that in sqlite?
___
sqlite-users mailing list
sqlite-users@sqlite.org
Is there any way to bind to this query?
SELECT * FROM table WHERE tableId IN ( ? );
Where ? should be 1,2,3,4
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
I am on Window 7, opening an existing database with these flags:
SQLITE_OPEN_EXCLUSIVE |
SQLITE_OPEN_READWRITE |
SQLITE_OPEN_CREATE
Then I get a value from one table, begin a transaction, create a temp
customer table, fill it with the current values from the customer table.
Here is that SQL run
On Fri, Jul 9, 2010 at 2:48 PM, smengl90
fixed-term.seak.meng...@us.bosch.com wrote:
Hi, I want to compose a query that will use a c++ variable. For example I
have:
int i= 5;
char * query = SELECT * from userInfo WHERE count'i'.
The syntax does not work. How do I do that?
smengl90,
You
I really don't mean to be a jerk, but this does seem to be really off
topic for this mailing list. Isn't the concatination of two string a
general C/C++ question rather then a sqlite question? Don't you think
you might be better off asking this question on a C/C++ mailing list
or forum, maybe
On Wed, Jul 7, 2010 at 2:55 PM, Jay A. Kreibich j...@kreibi.ch wrote:
This one is coming out next month. I like it.
http://www.amazon.com/Using-SQLite-Jay-Kreibich/dp/0596521189/
Jay,
Without knowing anything more about the book other then the link you
provided, the one thing I do know
On Wed, Jul 7, 2010 at 7:12 PM, Simon Slavin slav...@bigfraud.org wrote:
The precompiled binaries are for those who see SQLite as some sort of
external library and don't want to include it in their own application.
It's a useful alternative for those who want to keep their own app as slim
I use a bit simpler approach, don't know if it is correct or not, but
it seems to work:
int rc = sqlite3_step(stmt);
while(rc == SQLITE_ROW)
{
/* read the row info */
rc = sqlite3_step(stmt);
}
if( rc != SQLITE_DONE)
{
/* handle error */
}
On Tue, Jul 6, 2010 at 3:33 PM, smengl90
fixed-term.seak.meng...@us.bosch.com wrote:
Hi guys,
I am trying to setup sqlite to be used with VC++ 2008. Can someone show me
where I can find instructions on how to set it up? and do I need a c++
wrapper to code in C++? If yes, can someone also
On Sat, Jun 26, 2010 at 11:22 PM, Igor Tandetnik itandet...@mvps.orgwrote:
Sam Carleton scarle...@miltonstreet.com wrote:
I have created a little extension function that I would like to load into
my
Qt program, so I am using the function load_extension, but it always
returns
false
Jan,
Actually I am already compiling sqlite to my liking and recompiling the Qt
sqlite3 driver. The custom sqlite3 has foreign keys turned on by default.
When you say I have to build my own driver, do you mean I simply need to
make another modification to my sqlite3 or are you saying I need to
In other databases there have been times when I have played some tricks with
the master tables, an example is:
Goal: change some fundamental characteristics of 'target_table' which cannot
be done by an ALTER
1: Create the new table with a different name: target_table2 with the
changes
2: Do an
I have created a little extension function that I would like to load into my
Qt program, so I am using the function load_extension, but it always returns
false. I am currently hard coding the path:
QSqlDatabase db = QSqlDatabase::addDatabase(QSQLITE);
db.setDatabaseName(systemDB);
a compare on it! I shake my head at myself sometimes.
Thanks a million Jay, I really appreciate it!
Sam
On Tue, Jun 22, 2010 at 12:06 AM, Jay A. Kreibich j...@kreibi.ch wrote:
On Mon, Jun 21, 2010 at 11:56:09PM -0400, Sam Carleton scratched on the
wall:
I am NEVER capturing anything
On Tue, Jun 22, 2010 at 9:15 AM, Pavel Ivanov paiva...@gmail.com wrote:
The idea is that the copy and nulling happens very quickly where the
sqlite3_close is more expensive, do the copy/null very quickly so that if
another thread calls Close during the first threads execution of
On Tue, Jun 22, 2010 at 10:13 AM, Pavel Ivanov paiva...@gmail.com wrote:
No, I did not. I am not storing any blobs right now, but... Is the busy
handler going to kick in? I know the busy handler is not the sole answer
to
the problem, but it does seem to catch most of my SQLITE_BUSY
was only seeing the problem on some machines.
Roger,
Your post bring me back to what I asked in my last post:
On Sun, Jun 20, 2010 at 11:31 PM, Sam Carleton
scarle...@miltonstreet.com wrote:
Through one request from the client, I open and close the database
multiple times. Since everything is very
On Mon, Jun 21, 2010 at 11:29 AM, Pavel Ivanov paiva...@gmail.com wrote:
hopefully there are better tools there for debugging this
type of thing.
There are, but usually they are not free. Quick googling for valgrind
for windows brought up commercial products Purify and Insure++ and
free
On Mon, Jun 21, 2010 at 12:24 PM, Roger Binns rog...@rogerbinns.com wrote:
On 06/21/2010 08:44 AM, Sam Carleton wrote:
I know I cannot afford ...
For some reason you are assuming that your time is free and that you have
no
other things to do with it (opportunity cost). That is how you
I have asked this Q a number of times over the last year and NEVER gotten
ANYONE to even comment on it. I am wondering why:
Am I opening the DB too much?
My usage of SQLite is in an Apache module that opens the DB each time it
needs info from the DB: For authentication it is open/closed, for
Ok, after a bit of testing this evening, the close which is crashing the
system has ALWAYS been the same close statement, the close after the Apache
Module has initialized the data structure to process the request. I went in
and made sure that each and every sqlite call is log if there is a
I am working on a slide show feature. The logic is based on time,
there are a set of image metadata (folderId and filename) add to the
DB, the insertion time is also saved. The client calls the
getNextSlideShow() method to get the next image. The current select
statement is:
SELECT FolderId,
something around the THEN statement.
Sam
On Sun, Jun 20, 2010 at 9:33 AM, Igor Tandetnik itandet...@mvps.org wrote:
Sam Carleton scarle...@miltonstreet.com wrote:
This works great. The issue is that the image returned might NOT
exist anymore, so I created an extension function to return 1
://www.sqlite.org/lang_expr.html
On Mon, Jun 21, 2010 at 2:28 AM, Sam Carleton
scarle...@miltonstreet.com wrote:
Igor,
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
On Sun, Jun 20, 2010 at 4:52 PM, P Kishor punk.k...@gmail.com wrote:
No. WHERE clause is a completely different part of the statement,
different from WHEN which is a part of the CASE construct. CASE..
WHEN .. THEN .. ELSE .. END is one construct, an expression, and
applies to the columns,
I am getting some strange behavior out of my app, which happens to be
both an Apache module and some Axis2/C Web Services which run under
Apache. From time to time, it is VERY inconsistent, when the code
calls sqlite3_close() the Apache server crashes. I don't recall the
error right off.
From
On Sun, Jun 20, 2010 at 5:23 PM, Igor Tandetnik itandet...@mvps.org wrote:
In what way did the statement I gave you, exactly as written, fail to satisfy
your requirements?
Igor,
When I put in EXACTLY what you gave me:
SELECT FolderId, ImageId, instertedon FROM V_FAVORITES_SELECTED
WHERE
-circuiting the query.
Sam
On Sun, Jun 20, 2010 at 6:02 PM, Simon Slavin slav...@bigfraud.org wrote:
On 20 Jun 2010, at 10:40pm, Sam Carleton wrote:
I am getting the EXACT same result, it calls findImage on for EVERY
row in the result set. The goal is to have the findImage()
short-circuit
On Jun 20, 2010, at 7:33 PM, Roger Binns rog...@rogerbinns.com wrote:
That is bad advice! The return code of open is irrelevant. If ppDb
is set
to non-NULL then you need to call sqlite3_close on it. ppDb will
almost
always be set to something. One example of when it is not is if
1 - 100 of 183 matches
Mail list logo