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

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 <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] Is there an easy way to concatenate 2 views ?

2009-07-25 Thread Harold Wood &amp; 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

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

2009-06-15 Thread Harold Wood &amp; Meyuni Gani
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] how can we solve IF EXIST in SQLite

2009-06-03 Thread Harold Wood &amp; Meyuni Gani
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] Getting last inserted rowid?

2009-06-03 Thread Harold Wood &amp; 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?

Re: [sqlite] Precompiled SQLite Binaries for WinCE

2008-08-17 Thread Harold Wood &amp; 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

Re: [sqlite] Does sqlite support stored procedure?

2008-07-29 Thread Harold Wood &amp; 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

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

2008-07-25 Thread Harold Wood &amp; 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:

Re: [sqlite] Convert the CURRENT_TIMESTAMP

2008-07-25 Thread Harold Wood &amp; 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

Re: [sqlite] Multiple constraints per table?

2008-07-02 Thread Harold Wood &amp; 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 Meyun

Re: [sqlite] Multiple constraints per table?

2008-07-02 Thread Harold Wood &amp; 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

Re: [sqlite] design question / discussion

2008-05-21 Thread Harold Wood &amp; 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-21 Thread Harold Wood &amp; 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

Re: [sqlite] CASE WHEN sample ?

2008-05-10 Thread Harold Wood &amp; 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