专家坐堂-where语法错误Foxtable(狐表) - 新一代数据库软件，完美融合Access、Foxpro、Excel、vb.net之优势，人人都能掌握的快速软件开发工具!

以文本方式查看主题

-  Foxtable(狐表)  (http://foxtable.net/bbs/index.asp)
--  专家坐堂  (http://foxtable.net/bbs/list.asp?boardid=2)
----  where语法错误  (http://foxtable.net/bbs/dispbbs.asp?boardid=2&id=108527)

--  作者：huhu
--  发布时间：2017/10/24 16:24:00
--  where语法错误

Dim msg As String = "c<?xml version=" & """1.0""" & " encoding=" & """utf-8""" & "?>" & vbcrlf & "<ufinterface efdebug=" & """0""" & " efserverid=" & """321""" & " eftype=" & """EFSQL""" & " ddate=" & """2016-10-08""" & " sqlstr=" & """se lect * from Rdrecord32 where cDefine14 like %SOURCE=BDORDER% and dnmaketime >=\'" & Today.value & "\'""" & " proc=" & """Query""" & " succeed=" & """1""" & " dsc=" & """EFSQL处理成功""" & ">" & vbcrlf & "</ufinterface>"

红色的部分怎么改，老提示语法错误。
想得到where cDefine14 like %SOURCE=BDORDER% and dnmaketime >=\'" & Today.value & "\'
where后面是2个条件，是不是用()，怎么加（）老提示语法错误。
where & “(cDefine14 like %SOURCE=BDORDER% and dnmaketime >=\'" & Today.value & "\' & ")"

--  作者：有点甜
--  发布时间：2017/10/24 17:32:00
--

" where cDefine14 like \'%SOURCE=BDORDER%\' and dnmaketime >=\'" & Today.value & "\'"