[ Main Menu ] [ Extension Tools Menu ] [ Enterprise Edition Menu ]
<iSQLTRANS> Tag


 
<iSQLTRANS
 
 
 
 

Usage
 
 
 

Note
 

See Also

[DBNAME="datasource name"]    (from registry)
[LOGIN=" uid/pword "]     (from registry)
SQL="sql statement"
[ALIAS="alias"]      (i_sql)
>

This tag and the /iSQLTRANS allows the creation of atomic transactions that can be rolled back if they are not successful.  Effectively, this will lock the database against other updates and guarantees the access is mutually exclusive.  It works in a similar manner to the iSQL and /iSQL tags.

Do not use the iSQLTRANS tags set on the default connection or results may be unpredictable. In other words, always use the DBNAME.

 iHTML, iSQL, iSQLTRANS, iSQLFETCH, iDBQUERY, isqlnextset, iSQLMORE, iDBLOOP


iSQLTRANS Example
Example Source Code
Top