Synchronization can run SQL code on the current or remote basis.

In the fields we fill in the name of the file containing the code.

Files that contain SQL are always stored in the folder

and in form

The prefix always comes in

and the ending

There is a possibility of multiple pieces of code that can be separated by “?”

Finally, to prevent time-consuming calls to SQL, the #MODIFIED variable is replaced with the last date and time the synchronization is done.