In a stored procedure always said I did not provide the necessary indicator variables!

Category: C/C++ -> Foundation Classes Author: tracy752966216 Date: 2002-12-02 19:07:39
 
tracy752966216
2002-12-02 19:07:39
CREATE PROCEDURE Proc_SelectMinuInfo (
@ nOutNumCode numeric output,
@ vchOutFuturesCode varchar (16) output,
@ vchOutFuturesName varchar (20) output,
@ vchOutReceiveTime varchar (19) output,
@ vchOutDBTimeType varchar (10) output,
; @ vchOutTradePrice varchar (16) output,
@ vchOutAskPrice varchar (16) output,
@ vchOutBidPrice varchar (16) output,
@ vchOutOpenPrice varchar (16) output,
@ vchOutHightPrice varchar (16) output,
@ vchOutLowPrice varchar (16) output,
@ vchOutClosePrice varchar (16) output,
; @ vchOutVolume varchar (20) output,
@ vchOutTurnover varchar (20) output,
@ nOutMaxCode numeric output,
@ vchInFuturesCode varchar (16),
@ vchInReceiveTime varchar (19),
@ vchInDBTimeType varchar (10))
AS
Select @ nOutMaxCode = count (*) from SKYDB_Minute
if ; @ nOutNumCode> 0
begin
SELECT @ nOutNumCode = isnull (NumCode, 1),
; @ vchOutFuturesCode = isnull (FuturesCode, ""),
@ vchOutFuturesName = isnull (FuturesName, ""),
; @ vchOutReceiveTime = isnull (ReceiveTime, ""),
@ vchOutDBTimeType = isnull (DBTimeType, "0000000001"),
@ vchOutTradePrice = isnull (TradePrice, " 1 "),
@ vchOutAskPrice = isnull (AskPrice," 1 "),
; @ vchOutBidPrice = isnull (BidPrice, "1"),
@ vchOutOpenPrice = isnull (OpenPrice, "1"),
@ vchOutHightPrice = isnull (HightPrice, "1"),
@ vchOutLowPrice = isnull (LowPrice, "1"),
; @ vchOutClosePrice = isnull (ClosePrice, "1"),
@ vchOutVolume = isnull (Volume, "1"),
@ vchOutTurnover = isnull (Turnover, "1")
FROM ; SKYDB_Minute
WHERE NumCode = (SELECT Max (NumCode)
; FROM SKYDB_Minute
WHERE FuturesCode = @ vchInFuturesCode
AND DBTimeType = @ vchInDBTimeType
; OR ReceiveTime = @ vchInReceiveTime)
SELECT @ nOutMaxCode = isnull (Max (NumCode), 1)
FROM SKYDB_Minute
end
else
return
GO
tmd290
2002-12-02 19:24:38
you What is a database? Your stored procedure should be no mistake, the key is how you apply