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
C:\Program Files (x86)\SBZ systems\EMDI\reports\
and in form
C:\Program Files (x86)\SBZ systems\EMDI\reports\sync_test.sql
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.