Transfer records from one table to another and validate

eayvl · Post by **eayvl** » Mon Jun 12, 2017 6:24 am

Is it possible to transfer records from one table to another and validate if they already exist?

-The validation must be by name, nss and curp.

Table1
Filed (ID,name, nss, curp, rfc, birthdate, age, address)

Table2
Filed (ID,name, nss, curp, rfc, birthdate, age, address)

Thanks.

arbei · Post by **arbei** » Mon Jun 12, 2017 10:29 am

You can

use Conn()->Execute(<SQL>) to retrieve the records.
Use ew_ExecuteScalar(<SQL>) to validate the exists in the destination table with the SQL.
Use ew_Execute(<SQL>) to run the insert statement.

Read help file topic: "Server Events and Client Scripts" -> "Some Global Functions".