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
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
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
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
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
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.
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 +
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
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
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
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
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
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
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,
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
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
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
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
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
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
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
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:
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
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
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
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 '
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
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
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
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
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
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,
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
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,
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
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
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:
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
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
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
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
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
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
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
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
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
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!
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
48 matches
Mail list logo
