>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.
Oconnection.ConnectionString = "Provider=VFPOLEDB.1 ; Data Source=" & filepath
%>
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement