逐梦论坛's Archiver

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]

页: [1]

Powered by Discuz! Archiver 7.2  © 2001-2009 Comsenz Inc.