Skip to content

Instantly share code, notes, and snippets.

@mattslay
Created December 9, 2019 19:58
Show Gist options
  • Save mattslay/2af1b8f09b40f0b90a61f8630cc2c3e1 to your computer and use it in GitHub Desktop.
Save mattslay/2af1b8f09b40f0b90a61f8630cc2c3e1 to your computer and use it in GitHub Desktop.
Call a Stored Procedure using West Wind wwBusiness for FoxPro
This.ClearSqlParameters()
This.oSQL.AddParameter(lnJobID, "JobID")
lcStoredProc = "[BillingRegister].[GetTimeRecordsByJobId]"
lnReturn = This.ExecuteStoredProcedure(lcStoredProc, lcCursor)
If lnReturn < 0
This.SetError("Error calling Sql Server Stored Proc: " + lcStoredProc)
EndIf
Return lnReturn
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment