看看我的 sql 语句!帮我找一找错误 !
531MT 2004-09-24 08:51:34 conn.execute "insert into bb(xh,bxh,xgrq,xgr) " _
& "select gwxh,'" & sxh & "' as bxh,'" & sxgrq & "' as xgrq,'" & sxgr & "' as xgr" _
& "from sxb " _
& "where xh='" & sgxh & "'"
其中 dim sxh,sxgr,sxgrq,sbxh,sgxh 都是定义好的,都有值!!!