wwsql::ExecuteStoredProcedure
less than 1 minute to read

Calls a stored procedure.

o.ExecuteStoredProcedure(lcProcedure,lcCursor)

Return Value

.T. or .F.

Parameters

lcProcedure

lcCursor
Optional name for a cursor result set if returned.

Example

foxpro
oSql = CREATEOBJECT("wwSql") * driver={sql server};server=(local);database=WebStore ? oSQL.Connect("database=WebStore") *** Parameters to pass pnId=-1 pcTable = "wws_tlineitems" *** Set parameters to pass to the SP oSQL.AddParameter("wws_tlineitems","pcTable") oSQL.AddParameter(0,"pnId","OUT") IF !oSQL.ExecuteStoredprocedure("sp_ww_newId") ? oSQL.cErrorMsg RETURN ENDIF ***Grab the return value ? oSQL.oParameters["pnId"].Value

You can also return cursor results and capture them to the cursor specified in the second parameter:

foxpro
IF !oSQL.ExecuteStoredprocedure("sp_get_popular_posts","TPosts") ? oSQL.cErrorMsg RETURN ENDIF * TPosts cursor BROWSE

See also:

Class wwsql

© West Wind Technologies, 1996-2024 • Updated: 09/05/16
Comment or report problem with topic