www.pudn.com > sqlserverdbfz.rar > ParamDefs.bas
Attribute VB_Name = "ParamDefs"
'This module was generated by CLASSter (tm)
'from Urfin Jus. Copyright 2000, All rights reserved.
' CLASSter Version: Build 1.2.88 Demo
' Date: 04 Jun 2001, 03:17
' Connection string used: "Driver=SQL Server;UID=sa;PWD=;Server=; Database=Northwind"
' Dependencies: None
'
' These constants may be used in calls to ExecSPbyName method of
' database class. They contain packed attributes of stored procedures
' parameters. ExecSPbyName method uses them to rebuild parameters
' collection on-the-fly.
' Example:
'
' DBClass.ExecSPbyName "CustOrdersDetail", PRM_CUSTORDERSDETAIL, Array(OrderID)
Public Const PRM_CUSTORDERHIST = _
"@CustomerID,202,1,5,3,0,0"
Public Const PRM_CUSTORDERSDETAIL = _
"@OrderID,3,3,0,1,0,10"
Public Const PRM_CUSTORDERSORDERS = _
"@CustomerID,202,1,5,3,0,0"
Public Const PRM_EMPLOYEESALESBYCOUNTRY = _
"@Beginning_Date,135,1,0,2,0,0;@Ending_Date,135,1,0,2,0,0"
Public Const PRM_SALESBYYEAR = _
"@Beginning_Date,135,1,0,2,0,0;@Ending_Date,135,1,0,2,0,0"
Public Const PRM_SALESBYCATEGORY = _
"@CategoryName,202,1,15,3,0,0;@OrdYear,202,1,4,3,0,0"
Public Const PRM_TENMOSTEXPENSIVEPRODUCTS = ""