# Re: pass- through

Posted by 纪文和 on April 19, 1999 at 19:43:08:

In Reply to: pass- through posted by CHIOU on April 19, 1999 at 13:20:26:

我在 Access 建立了一个 Table1, 含a,b,c三栏位
产生了一个 update 指令
UPDATE table1 SET table1.a = [table1].[b]-[table1].[c];
移到vb中,也是正常的.

Dim db1 As Database
Dim wsql As String
Set db1 = opendatabase("c:\db1.mdb")
wsql = "UPDATE table1 SET table1.a = [table1].[b]-[table1].[c];"
db1.execute wsql

再试试吧!!

Follow Ups: