語問大家..我的sql語法如下:
rec.Open "select fano as 廠商編號,faname as 廠商名稱,tel as 電話,add as 地址, people as 聯絡人,note as 備註 from factory", db, adOpenKeyset, adLockPessimistic
我覺得太長了,所以想要切成兩行...除了用
sql="select * from table"
sql=sql & "where....."
這種設定變數的方法外...還有其它的方法嗎...我的印象是好像是&_,但這樣沒有辦法說....
請大家指教,謝謝您們
rec.Open "select fano as 廠商編號,faname as 廠商名稱,tel as 電話,add as 地址, people as 聯絡人,note as 備註 from factory", db, adOpenKeyset, adLockPessimistic
我覺得太長了,所以想要切成兩行...除了用
sql="select * from table"
sql=sql & "where....."
這種設定變數的方法外...還有其它的方法嗎...我的印象是好像是&_,但這樣沒有辦法說....
請大家指教,謝謝您們
文章標籤
全站熱搜
