|
Можно использавать convert
Например так:
stmt.executeUpdate(
'insert into TmpParm (CountRecord, recid , dataareaid) ' +
'select count(*) as CountRecord, ' +
' convert(int,'+int2str(beginRecId)+') AS recid ,' +
' \''+dataareaid+'\' as DATAAREAID ' +
sqlStr +';'
);
|