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
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
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
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
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,
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?
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
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
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:
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
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
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
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
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
15 matches
Mail list logo