Hi there, Is there a way to create a trigger in the attached sms.db for iPhone to update the "dr_date" column in the "message" table and subtract '58957200' from "dr_date" after receiving the delivery from the carrier smsc You see, my carrier sends me delivery date far ahead from the send date by '58957200' (UNIX time), so I wanted to see if I can create a trigger to handle this for me instead of me opening the database every time to edit the dr_date manually. Thank you in advance.
Zaid http://dl.dropbox.com/u/10002477/sms.db -- View this message in context: http://old.nabble.com/Trigger-to-update-a-column-in-sms.db-for-iPhone-tp32501075p32501075.html Sent from the SQLite mailing list archive at Nabble.com. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
