Define SP full in/out parameters properties for ASPdbSP, ASPdbDS or ASPdbSP2DS.

dbQP Abbr: spcp
Version: All

Namespace:  Tornado
Assembly:  Tornado (in Tornado.dll) Version: 12.6.0.9 (1.0.0.0)

Syntax

C#
public string dbStoredProcCmdParams { get; set; }
Visual Basic (Declaration)
Public Property dbStoredProcCmdParams As String

Field Value

Obj.dbStoredProcCmdParams = "(;,)SPName |SPType | NoRS; Name| Type| Dir| Size| Value, ...repeat"
KeywordDescription
SPNameName of stored procedure or command text. SPname=byroyalty
SPTypeSP (def) | Table | Text.

Use Table for ACCESS query

NoRS T/F. Returns no recordset. Def=false
NameVariable 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.

DirDirection of Variable - input or output - (input either string or number)
  • in|input|1
  • out|output|2
  • inout|inputoutput|return|4
SizeWidth (how many characters) of parameter. Def=Length of Input String
Valuevalue of parameter. Input values wrappers are optional. Value=hello or Value='hello'

Remarks

Q311540 - "COMPUTE BY Statements Not Supported by SqlClient". This restriction might be lifted.

See Also