Tech Tip: Recommended Usage of SQL LOGIN for 4D-to-4D Connection
PRODUCT: 4D Server | VERSION: 12 | PLATFORM: Mac & Win
Published On: November 1, 2010
The SQL LOGIN command can be used to make a direct connection to 4D Server (i.e. not via ODBC but rather using our proprietary SQL protocol).
It is recommended to make this connection once and re-use the connection, rather than connect and disconnect each time. For example, you might have a process that does this:
Instead, do this:
It is recommended to make this connection once and re-use the connection, rather than connect and disconnect each time. For example, you might have a process that does this:
| Repeat SQL LOGIN($server_t;$user_t;$pass_t;*) // Do stuff SQL LOGOUT DELAY PROCESS(Current process;3*60) Until (<>SYNC_STOPSYNC_F=True) |
Instead, do this:
| SQL LOGIN($server_t;$user_t;$pass_t;*) Repeat // Do stuff DELAY PROCESS(Current process;3*60) Until (<>SYNC_STOPSYNC_F=True) SQL LOGOUT |