L lilinying Unregistered / Unconfirmed GUEST, unregistred user! 2000-08-31 #1 有文件1.PDT 和2.PDT的库结构一样,将其中1中表A中的字段名11复制到2中A表字段为12 表2为空,表1有数据.
A Another_eYes Unregistered / Unconfirmed GUEST, unregistred user! 2000-08-31 #3 insert into 表2 (字段12) select 字段11 from 表1
S skyrabbit Unregistered / Unconfirmed GUEST, unregistred user! 2000-09-01 #4 TBatchMove + TQuery + TTable
J jqw Unregistered / Unconfirmed GUEST, unregistred user! 2000-09-01 #5 database1-->1.PDT database2-->2.PDT Query1(databasename=database1) select null,...,字段11,null,... from A (注意:字段11的位置与表2中字段12对应!!!) Table1(databasename=database2,tablename=表2) Batchmove1.Source--Query1 Batchmove1.Destion--Table1 Try it ?!
database1-->1.PDT database2-->2.PDT Query1(databasename=database1) select null,...,字段11,null,... from A (注意:字段11的位置与表2中字段12对应!!!) Table1(databasename=database2,tablename=表2) Batchmove1.Source--Query1 Batchmove1.Destion--Table1 Try it ?!