I have a Stored Procedure in a Database called GetKey, which requires a parameter sent of the tablename and will return the next Key that can be used for the primarykey of the table.
So I would like to execute that Stored Procedure using the following:
oConnection = CreateObject("adodb.connection")
oConnection.Provider = 'MSDASQL.1'
oConnection.ConnectionString = "Provider=MSDASQL.1;Driver={Microsoft Visual FoxPro Driver};SourceType=DBC;SourceDB=C:\FLASH\CODEBOOK\MASTERWEBSYSTEM\DATA\MASTERWEBSYSTEM.DBC;Pwd=;UID=;"
oCommand = CreateObject("adodb.command")
oCommand.ActiveConnection = oConnection
So my question is what do I need to provide to the oCommand object to execute my Stored Procedure called GetKey (with the table name parameter) and get the key returned to me?
Any help would be appreciated.
Bret Hobbs
"We'd have been called juvenile delinquents only our neighborhood couldn't afford a sociologist." Bob Hope