我的程序有个变量row.我就是想把记录集中的第row行删除,谁能写出?我用到了ADO技术,大概为:
_ConnetionPtr pCon;
Cstring sql="delete table form (select top "+row"* from table) AS t1 where table.id=t1.id " //这是删除前row行的,可是编译时也会抱错,我现在要的是删除第row行
//...
_ConnetionPtr pCon;
Cstring sql="delete table form (select top "+row"* from table) AS t1 where table.id=t1.id " //这是删除前row行的,可是编译时也会抱错,我现在要的是删除第row行
//...
这个应该不行吧,假如一共2条纪录
select top " + row + " id from tb order by id 返回前2条纪录
select top 1 id from(...) 是选择出了第1条纪录了
============
有个order by id desc
是倒数第一行,即二行。