C cytown Unregistered / Unconfirmed GUEST, unregistred user! 1999-10-26 #3 要是同一个数据库, 用 insert into newtable select f1,f2,f3... from oldtable where ..... order by ...
面 面条 Unregistered / Unconfirmed GUEST, unregistred user! 1999-10-26 #4 用Query INSERT INTO newTable (column1, column2,.....) SELECT column1, column2,..... FROM oldTable where.........(你的过滤条件)
用Query INSERT INTO newTable (column1, column2,.....) SELECT column1, column2,..... FROM oldTable where.........(你的过滤条件)
W water Unregistered / Unconfirmed GUEST, unregistred user! 1999-10-26 #5 但是我开发的这个是桌面级的数据库应用,所以用的是TTABLE,不是TQUERY,无 法用SQL,不知可有别的办法实现吗?拜托了!
W water Unregistered / Unconfirmed GUEST, unregistred user! 1999-10-26 #6 哦,哈哈,对不起我都急糊涂了,TQuery可以和TTable一起用的,虽然只是 DeskTop DataBase Application. 哎,人一急就开始说糊话了.多谢诸位.200大分一人一半如何?