Re: [sqlite] How to calculate the size of my database for n records ?

value N times -- this is especially true if you have rows so big that they will go into overflow pages. HTH, John ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Aliased column can't use index outside of VIEWs?

T * FROM childparent WHERE child='albuquerque' AND parent='newmexico'; > > it's again very fast. I'm guessing again: subtly different logic when processing views. Cheers, John ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] fail to drop table in transaction

On 14/04/2009 12:21 PM, Wenton Thomas TOP-POSTED: > I have to drop the table,because I will use the same table name with > different table struct. Ever see those signs facing out from the end of a freeway exit: WRONG WAY! GO BACK! ? > > From: Kees Nuyt [snip]

Re: [sqlite] Problem with ordering

0 AND sourceMachine_id = 9 AND virtualClock <= 1000 AND parent_fk IS NOT NULL ); This may well run much faster. Bonus: it says exactly what I presume that you are trying to do, rather than relying on a side effect of ORDER BY and LIMIT used in conjunction. HTH, John ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] "extension-functions.c" in windows mobile

able to build it for windows > ce. Anybody can help me ? > DBMSs are for storing data and doing *elementary* calculations on the data. Why don't you do the calculation in VB? Cheers, John ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Datatypes on the command line: can you simply rely on quote()?

BLOB Contains only decimal digits, optionally preceded by - => integer Otherwise it's a float, and if it's not, it'd be fixed before you knew it. HTH, John ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Select statements in the context of transactions.

A TRANSACTION only has a meaning when the database is being altered. There are no journalling and commits on a read. You get the results of the SELECT as soon as the database read occurs. You cannot be faster than that. Where you can get improved SELECT performance is by using caching.

Re: [sqlite] Is it using an index?

On 7/04/2009 6:43 AM, Scott Baker wrote: [snip] > I must have typod and not noticed. Your hypothesis carries within itself the seed of its own plausibility :-) ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] General SQL question...

Igor Tandetnik wrote: > John Elrick <john.elr...@fenestra.com> wrote: > >> The following two queries appear to be functionally equivalent...that >> is to say the results they produce are identical. Is there any >> intrinsic advantage to one over the other? If

Re: [sqlite] Improving query performance

D. Richard Hipp wrote: > On Apr 1, 2009, at 2:00 PM, John Elrick wrote: > >> explain query plan >> select DISTINCT RESPONSES.RESPONSE_OID >> from DATA_ELEMENTS, RESPONSES, SEQUENCE_ELEMENTS >> where >> SEQUENCE_ELEMENTS.SEQUENCE_E

Re: [sqlite] Newbie what does & do.

index at the back of the book. If none, ask for a refund. "&" should be listed either under a "Symbols" (or similar) section before the letter "A", or under "operators". If not, ask for a refund. HTH, John ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Sqlite3 crashes when using the where command

On 26/03/2009 9:48 AM, JoeT wrote: > I am trying to run sqlite3 on Solaris 8. I have managed to compile it- and > install it. Basic read and write to a database works fine. However when I > use the where command or the delete command it crashes on me and says bus > error. It then does a core

Re: [sqlite] problems with shared cache?

On 25/03/2009 1:16 AM, Griggs, Donald wrote: > > > -Original Message- > > > On Sat, Mar 21, 2009 at 2:27 AM, Griggs, Donald > wrote: >>> However, when I ask the user to send me their deck, I find that: >>> >>> sqlite> pragma integrity_check;

Re: [sqlite] httpd server ???

processes with minimum overheads. Should you have an interest in examining or using all or part of this software contact me at jo...@viacognis.com and I can make a URLavailable. JS dcharno wrote: > John Stanton wrote: > >> I have an HTTP server wj\hich embeds Sqlite as well as a

Re: [sqlite] sqlite concat issue

On 19/03/2009 3:09 AM, Patnaik, Anjela wrote: > Hi John, > > Thanks for your response! Hi Anjela, I'm presuming that your off-list reply was accidental. > Now, the second column comes back as {} when I use sqlite TCL API. The TCL > llength is 1, instead of zero, probably d

Re: [sqlite] httpd server ???

I have an HTTP server wj\hich embeds Sqlite as well as a custom page generation language, and compiler and a remote procedure call interface for AJAX functionality and Javascript as an embedded scripting language. It runs on Unix/Linux and conditionally compiles for Windows. It uses a

Re: [sqlite] Passing FIELD Object To Function

one quoted #include line above doesn't appear to qualify your question as being "on-topic" for this mailing list ("General Discussion of SQLite Database <sqlite-users@sqlite.org>"). What forms package are you using? Does it

Re: [sqlite] concat two columns if 2nd non-empty and select first row

t;returned {}" means "returned NULL". (Anything || NULL) produces NULL. Examples: sqlite> select 'x' || NULL; sqlite> select coalesce('x' || NULL, 'zz'); zz Using coalesce in the Problem 1 solution above avoids this problem: sqlite> select 'x' || coales

Re: [sqlite] SQLITE : Constraint question

On 17/03/2009 9:02 AM, Wolfgang Enzinger wrote: >> Date: Sun, 15 Mar 2009 23:17:04 -0400 >> From: "Griggs, Donald" >> Subject: Re: [sqlite] SQLITE : Constraint question > >>> BTW, is there a document that explains in more detail what operations >>> the CHECK

Re: [sqlite] web page data scraping to sqlite db

On 17/03/2009 1:55 AM, d...@dommel.be wrote: > Hello, > > > I am working on a SQLite db with equity data in it. > On http://finance.yahoo.com/q?s=dow you can find the current P/E and Div & > Yield > fields. So I like to store in my db for name=DOW pe=12.25 and div=7.9 in a > automated way. > >

Re: [sqlite] datetime as integer

story) You are possibly thinking of Archbishop Ussher's creation estimate of 23 October 4004 BC. (http://en.wikipedia.org/wiki/Dating_Creation). Cheers, John ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] datetime as integer

ich on November 24, 4714 BC" - > presumably that's the beginning of time for Creationists ... > That would be October 23, 4004 BCE (according the the Bishop of Ussher). Noon, IIRC. I would assume using Radiometric dating as a starting point would be a tad unwieldy for d

Re: [sqlite] starting INTEGER PRIMARY KEY at 0

eed to write the first ROWID explicitly. There may be a gotcha with zero, otherwise why pick 1 for the default? What are you trying to achieve? If you are going to let the software choose your PK for you, why do you care what the starting value is? Cheers, John _

Re: [sqlite] Advices to get max performance with SQLITE and BLOBS

ression? You tell us. What percentage compression do you get with these 300KB BLOBs with (say) bz2? How long does it take to read in a bz2-compressed BLOB and uncompress it compared to reading in an uncompressed BLOB? Cheers, John ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] designing a db to hold repeating data

On 16/03/2009 11:45 AM, P Kishor wrote: > On Sun, Mar 15, 2009 at 7:29 PM, John Machin <sjmac...@lexicon.net> wrote: >> On 16/03/2009 11:00 AM, P Kishor wrote: >>> I have a grid of 1000 x 1000 cells with their own data as well as 20 >>> years of daily weather dat

Re: [sqlite] IP from number with SQL

tIP >> 16) & 255 AS text)||'.'|| ...> CAST((intIP >> 8) & 255 AS text)||'.'|| ...> CAST((intIP ) & 255 AS text) AS strIP ...> FROM IP_table; 1|12345678|0.188.97.78 2|9876543210123|143.217.130.139 sqlite> sqlite> SELECT rowid, intIP, ...> ((intIP

Re: [sqlite] Advices to get max performance with SQLITE and BLOBS

On 13/03/2009 11:24 PM, Mike Eggleston wrote: > On Fri, 13 Mar 2009, Pierre Chatelier might have said: > >> Hello, >> >> I am using SQLITE to store and retrieve raw data blocks that are >> basically ~300Ko. Each block has an int identifier, so that insert/ >> select are easy. This is a very

Re: [sqlite] LEFT INNER JOIN a second database

On 14/03/2009 9:45 PM, Derek Developer wrote: > To make it really easy, I have created three .sql files and an application > that is NOT command line akward. There are three .sql files with the > statements needed to create two databases and execute the outer join. > Drag and drop them onto the

Re: [sqlite] WHERE clause doesn't seem to work right

alphanumeric but which respects numeric sequencing: b a 300 30a 9 sorts as: 9 300 30a a b HTH John Elrick Fenestra Technologies ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] WHERE clause doesn't seem to work right

teger, the comparison should be done as a numeric comparison, in which case 3 is less than 100. HTH, John Elrick Fenestra Technologies ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] datetime as integer

On 12/03/2009 12:21 AM, Nicolás Solá wrote: > Hi I’m using Trac software and it is implemented using SQLITE3. In Trac DB > schema there is a table called “milestone”. It has a field called “due” and > it means due date. The problem is that it uses an integer data type to store > the datum and I

Re: [sqlite] LEFT INNER JOIN a second database

e http://www.sqlite.org/lang_attach.html HTH, John ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] nullable select fields

have multiple possibilities and combinations, my own preference would be to have a dynamically created SQL select statement. We do that for some of our more complicated object relationships. John Elrick Fenestra Technologies ___ sqlite-users mailing list s

Re: [sqlite] nullable select fields

"%" cursor.execute(sql, (qid, qtitle, qalbum)) BTW, the query optimiser can ignore column1 LIKE '%' only when column1 is declared as NOT NULL, so this way of doing it may not be the fastest :-( HTH, John ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] sqlite3 datbase disk image malformed

Your rsync command might be ignoring any journal files that may be outstanding. John On Fri, Mar 6, 2009 at 10:33 AM, Derrell Lipman <derrell.lip...@gmail.com>wrote: > On Thu, Mar 5, 2009 at 7:39 AM, Peter van Dijk <pe...@openpanel.com> > wrote: > > > On Thu, Mar 0

Re: [sqlite] change the limitation of attached databases through perl

e 30 attached databases one at a time? HTH, John ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Set read-only mode

On 8/03/2009 4:27 AM, P Kishor wrote: > On Sat, Mar 7, 2009 at 10:59 AM, Tom Spencer wrote: >> Is there a way to set the current database handle as read-only? I'm >> connecting to an SQLite3 database (actually two including an attached >> database) using Perl with

Re: [sqlite] import a CSV-File

, Perl surely, others ...) Cheers, John ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] which func could get the number of rows

On 6/03/2009 9:15 PM, liubin liu wrote: > which func could get the number of rows? select count(*) from your_table_name; ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] How to improve performance for some query statements

On 4/03/2009 2:48 PM, Peng Huang wrote: > On Wed, Mar 4, 2009 at 11:40 AM, John Machin <sjmac...@lexicon.net> wrote: > >> On 4/03/2009 2:12 PM, Peng Huang wrote: >>> Hi Igor Tandetnik, >>> >>> Thanks for your quick reply. >>> >>&g

Re: [sqlite] How to improve performance for some query statements

On 4/03/2009 2:12 PM, Peng Huang wrote: > Hi Igor Tandetnik, > > Thanks for your quick reply. > > Your solution works. But in some cases, each y%d may has two or three > choices. So the SQL will become very complex, we need ( 2 * 2 * 2 * 2) sub > where statements. Does SQLite have some build-in

Re: [sqlite] Slow performance with Sum function

On 4/03/2009 5:52 AM, Trainor, Chris wrote: > I am trying to use the Sum function on a column in a table with ~450K > rows in it. > > Select sum(Col4) from Table1 > > Where Table1 looks like this: > > Create TABLE Table1 ( > Col1 INTEGER NOT NULL, > Col2 INTEGER NOT NULL, >

Re: [sqlite] How do I do this join on multiple columns?

On 3/03/2009 12:48 PM, yaconsult wrote: > SQL newbie here. I have data in a couple of tables that I need to relate. > But I don't know how to relate on more than one column. I'll not go into > detail about why the data is formed the way it is - it comes from other > programs. > > For example,

Re: [sqlite] DateTime Objects

Look at the Sqlite sourcce code in the date function area and all, is revealed. jonwood wrote: > John Stanton-3 wrote: > >> Use the Sqlite date storage format and support. With that approach >> which is astronomivally correct you can deliver any date format or >>

Re: [sqlite] DateTime Objects

Use the Sqlite date storage format and support. With that approach which is astronomivally correct you can deliver any date format or manipulwtion, You may need some custom written functions. to get week number according to national rules etc, but the method is sound. It is also compatible

Re: [sqlite] sqlite3_mprintf - C/C++ formatting 64-bit values?

On 27/02/2009 12:09 PM, His Nerdship wrote: > Does anyone know the sqlite3_mprintf/sqlite3_vmprintf format specifier for > 64-bit integers? > I have tried %Ld and %I64d, but it just guillotines the string at that > point. > I am using Borland C++ Builder v6. > Thanks in advance. Guess: %lld (as

Re: [sqlite] problem reading in SQL file with To_Date from Oracle

AR2(50), > INTERFACE VARCHAR2(50), > OCRELEASE VARCHAR2(8), > RUNDATEDATE, > PRODUCTS VARCHAR2(255), > SERVER VARCHAR2(50), > REQUESTVARCHAR2(4000), > REQUEST2 VARCHAR2(4000), > RESPONSE CLOB > ) HTH, John _

Re: [sqlite] Maximum number of concurrent users

It is an embedded system, so the number of users depends on how it is used. Be aware that it is not a database server like Oracle or DB2, but is a library of routines to link into your application. Eversogood wrote: > Hi, > > What is the maximum number of concurrent users for SQLite? > >

Re: [sqlite] Indexing problem

On 26/02/2009 9:45 PM, John Machin wrote: > On 26/02/2009 8:23 PM, Marian Aldenhoevel wrote: >> Hi, >> >> I am having a strange problem with a sqlite3 database. See the following >> transcript: >> >> > sqlite3 kdb "select * from kfz where kfznr=484

Re: [sqlite] Indexing problem

On 26/02/2009 8:23 PM, Marian Aldenhoevel wrote: > Hi, > > I am having a strange problem with a sqlite3 database. See the following > transcript: > > > sqlite3 kdb "select * from kfz where kfznr=48482364;" > > 48482364|48|0|0C|00|00|0||20|5B93|1746294314|||0|GP-T 1006|0 > > kfznr is the

Re: [sqlite] meta-question: In what version did feature X first appear?

On 26/02/2009 11:55 AM, Roger Binns wrote: Hi Roger, > John Machin wrote: >> In >> that situation, the next question to arise would be "What other >> currently-documented features must I avoid?" > > The usual solution is for documentation for each API t

Re: [sqlite] Scrolling cursor with multiple keys...

John Elrick wrote: > I have a situation where I need to retrieve the 'next' item in a table > sorted by an arbitrary number of keys. My current planned solution is to > create a table for the sorting which is recreated as needed with the > appropriate keys. As a simplified exampl

[sqlite] meta-question: In what version did feature X first appear?

e some part of the site that I missed? In the replace() case, the OP was stuck with no upgrade capability. In that situation, the next question to arise would be "What other currently-documented features must I avoid?" Cheers, John ___ sqlite-us

[sqlite] Scrolling cursor with multiple keys...

h I have overlooked? Thanks, John Elrick Fenestra Technologies ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQL error: no such function: replace

> an alternative solution? Check your SQLite3 version. Latest release in 3.6.11. Latest I have is 3.6.10 which includes replace() However an old 3.3.6 command-line executable reproduces your problem. HTH, John ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Error on INSERT with SELECT Max(id) FROM ...

On 25/02/2009 11:34 AM, P Kishor wrote: > On Tue, Feb 24, 2009 at 6:12 PM, John Machin <sjmac...@lexicon.net> wrote: >> On 25/02/2009 10:30 AM, P Kishor wrote: >>> On Tue, Feb 24, 2009 at 5:19 PM, Leo Freitag <leofrei...@netcologne.de> >>> wrote: >

Re: [sqlite] Error on INSERT with SELECT Max(id) FROM ...

the parentheses: insert into 'tblRefMaxName' Values ((select max(text) from tblName)); GENERAL RULE: always wrap an inner select in parentheses, whether it's being used as an expression or as a join-source. HTH, John ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Error on INSERT with SELECT Max(id) FROM ...

On 25/02/2009 10:19 AM, Leo Freitag wrote: > Hallo, > > I'm trying to insert the highest value of tblName into tblZO. > > There fore I followed the hints in this article ... >

Re: [sqlite] Using result of subquery both as value and conditional test...

On 25/02/2009 6:15 AM, John Elrick wrote: > I may be overlooking something obvious, however, I cannot discern from > the documentation if this is possible. > > given a simple example: > > create table x (x_id integer); > create table y (y_id integer, y_value varchar); >

Re: [sqlite] Using result of subquery both as value and conditional test...

D. Richard Hipp wrote: > On Feb 24, 2009, at 2:15 PM, John Elrick wrote: > > SNIP >> >> Is there any way to eliminate the second (select y_value from y where >> y_id = x_id)? If so, what would the query look like? >> >> > > SELECT coalesce((

[sqlite] Using result of subquery both as value and conditional test...

, 'Hello world'); select case when (select y_value from y where y_id = x_id) is null then 'darn' else (select y_value from y where y_id = x_id) end from x Is there any way to eliminate the second (select y_value from y where y_id = x_id)? If so, what would the query look like? John Elrick

Re: [sqlite] Conditional expressions and evaluation

D. Richard Hipp wrote: > On Feb 23, 2009, at 1:39 PM, John Elrick wrote: > > >> A clarification question...given the query: >> >> create table x (x_id integer, f varchar); >> create table y (y_id integer, x_id integer, f varchar); >> >> insert into x

[sqlite] Conditional expressions and evaluation

y.f = 'foo' that the sub-select is considered "not needed" and therefore is not executed? John Elrick Fenestra Technologies ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Alpha numeric collation

> 10 > 51 > a Thanks very much for your assistance Simon. The first case may indeed work, the field is currently varchar but there is nothing preventing me from making it integer, and the second case gives me some insights I hadn't considered.

[sqlite] Alpha numeric collation

they were indeed numerics: 1 4 9 10 51 a Thanks for any feedback, including "nope, you have to roll your own". John Elrick Fenestra Technologies ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailma

Re: [sqlite] Newb-ish performance questions

rocessing time as well as disk space. > > interesting nonetheless, never used grep before...useful. Sure is. Cheers, John ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Newb-ish performance questions

ping? Other processes hogging the disk or the CPU? A really duff grep?? Anyway, here's my environment: 2.0 GHz single-core AMD Turion (64 bit but running 32-bit Windows XP SP3), using GNU grep 2.5.3 from the GnuWin32 project; 1 GB memory. Cheers, John ___

Re: [sqlite] Newb-ish performance questions

file.csv How long does that take? Another suggestion: search for clues on whether it might be better instead of doing select * from mytable where union all etc etc select * from mytable where to do select * from mytable where or or etc etc and if you don't find a strong we

Re: [sqlite] Double entry bookkeeping

BareFeet wrote: > Hi John, > >> You still miss the point of the cross reference ID. It is NOT the >> reference ID od the document, such as an invoice or check number, >> but it >> more like the row ID used by Sqlire as a unique key for a DB row. > &

Re: [sqlite] Double entry bookkeeping

On 20/02/2009 12:35 PM, BareFeet wrote: > Hi John (Machin), > > Thanks for the discussion. > >>> I understand that double entry bookkeeping traditionally uses the >>> redundancy as an error check, but that seems more appropriate for >>> manual pa

Re: [sqlite] Double entry bookkeeping

be changed or deleted, only added, and it should be possible mto prove that they cannot be changed. The locally assigned cross reference number tagging the transaction set can also be used as an audit tool to prove the absence of deletions. BareFeet wrote: > Hi John, > >> You still mi

Re: [sqlite] Any concept of row number in SQLite?

Use the Sqlite row id. His Nerdship wrote: > Hi, > I am converting a program from Paradox (stop laughing, please) to SQLite. > Paradox has a useful feature where you can specify the actual index of a row > in the table. This is handy when the table is displayed in a grid and you > want the

Re: [sqlite] Double entry bookkeeping

. The cost of that would be an extra row lookup each time you want to get the date of an accounting transaction. A performance and code complexity decision. As they say "you pays your money and you takes your choice". BareFeet wrote: > Hi John, > > Thanks again

Re: [sqlite] Double entry bookkeeping

On 20/02/2009 9:23 AM, BareFeet wrote: > Hi John, > > Thanks again for your discussion. > >> "Double Entry" book keeping is actually a misnomer. A transaction >> is very likely to have more than two entries. > > Yes, I realize that, though m

Re: [sqlite] Double entry bookkeeping

s. BareFeet wrote: > Hi John, > > Thanks for the input. > >> In general you need for one transaction - >> General Ledger account >> Date >> Reference ID >> Cross Reference >> Amount >> Optional narrative >> >> The Chart of Account

Re: [sqlite] Double entry bookkeeping

In general you need for one transaction - General Ledger account Date Reference ID Cross Reference Amount Optional narrative The Chart of Accounts defines full set of accounts and the details of each account. The G/L A/C indicates whether it is an asset or liability account (plus or minus) and

[sqlite] "analyze" command slow for large amounts of data; alternative possible?

in the wild. So my questions: 1) Will this work? 2) Is it "dangerous"? e.g. could this completely confuse the query optimiser, or is it the case that as long as the hard coded values are "realistic" it doesn't matter that they don't reflect the reality of the table (which is what

Re: [sqlite] Check for existence of substring in table

On 15/02/2009 9:15 PM, Ulrich Schöbel wrote: > John Machin wrote: >> all I know about Tcl is that I don't want to >> know any more about Tcl :-) > > You should want to ;-) You should want to be using Python instead of Tcl ;-) ___

Re: [sqlite] Check for existence of substring in table

1 from f where link = substr('xyzzy', 1, length(link))); 0 sqlite> You'll need to write the Tcl code to do that with your variable $x where I've got 'defend' etc ... all I know about Tcl is that I don't want to know any more about Tcl :-) HTH, John __

Re: [sqlite] Querying with dot commands using Perl DBD

On 10/02/2009 8:25 AM, Paulson, Ariel wrote: > Hi all, > > Does anyone know how grab the output of a dot command using DBD::SQLite? Here's a big fat hint: that's *not* what you really want to know; go for the helicopter view ... describe your *real* problem e.g. "I'd like to get the name of

Re: [sqlite] Question on missing Entry Point for Sqlite 3

"Ypu can lead a horse to water but you cannot make it drink" . W Allan Edwards wrote: > Hey... 640k memory ought to be enough for everyone! > > Maybe today, but historically > > I thought sqlite was originally designed and developed by Dr. Hipp so he > could learn database technology? (SQL

Re: [sqlite] Question on missing Entry Point for Sqlite 3

You do not appear to understand the intent of Sqlite. It is an open source software library which can be comiled to siuit unique application requirements. Decide what features you want to use and set the conditional compilation flags accordingly and com;pile it to all the platforms you

Re: [sqlite] Question on missing Entry Point for Sqlite 3

On 9/02/2009 2:47 PM, W Allan Edwards wrote: > > By preprocessor do you mean #define? I did a search in my sqlite.c file for > > SQLITE_ENABLE_COLUMN_METADATA.. then I #defined above them ALL! The usual way of doing such a thing is somewhat less intrusive and labour-intensive and easier to

Re: [sqlite] Delete, sometimes doesn't seem to work ...

On 8/02/2009 8:33 AM, Simon wrote: > Difficult to say for sure, but it's possible the Indx of 0 were > inserted with another type (ie, the string "0" and of course, 0 != > "0") If the column is declared as integer (as the OP said) you need to try harder than '0' ... not trimmimg leading/trailing

Re: [sqlite] Group by week

You need a function which gives the week number. Note that this is calculated differently in the USA and Europe., so you need to use the correct rules to write the function. Moshe Sharon wrote: > Hi > > How can I select group by week > > moshe >

Re: [sqlite] drop table question ?

On 4/02/2009 12:37 AM, Brad Stiles wrote: >>> For my own edification, why the "order by 1" clause? >> To sort them in ascending order of table name, which might make >> old-fashioned capers like visual scrutiny a little easier. > > OK then, why would one not use the column name? Maybe because

Re: [sqlite] drop table question ?

'drop table ' || name || ';' from sqlite_master where type = 'table' and name glob 'X[0-9][0-9][0-9][0-9]' order by 1; check it carefully feed it back in Note: GLOB lets you be more precise than LIKE. Precision when dropping tables is a Good Thing :-) HTH, John

[sqlite] unsubscribe

John Horton Megger Limited Archcliffe Road Dover Kent CT17 9EN England. T +44(0)1304-502100. (Switchboard) T +44(0)1304-502139. (Direct) F +44(0)1304-502306. E john.hor...@megger.com www.megger.com The information contained in this electronic mail message is confidential

Re: [sqlite] playing with sqlite3

On 31/01/2009 8:20 AM, Mike Eggleston wrote: > Wait. I ran the sqlite3 under script during lunch. I have the same > behavior. The script also captured the first line of output from killing > sqlite3. The output shows binary characters in an INSERT statement. The > bad line is (characters

Re: [sqlite] playing with sqlite3

c, get the character count and compare it with the file size from ls. And another thought, bit of a long shot, try running it without the "time" and "; date". Oh, and try running it with only the 3 lines that you cut out plus a couple more on the end. If th

Re: [sqlite] database encrypted

t; it's not a SQLite3 database. Telling us what's in that first 100 bytes (in a machine-readable unambiguous format) might be a good idea. E.g. if you have Python, do: print repr(open('fubar.db', 'rb').read(100)) Cheers, John ___ sqlite-users mai

Re: [sqlite] Adding Custom Column Data Types

We do thisby usig the Sqlite "Declared Type" (which can be anything you choose) and intercepting it in a layer of software between Sqlite and the application language manager. For example we have a decimal number type, a date type etc. The data is stored as Sqlite TEXT or FLOAT but the

Re: [sqlite] INNER JOIN, JOIN Confusin

ouldn't the WHERE clause be: WHERE S.SessionId = 6 ? If not, change your query to do SELECT S.*, T.* FROM etc etc also select the 52 from Temp and work out which one is missing -- maybe a value of Temp.Id is wrong (i.e. doesn't match up w

Re: [sqlite] SQLite not performing a certain update

On 26/01/2009 12:37 PM, John Machin wrote: > On 26/01/2009 12:17 PM, Rickard Westerlund wrote: >> In any case, I prepared an isolated test case which can be gotten from >> the link below. It contains source for the program as well as a >> prepared database that is s

Re: [sqlite] SQLite not performing a certain update

On 26/01/2009 12:17 PM, Rickard Westerlund wrote: > On Sun, Jan 25, 2009 at 12:12 AM, John Machin <sjmac...@lexicon.net> wrote: >> So SELECT has the same problem as UPDATE. That would suggest to me that >> the next step would be to try the following: >> >> (1) SE

Re: [sqlite] SQLite not performing a certain update

On 25/01/2009 7:45 AM, Onion Knight wrote: > On Fri, Jan 23, 2009 at 10:41 PM, John Machin <sjmac...@lexicon.net> wrote: >> Two suggestions: >> >> (A) Check to see if the corresponding SELECT works: >> >> "SELECT *, CASE WHEN lft BETWEEN ? AND ?"

[sqlite] codepages

dear users I use sqlite for vb6, utf-8 database, when insert arabic data to database and search it with 'like' operator (within % syntax), return all records!!! Please help me... thanks John Smith ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] SQLite not performing a certain update

.." not "... ELSE lft + ? END WHERE ..." The former case should just work, or (much less preferably) give an error return. However it's cheap to add a space and run it again to see if you've stumbled on a weird dark-corner-case bug. Try (A), (B) and (A+B) HTH, John _

Re: [sqlite] What is the advantage of using native c API over ODBC

You avoid an unecessary layer of software and have better control over the database. goldy wrote: > Hi All, > > What are the basic advantage of using SQLite with C API over ODBC. > ___ > sqlite-users mailing list > sqlite-users@sqlite.org >

Re: [sqlite] Effective way to use RTree to find the neighborhood ???

Dan's ... Dan's formula includes the case of a big rectangle that completely covers the window plus extra on each of the four sides, but the OP's formula doesn't include that case. By the way, we're all assuming a convention that x1 <= x2 and y1 <= y2, aren't we? HTH, John ___

<    6   7   8   9   10   11   12   13   14   15   >