我希望查询StdNo后缀位参数pStdNO的数据
查询语句如下
Select ID, StdNO, Cost, Now, FeeDay, FeeYear from CostView where StdNO like '%':pStdno and FeeYear = :pCurYear
但是出错了
请问该如何修改该参数查询
查询语句如下
Select ID, StdNO, Cost, Now, FeeDay, FeeYear from CostView where StdNO like '%':pStdno and FeeYear = :pCurYear
但是出错了
请问该如何修改该参数查询
把%放在外面
parambyname('pstdno').asstring;='like'+edit1.text;
parmabyname('pcuyear').asstring:='like'+edit2.text