The following functions should be useful for those working with SQL in Xbasic. They will place in the Trace Window (View -> Trave Window), the SQL statement about to be used with and without arguments and a list of the arguments. They are part of more extensive debug system used in a system deployed with runtimes but should be useful on their own.

Import the three function into your code and examine the functions for an explanation on how to use them.

zTrace-ForSQL.txt

The full Debug system allows debug flags to be set at the start of each Script or function during development and then through a data entry screen after deployment. If anyone is interested in the Debug system PM me and I will post that as well.