sql = "UPDATE xsT_marketMain SET tf_mkInvoice2 = DSum('tf_allocateAmount','xsT_invoicesDetail','tf_HDid=" + record.tf_HDid + "') WHERE tf_id=" + record.tf_HDid;objConn.execute(sql);