[sqlite] SQL query help...

Hi All, I need a little help in constructing a SQLite query.. Here's what I have so far that works... select name, substr(name,1,length(name)-3) as zone, substr(name,length(name)-2,2) as location, max(thick) - min(thick) as diff from plypoint group by zone,location The above properly

Re: [sqlite] SQL query help...

- Original Message - From: "Trey Mack" <[EMAIL PROTECTED]> To: Sent: Friday, June 08, 2007 1:08 PM Subject: Re: [sqlite] SQL query help... Here's what I tried, which didn't work... select name, substr(name,1,length(name)-3) as zone,

[sqlite] SQL query help

Hi All, I have a table which contains (among other things), a "name" column and a "version" column (a software asset table). I need a query that will group all like "names" together in a single record, and return the latest "version" (the largest value) for each group. What I have so far is

[sqlite] SQL query help

Not seeing this on the list 1.5 hrs after posting, I thought I'd try again. Sorry if this is a duplicate... Jeff = Hi All, I have a table which contains (among other things), a "name" column and a "version" column (a software asset table). I need a query that will group all like

Re: [sqlite] Re: SQL query help

- Original Message - From: "Igor Tandetnik" <[EMAIL PROTECTED]> To: "SQLite" <sqlite-users@sqlite.org> Sent: Monday, June 18, 2007 1:17 PM Subject: [sqlite] Re: SQL query help Jeff Godfrey <[EMAIL PROTECTED]> wrote: I have a table which

Re: [sqlite] SQL query help

- Original Message - From: "P Kishor" <[EMAIL PROTECTED]> To: <sqlite-users@sqlite.org> Sent: Monday, June 18, 2007 2:55 PM Subject: Re: [sqlite] SQL query help On 6/18/07, Jeff Godfrey <[EMAIL PROTECTED]> wrote: I have a table which contains (among ot

Re: [sqlite] Tcl and BLOB data

he sources before, and don't really have the time to work through the details right now. Thank you. Jeff Godfrey - Original Message - From: <[EMAIL PROTECTED]> To: <sqlite-users@sqlite.org> Sent: Tuesday, June 19, 2007 12:17 PM Subject: Re: [sqlite] Tcl and BLOB data

Re: [sqlite] Tcl and BLOB data

- Original Message - From: <[EMAIL PROTECTED]> To: Sent: Tuesday, June 19, 2007 3:43 PM Subject: Re: [sqlite] Tcl and BLOB data I did this change at your request, because it seemed like a good enhancement. Thanks. I agree, it sounds like a good

Re: [sqlite] Tcl and BLOB data

Very informative. Thank you. Jeff - Original Message - From: <[EMAIL PROTECTED]> To: <sqlite-users@sqlite.org> Sent: Tuesday, June 19, 2007 8:59 PM Subject: Re: [sqlite] Tcl and BLOB data "Jeff Godfrey" <[EMAIL PROTECTED]> wrote: I don't really unde

[sqlite] SQL query assistance...

Hi All, Given the following sample data... ID Name Version --- - --- 1 name1 0.9 2 name1 1.0 3 name2 1.2 4 name3 1.0 5 name3 1.7 6 name3 1.5 I need to create a query that will group the data together by Name, but for each group will return the record with the

Re: [sqlite] SQL query assistance...

- Original Message - From: "Gerry Snyder" <[EMAIL PROTECTED]> To: <sqlite-users@sqlite.org> Sent: Sunday, July 01, 2007 4:40 PM Subject: Re: [sqlite] SQL query assistance... Jeff Godfrey wrote: Hi All, Given the following sample data... ID Name Versi

Re: [sqlite] SQL query assistance...

- Original Message - From: "Andrew Finkenstadt" <[EMAIL PROTECTED]> To: <sqlite-users@sqlite.org> Sent: Sunday, July 01, 2007 4:45 PM Subject: Re: [sqlite] SQL query assistance... On 7/1/07, Jeff Godfrey <[EMAIL PROTECTED]> wrote: Hi All, Given the

Re: [sqlite] SQL query assistance...

- Original Message - From: "Dan Kennedy" <[EMAIL PROTECTED]> To: <sqlite-users@sqlite.org> Sent: Monday, July 02, 2007 4:17 AM Subject: Re: [sqlite] SQL query assistance... On Sun, 2007-07-01 at 16:31 -0500, Jeff Godfrey wrote: Hi All, Given the following sa

Re: [sqlite] Multi-User confusion

Joe Wilson wrote: If your database storage device cannot guarantee an exclusive file lock, then any database write can potentially result in corruption. If you control all SQLite clients' code, you could recompile sqlite to use the file-based dotlockLockingStyle convention via

Re: [sqlite] Multi-User confusion

[EMAIL PROTECTED] wrote: You may have a look at the dhRCPServer at: http://www.thecommon.net/2.html I am not using it, but it sounds it may do the job. RBS Bart, Thanks for the pointer. It does sound quite interesting, though I don't know if it can (easily?) be used from within a

Re: [sqlite] Multi-User confusion

Joe Wilson wrote: --- Jeff Godfrey <[EMAIL PROTECTED]> wrote: Can you (or anyone else) point me to some web-based information? http://www.sqlite.org/cvstrac/fileview?f=sqlite/src/os_unix.c=1.165 Joe, Thanks for the pointer. I should have mentioned, my application is r

[sqlite] Mathematical "power" operator?

on my specific issue with the missing mathematical operator? 2. More generally, do people who "add" functions to SQLite just not use 3rd party tools to work with their data? Thanks for any insight... Jeff Godfrey

Re: [sqlite] Is there a method for doing bulk insertion?

Take a look at the ".separator" command. It seems to be what you need... Jeff - Original Message - From: "Anderson, James H (IT)" <[EMAIL PROTECTED]> To: Sent: Tuesday, December 19, 2006 2:52 PM Subject: RE: [sqlite] Is there a method for doing bulk

Re: [sqlite] Mathematical "power" operator?

e a 3rd party SQLite management tool C. Something else I haven't thought of? Thanks for any additional guidance. Jeff Godfrey - Original Message - From: "jt" <[EMAIL PROTECTED]> To: <sqlite-users@sqlite.org> Sent: Wednesday, December 20, 2006 9:23 AM Subject: Re: [sq

Re: [sqlite] Mathematical "power" operator?

All, Thanks for the interesting responses. I think I now have a clear understanding of my options, and while not exactly what I was looking for, I can work within the prescribed limitations. As I mentioned, I am working from Tcl, where it's quite easy to write and register a new function

Re: [sqlite] Mathematical "power" operator?

- Original Message - From: "Nuno Lucas" <[EMAIL PROTECTED]> To: Sent: Thursday, December 21, 2006 5:45 PM Subject: Re: [sqlite] Mathematical "power" operator? Just wanted to add that if one of the sqlite GUI's out there uses an external sqlite dll (instead of

[sqlite] Creating a view on an ATTACHed database

Hi All, I have an open sqlite3 database (name = dbSerial), to which I've attached a 2nd database (name = dbParent). Now, I'm trying to create a view by joining a view from dbSerial with another view from dbParent. Attempting to create the view generates the following error: Error: view

Re: [sqlite] Creating a view on an ATTACHed database

From: <[EMAIL PROTECTED]> "Jeff Godfrey" <[EMAIL PROTECTED]> wrote: So, is it not possible to create a view across a "main" and an "attached" database? If I recall, you can create a TEMP VIEW across attached databases. Thanks for the tip.

[sqlite] sqlite core function question

I'm currently converting some Access tables/views to SQLite. I've encountered some functions that apparently aren't supported by SQLite, so I've created my own (a power function and an "IIF" function). Also, several of my queries have a basic int() wrapper, that also seems to be unsupported.

Re: [sqlite] sqlite core function question

From: <[EMAIL PROTECTED]> I'm not sure what "int()" does. Maybe you are looking for round(). Or perhaps cast(expr AS int) will serve your needs. Sorry, I should have been clearer. INT just forces the result to be an integer. So, your "cast" example is probably what I need. Thanks for

Re: [sqlite] sqlite core function question

From: "T" <[EMAIL PROTECTED]> Hi Jeff, I've encountered some functions that apparently aren't supported by SQLite So have I, such as replacing occurrences of an inner string. so I've created my own I've yet to figure out/try that. Is there a library somewhere of prebuilt functions we

[sqlite] Sqlite - tcl "trace" method

Hi All, I'm working on a tcl/sqlite based app. For the first time, I just registered a callback with the trace method so I could "see" all of my SQL interactions as they happen. While it does work as advertised, it seems to output each SQL statement prior to having resolved any variables

Re: [sqlite] "select into" ?

- Original Message - From: "Anderson, James H (IT)" <[EMAIL PROTECTED]> Sybase supports "select into" but sqllite does not seem to. Here's a sybase example: select distinct CDId, CDEvent into credDerivEvent from credDerivOrig This query creates the table credDerivEvent. Is there

Re: [sqlite] Another sybase conversion question

- Original Message - From: "Rich Shepard" <[EMAIL PROTECTED]> But, if you're going to do much with SQLite, I strongly recommend Mike Owens' "The Definitive Guide to SQLite" by Apress. The index is shamefully bad, but the book is a gem and has been a great help to me. Very highly

Re: [sqlite] SQLite in Adobe Lightroom

- Original Message - From: <[EMAIL PROTECTED]> To: <sqlite-users@sqlite.org> Sent: Thursday, February 22, 2007 6:37 AM Subject: Re: [sqlite] SQLite in Adobe Lightroom "Jeff Godfrey" <[EMAIL PROTECTED]> wrote: > Though it's only a matter of curiosity,

Re: [sqlite] SQLite in Adobe Lightroom

- Original Message - From: "Eric Scouten" <[EMAIL PROTECTED]> To: Sent: Thursday, February 22, 2007 10:55 AM Subject: Re: [sqlite] SQLite in Adobe Lightroom As the Adobe engineer who did much of the work to embed SQLite into Lightroom, I do want to express a

[sqlite] sqlite / tcl syntax help

Hi All, I'm trying to determine the datatype of a given column using Tcl and the following code snippet... set dataType [$db onecolumn "select typeof($colName) from $table"] This works correctly as long as $colName (the name of the current column) doesn't contain a space. When the column

[sqlite] Re: sqlite / tcl syntax help

> So, how can I get the correct column types returned for all > columns, while at the same time properly handle column > names containing spaces? > Thanks for any insight. > Jeff Answering my own post, I just found that the following works as expected... set dataType [$db onecolumn "select

Re: [sqlite] sqlite / tcl syntax help

- Original Message - From: "Michael Schlenker" <[EMAIL PROTECTED]> set dataType [$db onecolumn {select typeof($colName) from $table}] should do what you want. Note the {} instead of the "", which prevent early substitution, so sqlite can use the $colName as a bind variable.

Re: [sqlite] Re: sqlite / tcl syntax help

Michael / Richard / Dennis, Thanks for the additional input. Problem fixed... Jeff - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] What is wrong with this simple query (offset)?

- Original Message - From: "RB Smissaert" <[EMAIL PROTECTED]> To: Sent: Tuesday, March 06, 2007 1:39 PM Subject: [sqlite] What is wrong with this simple query (offset)? Why does this query give a syntax error near offset? SELECT Name FROM SQLITE_MASTER WHERE

[sqlite] Upgrade from 3.4.2 to 3.5.9 breaks Tcl code

and replacing "distinct(owner) with just "*" works correctly, though neither obviously does what I need. Is this an intended change to SQLite Tcl bindings, a bug, or just something else I'm missing? Thanks for any insight. Jeff Godfrey ___

Re: [sqlite] Upgrade from 3.4.2 to 3.5.9 breaks Tcl code

D. Richard Hipp wrote: > On Jun 12, 2008, at 11:08 PM, Jeff Godfrey wrote: > >> dbMem eval {select distinct(owner) from lockinfo order by owner} { >> >> } >> >> That works correctly in my original app using 3.4.2, but complains >> that >> th

Re: [sqlite] Upgrade from 3.4.2 to 3.5.9 breaks Tcl code

D. Richard Hipp wrote: > On Jun 13, 2008, at 12:22 AM, Jeff Godfrey wrote: > >> Thanks for the quick solution. I've adjusted my code accordingly. >> So, >> do you consider this a buglet or more just the closing of a gap that >> shouldn't have existed in the fi

[sqlite] Grabbing a record from an "in-use" database via a second process...

Hi All, I'm writing a Tcl-based application that manages a pool of separate SQLite database files. The application is multi-User, but it requires each User to "check out" a specific database in order to access it, so a single database is only ever accessed by a single User That is, until

Re: [sqlite] best language match for SQLite?

Patrick wrote: > I was just wondering if anyone had an opinion on the most ideal language > to use with SQLite? > > I love Python but I LOVE SQLite, I would learn another language just to > use it better-Patrick > According to a paper written by Richard Hipp (the creator of SQLite), Tcl is

[sqlite] seeking storage design assistance

Hi All, I've got some general db storage design questions that I hope someone can offer some advice on... I have a need to store some CAD-type geometry in a SQLite database, and I'm trying to decide on the best db design. Specifically, I need to store "entity" data, which will include such

Re: [sqlite] seeking storage design assistance

Jeffrey Becker wrote: > ORM is always a tricky business. My experience is that unless the > entity is very very simple, it's often inappropriate to attempt to do > 1 row = 1 entity mapping. If things are collections of points, then > by all means have a points table. A lot of this type of stuff

Re: [sqlite] seeking storage design assistance

Stephen Woodbridge wrote: > It also helps to know how you want to access/manipulate your data and > what you want to do with it in SQL versus with your application. For > instance, you could just store all the cad data as a blob, along with > the attributes in columns. Steve, Hmmm... That's an

Re: [sqlite] Which TCL distrabution for Windows XP for running SQLite tests?

Brown, Daniel wrote: > Good afternoon list, > > If I would like to use the TCL based tests on my version of SQLite on > Windows XP what would be the recommend TCL distribution to use? Would > ActiveTCL (http://tinyurl.com/5wl6uv) be compatible with the SQLite TCL > scripts on Windows XP? > >

[sqlite] Convert byte-array to in-memory DB?

e to disk" step if possible. Ideally, I'd like access the already-in-memory byte array as the in-memory SQLite db. Is that at all possible? I assume no, but thought I'd ask. Thanks for any input. Jeff Godfrey ___ sqlite-users mailing list sqlite-u

Re: [sqlite] Convert byte-array to in-memory DB?

Joe, Thanks for the response, and sorry for not being clear on my work flow. Ultimately, I want to access a standard SQLite database "in-memory". Starting with a disk-based SQLite database, I can easily replicate it into a memory-based database and access it from there. That's not a