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?
