Re: [sqlite] Eficiency : 1 table vs several tables

Old school database Mapper worked along that line, you had a ton of small tables and a lookup table that told your queries what table to look in...all in all it was a mess. -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of

Re: [sqlite] What this function returns?

Lol so call you igor? -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of John McKown Sent: Friday, November 29, 2013 8:10 PM To: rsm...@rsweb.co.za; General Discussion of SQLite Database Subject: Re: [sqlite] What this function

Re: [sqlite] Interruption

look at teh trigger functions. --- On Fri, 6/6/08, Hildemaro Carrasquel [EMAIL PROTECTED] wrote: From: Hildemaro Carrasquel [EMAIL PROTECTED] Subject: [sqlite] Interruption To: sqlite-users@sqlite.org Date: Friday, June 6, 2008, 2:17 AM Hello.- Is there any function that i can make event when

[sqlite] Date Selection

I have a table with a date column. I want to select * from TableA where DateCol Between '2008-06-10' and '2008-06-11'; when i execute that query i get 0 records. when i remove the date selection i get all teh records. what is the best way to query on date? thanks Woody

Re: [sqlite] Date Selection

: [sqlite] Date Selection To: sqlite-users@sqlite.org Date: Wednesday, June 11, 2008, 10:45 PM "Harold Wood" [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] I have a table with a date column.nbsp; I want to select * from TableA where DateCol Between '2008-06-10' and '2008-06-11';n

Re: [sqlite] Date Selection

thanks. --- On Thu, 6/12/08, Igor Tandetnik [EMAIL PROTECTED] wrote: From: Igor Tandetnik [EMAIL PROTECTED] Subject: Re: [sqlite] Date Selection To: sqlite-users@sqlite.org Date: Thursday, June 12, 2008, 7:51 AM "Harold Wood" [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED]

[sqlite] help with Dates please

I have several tables that i need to datestamp as transactions occur and then retrive with a select where between X and Y. What is the best way to do this in SQLite? Thanks Woody ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] Multiple constraints per table?

your main issue seems to be that you really need to normalize your db.  using your example of pepper 220 gr, when you examine that string it consists of 3 parts, pepper = product description or product name, 220 = weight or volume or measurement of product, followed by the measurement type. All

Re: [sqlite] Fuzzy Matching

I cant go into too much detail because of my current job, but for fuzzy matching levenstien isnt very good, you need to try looking into ngram matching techniques, it is absolutely awesome in reducing over/under matches.   Woody --- On Sat, 7/5/08, Stephen Woodbridge <[EMAIL PROTECTED]> wrote:

Re: [sqlite] Bad UPDATE Problems in Mobile6 device

also that query will update all rows in the commentlist table.  is that what you want to do?   Woody --- On Mon, 7/7/08, Stephen Oberholtzer <[EMAIL PROTECTED]> wrote: From: Stephen Oberholtzer <[EMAIL PROTECTED]> Subject: Re: [sqlite] Bad UPDATE Problems in Mobile6 device To: "General

Re: [sqlite] Bad UPDATE Problems in Mobile6 device

similar statements work fine on my pda, ipaq 210 with min mobile6.  can you paste your code? --- On Tue, 7/8/08, Bob Dennis <[EMAIL PROTECTED]> wrote: From: Bob Dennis <[EMAIL PROTECTED]> Subject: Re: [sqlite] Bad UPDATE Problems in Mobile6 device To: sqlite-users@sqlite.org Date: Tuesday, July

Re: [sqlite] View with Dynamic Fields ?

my approah would be a table for applicants, then the table for answers would have the applicantid and the questionid as well as the answer.   CREATE TABLE tblApplicants (applicantid int, applicantname varchar(100));   now just do a select joining the tables   select ap.applicantname, qu.question,

Re: [sqlite] View with Dynamic Fields ?

if sqlite supported the pivot command   Woody --- On Tue, 7/8/08, Andrea Connell <[EMAIL PROTECTED]> wrote: From: Andrea Connell <[EMAIL PROTECTED]> Subject: Re: [sqlite] View with Dynamic Fields ? To: "General Discussion of SQLite Database" Date: Tuesday, July 8,

Re: [sqlite] ANN: SQLite .NET provider updated

very very cool!  now does it work with teh compact framework? --- On Wed, 7/16/08, Robert Simpson <[EMAIL PROTECTED]> wrote: From: Robert Simpson <[EMAIL PROTECTED]> Subject: [sqlite] ANN: SQLite .NET provider updated To: "'General Discussion of SQLite Database'" Date:

Re: [sqlite] ANN: SQLite .NET provider updated

ider updated To: "'General Discussion of SQLite Database'" <sqlite-users@sqlite.org> Date: Wednesday, July 16, 2008, 10:27 PM Sure does! -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Harold Wood Sent: Wednesday, July 16, 2008 7:20 PM To:

Re: [sqlite] Ultimate noob question: What do I do to reference another table?

you need several tables, then you can refernce them thru a view to show what is related to what. --- On Fri, 7/18/08, LMcLain <[EMAIL PROTECTED]> wrote: From: LMcLain <[EMAIL PROTECTED]> Subject: [sqlite] Ultimate noob question: What do I do to reference another table? To:

Re: [sqlite] Return a rowset from function?

yes there is.   embed the sql in a table then execute it as needed passing the appropriate parms. Woody --- On Fri, 7/25/08, Robert Simpson <[EMAIL PROTECTED]> wrote: From: Robert Simpson <[EMAIL PROTECTED]> Subject: Re: [sqlite] Return a rowset from function? To: "'General Discussion of

Re: [sqlite] text datatype matching functions, binding vs explicit insert

lt;[EMAIL PROTECTED]> Subject: Re: [sqlite] text datatype matching functions, binding vs explicit insert To: "General Discussion of SQLite Database" <sqlite-users@sqlite.org> Date: Friday, July 25, 2008, 7:50 PM On Jul 25, 2008, at 7:44 PM, Harold Wood & Meyuni Gani wro

Re: [sqlite] Visual Basic Programming to SQlite

Dim Records Dim Database dim Recs AddObject "newObjects.sqlite3.dbutf8", "Db" set Database = Db 'Open the database On Error resume next If DataBase.Open(Get_Database_Name) Then DataBase.AutoType = True DataBase.TypeInfoLevel = 4 Else MsgBox "ERROR ON OPEN OF DATABASE: " &

Re: [sqlite] Multi column ORDER BY across table peformance problem....

just curious; have you tried doing the select in a subquery, and then the order by in the outer query?   woody --- On Fri, 4/17/09, sorka wrote: From: sorka Subject: [sqlite] Multi column ORDER BY across table peformance problem To:

Re: [sqlite] Multi column ORDER BY across table peformance problem....

did you try the subquery method i suggested?   Woody --- On Tue, 4/21/09, sorka wrote: From: sorka Subject: Re: [sqlite] Multi column ORDER BY across table peformance problem To: sqlite-users@sqlite.org Date: Tuesday, April 21, 2009, 8:48 PM

Re: [sqlite] Multi column ORDER BY across table peformance problem....

send me your original query please.   thanks   Woody --- On Tue, 4/21/09, sorka wrote: From: sorka Subject: Re: [sqlite] Multi column ORDER BY across table peformance problem To: sqlite-users@sqlite.org Date: Tuesday, April 21, 2009, 9:29 PM No.

Re: [sqlite] Multi column ORDER BY across table peformance problem....

try this   select showing.startTime, from (  SELECT showing.startTime,    channel.ChannelMajorNumber   FROM showing   JOIN channel    on showing.stationId = channel.stationId   Where showing.startTime >=  123923) ORDER BY showing.startTime, channel.ChannelMajorNumber LIMIT 8;       --- On

Re: [sqlite] Multi column ORDER BY across table peformance problem....

sorry.  Ive had good results with subqueries in resolving similar performance issues. --- On Tue, 4/21/09, sorka wrote: From: sorka Subject: Re: [sqlite] Multi column ORDER BY across table peformance problem To: sqlite-users@sqlite.org Date:

Re: [sqlite] Multi column ORDER BY across table peformance problem....

how about   select Starttime  from channel C  inner join (select showing.startTime AS startTime,     showing.stationId AS stationId     FROM showing    WHERE showing.startTime >= 123923      ORDER BY showing.startTime

Re: [sqlite] 2 columns as primary key?

create table tablename (     colname1 coltype,     colname2 coltype,     colname3 coltype,     PRIMARY KEY(colname1 asc, colname2 asc) ) --- On Fri, 5/29/09, Pavel Ivanov wrote: From: Pavel Ivanov Subject: Re: [sqlite] 2 columns as

Re: [sqlite] how to compose the sql sentence?

look up the insert or replace statement, http://www.sqlite.org/lang_insert.html --- On Wed, 6/3/09, liubin liu <7101...@sina.com> wrote: From: liubin liu <7101...@sina.com> Subject: [sqlite] how to compose the sql sentence? To: sqlite-users@sqlite.org Date: Wednesday, June 3, 2009, 2:05 AM

Re: [sqlite] how can we solve IF EXIST in SQLite

you should use the insert or replace statement, it inserts if the row doesnt exist, if teh row does exists then it updates the row. --- On Wed, 6/3/09, robinsmathew wrote: From: robinsmathew Subject: Re: [sqlite] how can we solve IF EXIST

Re: [sqlite] Db design question (so. like a tree)

just curious. why not a table for stricty for the linkages   structure similar to   create table Linkages (     Parent_Id int,     Child_Id  int     PRIMARY KEY (Parent_Id, Child_Id))   This would allow a lot of flexability in the parenting, you could have (A:B), (A:C), (B:D), (B:E), (B:F),

Re: [sqlite] how can we solve IF EXIST in SQLite

From: Kees Nuyt <k.n...@zonnet.nl> Subject: Re: [sqlite] how can we solve IF EXIST in SQLite To: sqlite-users@sqlite.org Date: Wednesday, June 3, 2009, 2:15 PM On Wed, 3 Jun 2009 00:42:53 -0700 (PDT), Harold Wood <hwoody2w...@yahoo.com> wrote: >you should use the insert

Re: [sqlite] how can we solve IF EXIST in SQLite

SQL does have branching logic.   (SELECT CASE WHEN ((SELECT StoreId From History WHERE ItemId = NEW.ID LIMIT 1) IS NULL) THEN  0 ELSE  (SELECT StoreId FROM History WHERE ItemId = NEW.ID AND UnitPrice = (SELECT MIN(UnitPrice) FROM HISTORY WHERE ItemId = NEW.ID)) END); i

Re: [sqlite] how to compose the sql sentence?

Well you have a column named data and a table named data, but the biggest issue is you only supplied 3 column names but in the values list you have 6 values.   --- On Thu, 6/4/09, liubin liu <7101...@sina.com> wrote: From: liubin liu <7101...@sina.com> Subject: Re: [sqlite] how to compose the

Re: [sqlite] Time format

try DATE('now','localtime') --- On Tue, 6/30/09, Goldstein, Ian wrote: From: Goldstein, Ian Subject: [sqlite] Time format To: sqlite-users@sqlite.org Date: Tuesday, June 30, 2009, 12:07 AM Hello, I am one day into sqlite and have

Re: [sqlite] CASE WHEN sample ?

Better would be Insert into tablea(ida, value1a) Select idb, value1b from tableb where idb not in(select ida from tablea); Woody from his pda -Original Message- From: Lothar Behrens <[EMAIL PROTECTED]> Sent: Saturday, May 10, 2008 2:23 PM To: sqlite-users@sqlite.org

Re: [sqlite] deleting 100,000 entries

Doesn't sqlite support the truncate table command Woody from his pda -Original Message- From: Carlo S. Marcelo <[EMAIL PROTECTED]> Sent: Tuesday, May 20, 2008 8:49 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] deleting 100,000 entries

Re: [sqlite] design question / discussion

I've done an app like that before with a different db foundation. Basically 2 different databases, same structure. The logging app hits an ini file before each write, if the current db is different than the name in the ini file then close the current db, open the new db and write the row to the

Re: [sqlite] Multiple constraints per table?

U, hmm. The tips I gave you were from my pda based shopping program that will be selling for 9.99 soon. Its 6 for one, half dozen for the other. You can design the db so it does the work for you or you code the program to do the work for you. Either way, you will get things to work, it

Re: [sqlite] Multiple constraints per table?

Lol. Thanks. If you want a schema I can attach and send to you. Woody from his pda -Original Message- From: flakpit <[EMAIL PROTECTED]> Sent: Tuesday, July 01, 2008 11:30 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Multiple constraints per table? Harold Wood Meyun

Re: [sqlite] Convert the CURRENT_TIMESTAMP

Look at the wiki for date/time functions, specifically strft. Woody from his pda -Original Message- From: Joanne Pham <[EMAIL PROTECTED]> Sent: Friday, July 25, 2008 4:08 PM To: General Discussion of SQLite Database ; [EMAIL PROTECTED] Subject: [sqlite] Convert

Re: [sqlite] text datatype matching functions, binding vs explicit insert

But you can use where 'AA' = upper(fld1) = to get around case issues. Woody from his pda -Original Message- From: D. Richard Hipp <[EMAIL PROTECTED]> Sent: Friday, July 25, 2008 3:11 PM To: [EMAIL PROTECTED]; General Discussion of SQLite Database Subject: Re:

Re: [sqlite] Does sqlite support stored procedure?

Can you send examples? Thanks Woody from his pda -Original Message- From: John Stanton <[EMAIL PROTECTED]> Sent: Tuesday, July 29, 2008 11:39 AM To: General Discussion of SQLite Database Subject: Re: [sqlite] Does sqlite support stored procedure? Adding

Re: [sqlite] Precompiled SQLite Binaries for WinCE

newobjects Woody from his pda -Original Message- From: Roger Binns <[EMAIL PROTECTED]> Sent: Sunday, August 17, 2008 2:00 AM To: General Discussion of SQLite Database Subject: Re: [sqlite] Precompiled SQLite Binaries for WinCE -BEGIN PGP SIGNED

Re: [sqlite] Getting last inserted rowid?

If you are inserting in order then selecting the max value from an indexed column should work. Harold Wood -Original Message- From: Nikolaus Rath <nikol...@rath.org> Sent: Wednesday, June 03, 2009 3:22 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Getting last inserted

Re: [sqlite] how can we solve IF EXIST in SQLite

procedures. Harold Wood & Meyuni Gani -Original Message- From: BareFeet <list@tandb.com.au> Sent: Wednesday, June 03, 2009 6:21 PM To: General Discussion of SQLite Database <sqlite-users@sqlite.org> Subject: Re: [sqlite] how can we solve IF EXIST in SQLite Hi Harold,

Re: [sqlite] Database logic in TRIGGER and CONFLICT, or in software ?

Very well said. Harold Wood & Meyuni Gani -Original Message- From: Jay A. Kreibich <j...@kreibi.ch> Sent: Sunday, June 14, 2009 8:44 PM To: General Discussion of SQLite Database <sqlite-users@sqlite.org> Subject: Re: [sqlite] Database logic in TRIGGER and CONFLICT, o

Re: [sqlite] Is there an easy way to concatenate 2 views ?

Concantenate or join? To concantenate use the Select * from a Union all Select * from b Only use * if columns all columns in a are identical to all columns in b, if not then build a column list and use that indtead of * Woody -Original Message- From: Stef Mientki

Re: [sqlite] Is there an easy way to concatenate 2 views ?

Yw, anytime. -Original Message- From: Stef Mientki <s.mien...@ru.nl> Sent: Saturday, July 25, 2009 4:16 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Is there an easy way to concatenate 2 views ? thanks Woody ( Harold ?), that works perfect. cheers, Stef Harold Wood &a

Re: [sqlite] controlling changes

You can do it as a constraint. -Original Message- From: David Bicking Sent: Saturday, October 10, 2009 9:08 AM To: sqlite-users@sqlite.org Subject: [sqlite] controlling changes I have a table: CREATE TABLE Assets ( ControlDate Date , Amt ) Now, the