Equinox Online Help - Language Reference - A to Z

Home

SQLTouch

Applies to
SyntaxSQLTouch tablename [,tablename2] [,tablename….]
Action[statement] Tells all clients to refresh.
ScopeUsable anywhere when an external database is being used as a repository through ADO.
Notes

SQLTouch forces all records in (external) 'tablename' to be refreshed if visible on any client form. Up to six table names can be specified in the one statement.

CategoryDatabases, Mirroring
See Also SQLRun
Example

This example executes a command on the server and requests that clients update.

Lock customers
SQLRun definition, “begin”
SQLRun Orders, “Delete from customers“
SQLRun definition, “commit”
SQLTouch Orders
Unlock customers