一下是控制报表每页打印50条记录的代码，网上看到的
加入表为TEMP
local DetailNum

　　DetailNum = 50

 SELECT * FROM tempsintostable tmp1swheres DELETED()  ***这里出错，SQL有这样用法吗？
      SELECT INT((RECNO()-1)/detailnum) as groupcount;
     FROM tmp1 sintocursor temp2
      USE IN tmp1
     DELETE FILE tmp1.dbf
     IF FILE("tmp1.fpt")
     DELETE FILE tmp1.fpt
     endif

是原文？

是啊
http://www.
原文地址

SELECT * FROM tempsintostable tmp1swheres DELETED()这句少个空格。多了两个s。
应该为：SELECT * FROM tempsintostable tmp1 where  DELETED()
对否？

SELECT * FROM temp into table tmp1 where DELETED()
SELECT INT((RECNO()-1)/detailnum) as groupcount;
     FROM tmp1 into cursor temp2
USE IN tmp1
DELETE FILE tmp1.dbf
IF FILE("tmp1.fpt")
   DELETE FILE tmp1.fpt
endif

[ 本帖最后由 sdta 于 2013-3-4 18:47 编辑 ]