|
hi
i catch a serious problem. the Server i use ms sql server 7.0 ,and i write some stored procedures, which works quite well througth the isqlw,give me the correct answer. but when i use them in pb's programs, it seems that no response return. when i invoke the store procedure,they returned immediately,and the return code is always zero.i declare the store procedure in pb througth two ways.The first is that i declare the store procedure in transaction object(a class derived from class transaction),they are all stored in "local External Function". the other is that i use dynamic declare sql .the below is my source code how to invoke a store procedure. they are written in a function long ll_return DECLARE sp_user DYNAMIC PROCEDURE FOR SQLSA ; PREPARE SQLSA FROM "sp_cc_AddUser UserName=?,@UserPasswd=?,@UserInGroup=?,@UserDescript=?" ; EXECUTE DYNAMIC sp_user USING :as_user,:as_pwd,:as_group,:as_descript ; FETCH sp_user INTO :ll_return ; CLOSE sp_user ; return ll_return the return code is always the zero. i appreciate anyone's advice, thanks in advance. [EMAIL PROTECTED] |
