Hello
Please, I want to display the sms field. After that, I want to update this field (sms). This action generates three actions:
1- After updating: a new record in mt Field would be inserted (which means that a new Transmitted Message is inserted after updating a text of SMS).
2- A value of Filter Field would changed into 0 (wich means that a new sms updating field would be enter to be filtered).
3- The value of nosent Field will change into 0 (Which means that after updating a text of SMS, this SMS is ready to be sent)
If the user clik the cancel button in update page, the value of nosent still be in 1.
Here's my table
CREATE TABLE IF NOT EXISTS sms2btv (
sms text NOT NULL,
tm text NOT NULL, --Transmetted Message ( A text after updating SMS text)
sent bit(0 or 1) NOT NULL,
filtre bit(0 or 1) NOT NULL,
error varchar(100) NOT NULL,
nosent bit(0 or 1) NOT NULL
);
Please, how can I manage this events, I need help urgently.
I would be very reconised
Thank you
Sincerely.
