BS dw transaction

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.

 

hmtoggle_plus1Example: Connection with external data source

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