Rss & SiteMap

Foxtable(狐表) http://www.foxtable.com

新一代数据库软件,完美融合Access、Foxpro、Excel、vb.net之优势,人人都能掌握的快速软件开发工具!
共3 条记录, 每页显示 10 条, 页签: [1]
[浏览完整版]

标题:帮我看一下下面的语句错在哪里,特别是where后面的

1楼
dd-zdh 发表于:2011/4/26 19:43:00

Dim ld As Datetime
Dim cmd As New SQLCommand
cmd.CommandText = "Select Max(日期) From {表A} "
ld = cmd.ExecuteScalar()

 

Dim cmd1 As New SQLCommand
Dim var1,var2,var3,var4,var5 As String
'var1 = Forms("窗口4")
var1=Forms("窗口4").Controls("combobox1").text
var2=Forms("窗口4").Controls("combobox2").text
var3=Forms("窗口4").Controls("textbox4").text
var4=Forms("窗口4").Controls("textbox5").text
var5=Forms("窗口4").Controls("DateTimePicker1").text

cmd1.CommandText = "UPDATE {表A} SET 省市= '" & var1 & "',县市='" & var2 & "',区号='" & var3 & "',邮编='" & var4 & "',第三列='" & var5 & "' where 日期>= #ld# "
cmd1.ExecuteNonQuery()
DataTables ("表A").load()

2楼
kylin 发表于:2011/4/26 19:51:00
where 日期>= #"& ld &"#
3楼
dd-zdh 发表于:2011/4/26 19:57:00
谢谢!
共3 条记录, 每页显示 10 条, 页签: [1]

Copyright © 2000 - 2018 foxtable.com Tel: 4000-810-820 粤ICP备11091905号

Powered By Dvbbs Version 8.3.0
Processed in .01953 s, 2 queries.