标题: [VB] 看看怎么报语法错误呢？ [打印本页]

---

作者: tingxiao    时间: 2007-9-14 14:51     标题: 看看怎么报语法错误呢？

"select id,ticketdate,tickettime,ticketweight,buyer,buyerunit,freightname,freighttype,position,loadstate,conveyanceunit,ordernumber,icnumber from loadtrade where ticketdate between #2007-01-01#  and #2007-12-31# order by ticketdate,tickettime"

vb2005。xp下编程 数据库为sql ticketdate及tickettime为datetime型[hide][/hide]

---

欢迎光临 逐梦论坛 (http://temp2023.zhumeng.org/)

Powered by Discuz! 7.2