Define SP full in/out parameters properties for ASPdbSP, ASPdbDS or ASPdbSP2DS.
Obj.dbStoredProcCmdParams = "(;,)SPName |SPType | NoRS; Name| Type| Dir| Size| Value, ...repeat"
| Keyword | Description |
|---|---|
| SPName | Name of stored procedure or command text. SPname=byroyalty |
| SPType | SP (def) | Table | Text. Use Table for ACCESS query |
| NoRS | T/F. Returns no recordset. Def=false |
| Name | Variable name. name=@percentage |
| Type | Variable data type member name - See Data Provider Type. Default=String Type. The old classic ASP datatype index is not available any more. This input must be the data type member name. e.g. BigInt, Data, Integer, Decimal, NVarChar, Number. Member names are not case sensitive. There are (3) alias verbs - String, Integer, Date. See Data Type for appropriate mapping for different providers of these 3 verbs. If you should get data type mis-match error. Use the exact member name from these tables. |
| Dir | Direction of Variable - input or output - (input either string or number)
|
| Size | Width (how many characters) of parameter. Def=Length of Input String |
| Value | value of parameter. Input values wrappers are optional. Value=hello or Value='hello' |
Q311540 - "COMPUTE BY Statements Not Supported by SqlClient". This restriction might be lifted.
z Class | Tornado Namespace | ASPdbSP | dbStoredProc | dbResultSet | ASPdbSP2DS | Get_SPOutput | Special Topic - Data Type | Special Topic - Tornado, StoredProcedures & DataSet