RunQueryExecute

Syntax

SQL.RunQueryExecute(QueryOrProcedure[, Timeout])

Description

Executes an UPDATE, INSERT or DELETE query or a STORED PROCEDURE.

When the execute completes successfully, the function returns TRUE, or FALSE otherwise.

Parameter	Description
QueryOrProcedure	A reference to an Update, Insert or Delete query, or a Stored Procedure
Timeout	Optional. The number of seconds in which the test must be completed. If not specified, the timeout is 30 seconds.

See Also

other SQL.RunQueryxxxxxxxx functions.

Example

Sub Main()
 
    Dim sQuery As String
 
    sQuery = "Insert Into Prm_Status Values('n ','Nieuw ')"
 
    If SQL.RunQueryExecute(sQuery, 5) Then
        MsgBox "Insert query is OK!"
    End If
 
End Sub