数据库问题呀请大家谈一谈呀！！！

[wangfuqing]

在PB中如何使用存储过程呀！

[冷箫轻笛]

string ls_ic_card_id
int li_CanLend

DECLARE book_lend_allow PROCEDURE FOR Usp_GetLendLimit
@ICCARDID = :ls_ic_card_id, //输入参数1
@bkormag = '0', //输入参数2
@CanLend = :li_CanLend OUTPUT; //输出参数
EXECUTE book_lend_allow; 执行
FETCH book_lend_allow INTO :li_CanLend; 得到结果(集)
CLOSE book_lend_allow;

book_lend_allow pb中定义的存储过程名(变量)
Usp_GetLendLimit 数据库中存储过程的物理名

[dancer]

书上有很多例子的，随便找个看看就行了

[eastpond]

up

[btlxy]

调用存贮过程p_yprkdjh，返回值存在ls_xh
DECLARE s_cfdjh PROCEDURE FOR 'p_yprkdjh;1';
Execute s_cfdjh;
Fetch s_cfdjh into :ls_xh;
Close s_cfdjh;