Address different data sources (only via ODBC) with the transaction system.
First, initialize the transaction system.
dw_1.transaktion.init
init |
Initialize |
dsn |
DSN Connect string |
userid |
|
dbpass |
|
dbparm |
|
servername |
|
dsn |
|
connect |
Connect |
disconnect |
Disconnect. This command must be used. |
settransobject |
Set transaction to the DataWindow. |
destroy |
Destroy. |
select |
Execute a Select SQL statement with this transaction. |
delete |
Execute a Delete SQL statement with this transaction. |
update |
Execute a Update SQL statement with this transaction. |
execute |
Execute the SQL statement with this transaction. |
blobread
|
blobread=nr Reads a blob. The blob name will be returned. For more information see blobread. |
blobwrite |
blobwrite=nr=file Writes a blob. If "nr=leer" then it is a new entry. It will return "nr". More informations see blobwrite. |
This script needs to be applied in "Before retrieve" dw_1.transaktion=init dw_1.transaktion=dbparm=myodbcdrive;uid=myuser;pwd=mypwd dw_1.transaktion=connect dw_1.transaktion=settransobject Also make sure that the connection is destroyed, especially for an external data source. This script needs to be applied in "after retrieve" dw_1.transaktion=disconnect
The connection is initialized the next time the form is used. If you use a multi tab form, destroy the connection on each tab selection.
If the window consists of several tabs, the connection object should be destroyed when the tab is changed: dw_1.transaktion=disconnect dw_1.transaktion=destroy |