|
请问下列代码:
Dim strSiteCode As String
Dim strCurrPeriod As String
Dim strBillCode As String
conn.Execute "insert into tblBillBeginTree (FBillCode,FSiteCode,FPeriodNo,FStartNo,FEndNo,FOnHandQty)" & _
" values ('" & strBillCode & "','" & strSiteCode & "','" & strCurrPeriod & "','0','0',0)"
假设FBillCode中文字段是“编号”,FSiteCode中文字段是“库号”,FPeriodNo中文字段是“期间”,FStartNo中文字段是“开始号”,FEndNo中文字段是“截止号”,FOnHandQty中文字段是“库存数”
是否能改写为
Dim strSiteCode As String
Dim strCurrPeriod As String
Dim strBillCode As String
conn.Execute "insert into tblBillBeginTree (编号,库号,期间,开始号,截止号,库存数)" & _
" values ('" & strBillCode & "','" & strSiteCode & "','" & strCurrPeriod & "','0','0',0)"
如果可以,哪么& strBillCode & 等该如何改写成中文???
|
|