<< Click to Display Table of Contents >>
Stored Procedure |
The easiest way is by creating a Query in E3 with the command to execute the Stored Procedure and passing, if necessary, values to it. The command that must be configured on this Query is the following:
Exec StoredProcedureName <%var1%>, <%var2%>, ...
Where the syntax of variables must be the "<" (less than) character, the percent ("%") character, the name of the variable, the percent ("%") character again, and finally the greater than (">") character.Values var1 and var2 are the variables the Stored Procedure is waiting for (for example, start and end date). If the Stored Procedure is not waiting for any variable, create the SQL command without variables. To execute this Query, use the Execute method.
NOTE |
E3 Query's CursorLocation property must be configured as 1 - clClient. |