Re: [sqlite] What this function returns?

2013-11-29 Thread Harold Wood
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

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

2013-11-29 Thread Harold Wood
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 Simon

Re: [sqlite] controlling changes

2009-10-10 Thread Harold Wood & Meyuni Gani
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 business rules are you can

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

2009-07-25 Thread Harold Wood & Meyuni Gani
Yw, anytime. -Original Message- From: Stef Mientki 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 & Meyuni Gani w

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

2009-07-25 Thread Harold Wood & Meyuni Gani
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 Sent: Saturday, July

Re: [sqlite] Time format

2009-06-29 Thread Harold Wood
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 probably a very simple problem involving datetime function.

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

2009-06-14 Thread Harold Wood & Meyuni Gani
Very well said. Harold Wood & Meyuni Gani -Original Message- From: Jay A. Kreibich Sent: Sunday, June 14, 2009 8:44 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] Database logic in TRIGGER and CONFLICT, or in software ? On Sat, Jun 13, 2009 at 11:42:21PM +

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

2009-06-04 Thread Harold Wood
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] how can we solve IF EXIST in SQLite

2009-06-03 Thread Harold Wood & Meyuni Gani
procedures. Harold Wood & Meyuni Gani -Original Message- From: BareFeet Sent: Wednesday, June 03, 2009 6:21 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] how can we solve IF EXIST in SQLite Hi Harold, > SQL does have branching logic. > > (SELECT CA

Re: [sqlite] Getting last inserted rowid?

2009-06-03 Thread Harold Wood & Meyuni Gani
If you are inserting in order then selecting the max value from an indexed column should work. Harold Wood -Original Message- From: Nikolaus Rath Sent: Wednesday, June 03, 2009 3:22 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Getting last inserted rowid? Nuno Lucas writes

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

2009-06-03 Thread Harold Wood
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 us

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

2009-06-03 Thread Harold Wood
: 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 wrote: >you should use the insert or replace statement, >it inserts if the row doesnt exist, if the row >does exist

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

2009-06-03 Thread Harold Wood
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), (E:G

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

2009-06-03 Thread Harold Wood
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 in SQLite To: sqlite-users@sqlite.org Date: Wednesday,

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

2009-06-02 Thread Harold Wood
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 th

Re: [sqlite] 2 columns as primary key?

2009-05-29 Thread Harold Wood
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 primary key? To: "General Discussion of SQLit

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

2009-04-21 Thread Harold Wood
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] Multi column ORDER BY across table peformance problem....

2009-04-21 Thread Harold Wood
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: Tuesday, April 21, 2009, 10:22 PM I can't think

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

2009-04-21 Thread Harold Wood
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....

2009-04-21 Thread Harold Wood
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. This can't be broken down into a query withi

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

2009-04-21 Thread Harold Wood
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 Wow. Anybody? I figured this would be a simple q

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

2009-04-17 Thread Harold Wood
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: sqlite-users@sqlite.org Date: Friday, April 17, 2009, 11:

Re: [sqlite] Visual Basic Programming to SQlite

2008-10-03 Thread Harold Wood
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: " & DataBase.last

Re: [sqlite] Precompiled SQLite Binaries for WinCE

2008-08-17 Thread Harold Wood & Meyuni Gani
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 MESSAGE- Hash: SHA1 [EMAIL PROTE

Re: [sqlite] Does sqlite support stored procedure?

2008-07-29 Thread Harold Wood & Meyuni Gani
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 Javascript to Sqlite as a stored

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

2008-07-25 Thread Harold Wood
lt;[EMAIL PROTECTED]> Subject: Re: [sqlite] text datatype matching functions, binding vs explicit insert To: "General Discussion of SQLite Database" Date: Friday, July 25, 2008, 7:50 PM On Jul 25, 2008, at 7:44 PM, Harold Wood & Meyuni Gani wrote: > But you can use where '

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

2008-07-25 Thread Harold Wood & Meyuni Gani
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: [sqlite] text datatype matc

Re: [sqlite] Convert the CURRENT_TIMESTAMP

2008-07-25 Thread Harold Wood & Meyuni Gani
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 the CURRENT_TIMESTAMP Hi

Re: [sqlite] Return a rowset from function?

2008-07-25 Thread Harold Wood
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 SQLite

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

2008-07-17 Thread Harold Wood
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: sqlite-users@sqlite.or

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

2008-07-16 Thread Harold Wood
r updated To: "'General Discussion of SQLite Database'" 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: General Discussion of SQLi

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

2008-07-16 Thread Harold Wood
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: Wednesday, July 16, 2008,

Re: [sqlite] View with Dynamic Fields ?

2008-07-08 Thread Harold Wood
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, 2008, 3:27 PM Thanks Chris

Re: [sqlite] View with Dynamic Fields ?

2008-07-08 Thread Harold Wood
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] Bad UPDATE Problems in Mobile6 device

2008-07-08 Thread Harold Wood
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] Bad UPDATE Problems in Mobile6 device

2008-07-07 Thread Harold Wood
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 Discussio

Re: [sqlite] Fuzzy Matching

2008-07-05 Thread Harold Wood
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] Multiple constraints per table?

2008-07-02 Thread Harold Wood & Meyuni Gani
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 & M

Re: [sqlite] Multiple constraints per table?

2008-07-01 Thread Harold Wood & Meyuni Gani
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 jus

Re: [sqlite] Multiple constraints per table?

2008-07-01 Thread Harold Wood
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

[sqlite] help with Dates please

2008-06-13 Thread Harold Wood
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 http://sqlite.o

Re: [sqlite] Date Selection

2008-06-12 Thread Harold Wood
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

Re: [sqlite] Date Selection

2008-06-11 Thread Harold Wood
Tandetnik <[EMAIL PROTECTED]> wrote: From: Igor Tandetnik <[EMAIL PROTECTED]> Subject: Re: [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 ta

[sqlite] Date Selection

2008-06-11 Thread Harold Wood
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] Interruption

2008-06-05 Thread Harold Wood
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 wh

Re: [sqlite] design question / discussion

2008-05-21 Thread Harold Wood & Meyuni Gani
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] deleting 100,000 entries

2008-05-20 Thread Harold Wood & Meyuni Gani
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 @Barefoot and Keith, Awesome!

Re: [sqlite] CASE WHEN sample ?

2008-05-10 Thread Harold Wood & Meyuni Gani
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 Subjec