请各位帮忙看一下这条语句那里不对(50分)

L

lxhfree

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2000-11-30

• #1

sql.Add ('Select * from timeattendance
where day>='''+DatetimePicker1.Date+''' and day<='''+DatetimePicker.Date+'''');

 

M

mat

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2000-11-30

• #2

这样是不是好些
sql.Add ('Select * from timeattendance
where day>='''+datetimetostr(DatetimePicker1.Date)+''' and day<='''+
datetimetostr(DatetimePicker.Date)+'''');

 

W

windpray

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2000-11-30

• #3

好象没有什么可说的了！

 

S

seago

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2000-11-30

• #4

这样如何？
SQL.Add('SELECT * FROM timeattendance');
SQL.Add('WHERE day BETWEEN :a AND :b');
Params[0].AsDate:=DateTimePicker1.Date;
Params[1].AsDate:=DateTimePicker.Date;

 

Y

yhou31

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2000-11-30

• #5

SQL.Add('SELECT * FROM timeattendance');
SQL.Add('WHERE day BETWEEN :a AND :b');
Parambyname('a').value:=DateTimePicker1.Date;
Parambyname('b').value:=DateTimePicker2.Date;

 

杜

杜宝

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2000-11-30

• #6

啊哈！在Access中日期应该加#号！
试试看：
Select * from Table where Date between #00-11-30# and #00-12-01#
是不是对了？

 

Q

qzq

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2000-12-01

• #7

注意datetimepicker的date是带小时,分钟的,
如果只要日期,必须用formatdatetime函数进行转换.

 

M

musicfox

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2000-12-01

• #8

杜宝说的对,要加#号的

 

S

seawa

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2000-12-01

• #9

mat 的语句我试了一下，怎么不行？

 

L

lxhfree

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2000-12-04

• #10

谢谢大家的回答,我已经解决了,是一个很愚蠢的错误:day为关键字