Macro Scheduler 15

DBClose

Not supported in Macro Scheduler Lite.

 

DBClose>database_reference

 

Closes a database connection established by the DBConnect command.

 

Abbreviation: DBX

See also: DBConnect, DBExec, DBQuery

 

For more advanced database manipulation use VBScript.  See:

http://www.mjtnet.com/blog/2006/02/20/accessing-databases/

 

Example

 

Let>str=Driver={MySQL ODBC 3.51 Driver};Server=someserver.com;Port=3306;Database=example;User=admin;Password=xxxx;Option=3;
DBConnect>str,dbH
 
Let>SQL=delete from mytable where ID=1234
DBExec>dbH,SQL,result
 
DBClose>dbH