SQLSELECT[]=“select a.*,b.zflx,b.zfbz from Send_TxtTbl a,ServiceTbl b where
a.fszt='F' and a.sfdsfs='F' and a.mdsjh is not null and a.ywdm=b.ywdm”;
EXEC SQL EXECUTE IMMEDIATE :SQLSELECT;
a.fszt='F' and a.sfdsfs='F' and a.mdsjh is not null and a.ywdm=b.ywdm”;
EXEC SQL EXECUTE IMMEDIATE :SQLSELECT;
SQLSELECT[]=“select a.*,b.zflx,b.zfbz from Send_TxtTbl a,ServiceTbl b where
a.fszt='F' and a.sfdsfs='F' and a.mdsjh is not null and a.ywdm=b.ywdm”;
EXEC SQL EXECUTE IMMEDIATE :SQLSELECT;谢谢各位!!
取多条记录可以用游标
EXEC SQL DECLARE sc CURSOR FOR select a.*,b.zflx,b.zfbz from Send_TxtTbl a,ServiceTbl b where a.fszt='F' and a.sfdsfs='F' and a.mdsjh is not null and a.ywdm=b.ywdm ;
EXEC SQL WHENEVER NOT FOUND DO break;
for (;;)
{
EXEC SQL FETCH sc INTO :v1,:v2... ;
...
}