Home > database >  Issue of PB8.0 dynamic execution of SP
Issue of PB8.0 dynamic execution of SP

Time:10-06

The following was written by the younger brother a PB statements, but always quote when they close the window after PB internal error, help analyze!
String ls_CrtMsg ls_ret, ls_swift

String Sqlstatement
- is_src is dynamic
Sqlstatement="DECLARE @ a VARCHAR (100) the EXEC" + is_src + "? ,? ,? ,? ,? @ a output SELECT @ a "

PREPARE SQLSA FROM: Sqlstatement;
The DESCRIBE SQLSA INTO SQLDA;

DECLARE my_cursor DYNAMIC CURSOR FOR SQLSA;

SetDynamicParm (SQLDA, 1, a)
SetDynamicParm (SQLDA, 2 b)
SetDynamicParm (SQLDA, 3, c)
SetDynamicParm (SQLDA, 4, c)
SetDynamicParm (SQLDA, 5 e)
SetDynamicParm (SQLDA, 6, ls_ret)
The OPEN DYNAMIC my_cursor USING DESCRIPTOR SQLDA;
The FETCH my_cursor USING DESCRIPTOR SQLDA;
Ls_ret=GetDynamicString (SQLDA, 1)
The CLOSE my_cursor;

CodePudding user response:

What ah
  • Related