Question

PB中DYNAMIC CURSOR的问题，游标无法正常打开

DECLARE BL DYNAMIC CURSOR FOR sqlsa;
sql="SELECT Gno,Gname,Sccj,Xh,Gg,Scrq,Kcsl,type from DGoods where "+search+" like "+keyword
PREPARE SQLSA FROM :sql;
open dynamic BL using :sql;
MessageBox("","出错信息："+sqlca. SQLErrText)
execute sqlsa using: sql;
提示的出错信息mismatch between prepared number of substitution variables and execute parameter

• 你的回答被采纳后将获得：
• 系统奖励15（财富值+成长值）+难题奖励10（财富值+成长值）+提问者悬赏5（财富值+成长值）

Answer 1

model' => $model, // Your model
attribute' => 'news_date', // Attribute for input
options' => array(
dateFormat' => 'yy-mm-dd',
changeYear'=> 'true',
changeMonth'=> 'true',
yearRange'=> '1900:2099',
showOn' => 'both',
buttonText' => 'Click',
)