禁止多表自动更新(100分)

H

huysnet

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2008-03-16

• #1

我只需要更新A表<br>adoquery 却三个表都要插入数据怎么禁用<br><br>SELECT b.FullName AS bFullName, e.FullName AS eFullName, k.FullName AS kFullName, <br>&nbsp; &nbsp; &nbsp; a.*<br>FROM Dlyndx a INNER JOIN<br>&nbsp; &nbsp; &nbsp; ptype b ON a.btypeid = b.typeId INNER JOIN<br>&nbsp; &nbsp; &nbsp; employee e ON a.etypeid = e.typeId INNER JOIN<br>&nbsp; &nbsp; &nbsp; Stock k ON a.ktypeid = k.typeId

 

K

kkyy

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2008-03-16

• #2

可以设置要更新的什么表的属性,自己查查

 

H

huysnet

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2008-03-16

• #3

我设置了 fields.provideflages.pflnupdate:=false<br>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;fields.provideflages.pflnwhere:=false<br>还是要更新从表

 

K

kkyy

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2008-03-17

• #4

还没搞定?<br>adoquery.Recordset.Properties['Unique Table'].Value := '要更新的表名称';

 

P

pangzhenguang

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2008-03-18

• #5

用三层，两层这个问题没 法解决，解决了也不能自动刷新

 

H

huysnet

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2008-03-18

• #6

to kkyy,<br>adoquery.Recordset.Properties['Unique Table'].Value := '要更新的表名称';<br>设置了,只能够删除,insert 要出问题<br>to &nbsp;pangzhenguang,<br>你说的对,解决了也不能够自动刷新,请问有三层的范例,万分感谢!

 

K

kkyy

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2008-03-19

• #7

你要insert,最好是自己手工处理吧,

 

H

huysnet

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2008-03-20

• #8

问题已经解决