A
|
ayctech 4/22/2019 |
I do not see it complicated, you would have to delete the record and insert in the other table
|
M
|
Mark Kramer 4/22/2019 |
Another option it to have a "Completed" integer field with a default of '0" in your table. (I use a check mark for this field.) |
S
|
stanbar1 author 4/23/2019 |
I do not see it complicated, you would have to delete the record and insert in the other table
|
S
|
stanbar1 author 4/23/2019 |
Another option it to have a "Completed" integer field with a default of '0" in your table. (I use a check mark for this field.) Then on your in sql code: for the page. SELECT FROM Your Table WHERE ( Completed = 0)*When they finish, they select the "Completed" check box then save and it will not show up as still being open when listed because the check box saves the numeral "1" to the field in the record. MK
|
M
|
Mark Kramer 4/25/2019 |
ok but i need this jobs record save on history table, for billing and other..can you please explain me how can i see this record when i need it
|
A
|
ayctech 4/30/2019 |
i add this code on event: after update..Nothing happen. maybe i did something wrong, please help me $sql = "delete from Jobs where id_Jobs= ".$values['id_Jobs']; CustomQuery($sql); $sql = "INSERT INTO History (id_Jobs, id_Confirmation,data_insercion) values ($id_Jobs, ".$values['id_Confirmation'].",'".$data_actual."')"; CustomQuery($sql);
|