+ -
当前位置:首页 → 问答吧 → 求助,符号传递问题

求助,符号传递问题

时间:2011-08-03

来源:互联网

Public Function dbfIsseNoList( _
  Optional Sta As String _
  ) As Variant

SQL$ = SQL$ & "where STA <= '" & Sta & "'"

立即窗口中显示 where sta <= '5'
以上正常运行
现在需要将“<=”也放到参数中

Public Function dbfIsseNoList( _
  Optional Smybol As Variant,Optional Sta As String _
  ) As Variant

SQL$ = SQL$ & "where STA'"& Smybol & Sta & "'"

立即窗口中显示 where sta '<=5'
(运行报错)
如何让下面立即窗口显示如上面的一样

作者: slysmart   发布时间: 2011-08-03

SQL$ = SQL$ & "where STA"& Smybol &"'" & Sta & "'"

作者: BestBadGod   发布时间: 2011-08-03

SQL$ = SQL$ & "where STA"& Smybol &"'" & Sta & "'"

作者: ybh37   发布时间: 2011-08-03

SQL$ = SQL$ & "where STA " & Smybol & "'" & Sta & "'"

作者: BestBadGod   发布时间: 2011-08-03

VB code
strsql = " select * from table1 where 1= 1 "

strsql = strsql & " and sta " & smybol & "" & sta & ""


需要单引号就自己往里补,我看你的代码,sta像是不需要引号的。

作者: AisaC   发布时间: 2011-08-03

热门下载

更多