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 = ""