Use AdoDb.command to do store procedures under VB

xiaoxiao2021-03-06  129

First, if you want to get the stored procedure Return value, the return value of the return value must be placed before all parameters.

Command.parameters.add ReturnValuepara

Second, if you want to get the return parameter of the stored procedure. If you can't return the result set, vice versa

Third, when the storage procedure returns a result of only one result set, the next result set can be accessed with RecordSet.NextRecordSet method.

转载请注明原文地址:https://www.9cbs.com/read-101964.html

New Post(0)