L
lzhp
Unregistered / Unconfirmed
GUEST, unregistred user!
新建一存储过程
CREATE PROCEDURE ADD_OIL(
CARD_NO CHAR(5),
ADD_NUMBER FLOAT
)
AS
BEGIN
UPDATE JYZDTXX
SET OIL_PRACTICAL_ADD = OIL_PRACTICAL_ADD + ADD_NUMBER
WHERE CARD_NUMBER =: CARD_NO;
END
WISL提示
Statement failed, SQLCODE = -206
Dynamic SQL Error
-SQL error code = -206
-Column unknown
-ADD_NUMBER
不知道是何原因 敬请各位赐教
谢！！！！！！！！！！！
CREATE PROCEDURE ADD_OIL(
CARD_NO CHAR(5),
ADD_NUMBER FLOAT
)
AS
BEGIN
UPDATE JYZDTXX
SET OIL_PRACTICAL_ADD = OIL_PRACTICAL_ADD + ADD_NUMBER
WHERE CARD_NUMBER =: CARD_NO;
END
WISL提示
Statement failed, SQLCODE = -206
Dynamic SQL Error
-SQL error code = -206
-Column unknown
-ADD_NUMBER
不知道是何原因 敬请各位赐教
谢！！！！！！！！！！！
