Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys,
I've n table, with n from 1 to 10, every table contains the same field:
and I would make this action in this order:
id_cod and data and status aren't loaded before (note: and like logical operator)
I would repeat the second point from 2-table to n-table.
Furthermore sometimes there may be an error, and the value of field status inside a triple could be '-'
for example: x234y, -, 04/2017
so if so it is happened and in the next table I find the right triple
for example: x234y, active, 04/2017
I would delete the old triple and add the new.
Is this possible?
I hope I have been clear
Thank you!!!
what if the earlier table had the row
for example: x234y, active, 04/2017
and in the next table
for example: x234y, -, 04/2017
What then ?
at the second step should be the check, on your example
id_code | status | date |
---|---|---|
x234y | - | 04/2017 |
false (there is) | true (there isn't) | false (there is) |
so the triple should be discarded