我用的INTRBASE6,在INTERACTIVE SQL中定义
CREATE PROCEDURE GET_PIECE
( ROOM_LEVEL VARCHAR(2) )
RETURNS ( ROOM_LEVEL_PIECE VARCHAR(4))
AS
BEGIN
SELECT ROOM_LEVEL_PIECE
FROM ROOM_LEVEL
WHERE ROOM_NO= :ROOM_NO1
INTO :ROOM_LEVEL_PIECE
SUSPEND
END
系统说:”No active connection“
请问这是为什么?
CREATE PROCEDURE GET_PIECE
( ROOM_LEVEL VARCHAR(2) )
RETURNS ( ROOM_LEVEL_PIECE VARCHAR(4))
AS
BEGIN
SELECT ROOM_LEVEL_PIECE
FROM ROOM_LEVEL
WHERE ROOM_NO= :ROOM_NO1
INTO :ROOM_LEVEL_PIECE
SUSPEND
END
系统说:”No active connection“
请问这是为什么?
CREATE PROCEDURE GET_PIECE
( ROOM_LEVEL VARCHAR(2) )
RETURNS ( ROOM_LEVEL_PIECE VARCHAR(4))
AS
BEGIN
SELECT ROOM_LEVEL_PIECE
FROM ROOM_LEVEL
WHERE ROOM_NO= :ROOM_NO1
INTO :ROOM_LEVEL_PIECE
SUSPEND
END
系统说:”No active connection“
请问这是为什么?
CREATE PROCEDURE GET_PIECE
( ROOM_LEVEL VARCHAR(2) )
RETURNS ( ROOM_LEVEL_PIECE VARCHAR(4))
AS
BEGIN
SELECT ROOM_LEVEL_PIECE
FROM ROOM_LEVEL
WHERE ROOM_NO= :ROOM_NO1
INTO :ROOM_LEVEL_PIECE
SUSPEND
END
系统说:”No active connection“
请问这是为什么?