Hello everyone.
I am developing a web application with a mysql database.
I have some stored procedures that take a long time and I have the risk of an IIS time-out.
Therefore I am asking if there is a possibility to execute the stored procedures in the background (obviously without information return).
The Dataflex code is as follows:
Code:
Procedure gpSqlStoredProcedure Global String sStoredProcedure String[] aArguments
Integer iSize iCount
Handle hoConnect hoStmt
Move (SizeOfArray(aArguments)) to iSize
Get SQLConnectionId of ghoConnection "EasyflexDitta000" to hoConnect
Get SQLOpen of hoConnect to hoStmt
Send SQLSetProcedurename of hoStmt sStoredProcedure
For iCount from 1 to iSize
Send SQLSetArgument of hoStmt iCount aArguments[iCount-1]
Loop
Send SQLCall of hoStmt
Send SQLClose of hoStmt
Send SQLDisconnect of hoConnect
End_Procedure
Thank you