Execute SQL Command

This function is used to execute any SQL command on application database. You can execute SQL commands to retrieve/delete/update some information as per your requirements. It performs SQL command on last created database. The parameters are:

Path: It is the path of the file where to execute SQL command. It is a MS Access file and an optional parameter. In case it is not specified then HCnix execute SQL command on database which is created through CreatedDatabase function.

Command: It is the SQL command. It is a required parameter.

Ignoreerrors: Its possible values are True/False. It is an optional parameter and it default value is True; that means ignore error if any.

Timeout: It is the timeout value to execute SQL command. It is an optional parameter and its default value is 20000. It is the time in milliseconds.