[sqlite] REQ: How do I change one character in a field value for another
Hi All, I need to change all occurances of a character in a field to another character, as I dont use sqlite very often, I can select the records but cannot work out how to code the change character part. Can anyone help? I need to cange all occurences of ~ (tilde) to - (dash) the select statement is thus: select OperatorFlagCode from Aircraft where OperatorFlagCode like '%~%' thanks in anticipation -- ¿¿¿ (ô ô) [EMAIL PROTECTED] ooO-(_)-Ooo http://www.westrowops.co.uk Wot! No SBS? IAT Boscombe Down Aircrew Transport 1989 RIAT Fairford Checklist Team 1990-2008 RAF Waddington Checklist Team 1995-2007 RNAS Yeovilton Checklist Team 2005,2007 ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] Newby Question
Hi All, I'm trying to learn SQLITE from a book and am making slow progress. My question is, in the following TRIGGER how do I tell it to only update the single record that the field Interested was updated? its a logical field either TRUE of FALSE, I want the trigger to work when the Field is TRUE. *create trigger* sbslogger* after update of *Interested* on *Aircraft * begin update *Aircraft* set *UserString1 *= Registration; update *Aircraft *set *UserString2* = 'PAGANHILL SBS'; update *Aircraft* set *UserString3* = current_date; end; *the above works, but of course does the whole table ! and I am now stuck! thanks in anticipation ** -- ¿¿¿ (ô ô) [EMAIL PROTECTED] ooO-(_)-Ooo http://www.westrowops.co.uk Wot! No SBS?
[sqlite] NEWBY Question: What would be the best way to get data from a DBF4 database to a SQLite SQB?
Hi All, I am a newcomer to SQLite and would like to know the best way to get data from my DBF4 database to a SQLite SQb. I need to do this because SQLite is used by a USB Device I recently purchased. I am at hobby level for DBF4 but have no exposure to SQLite before. TIA Sorry if this is a repeat message, I am not sure if the first request reached this list. -- ¿¿¿ (ô ô) [EMAIL PROTECTED] ooO-(_)-Ooo http://www.westrowops.co.uk - To unsubscribe, send email to [EMAIL PROTECTED] -