delphi(0分)

H

helpdelphi

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2006-04-17

• #1

temp :='select * from user_loginlog '+
' where '''+datetostr(uptime)+''' between '''+datetimetostr(datetimepicker1.Date)+''' and '''+datetimetostr(datetimepicker2.Date)+'''';
其中uptime为user_loginlog表中的一个字段,数据类型为日期/时间型.
程序运行错误提示为: datetostr未定义.

 

C

Codemoocow

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2006-04-24

• #2

Temp := 'SELECT * FROM user_loginlog WHERE 字段名 BETWEEN ''' + DateTimeToStr(DateTimePicker1.Date) + ''' AND '''+ DateTimeToStr(DateTimePicker2.Date) + ''''

 

淡

淡看江湖路

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2006-05-02

• #3

Temp := 'SELECT * FROM user_loginlog WHERE uptime BETWEEN ''' + DateTimeToStr(DateTimePicker1.Date) + ''' AND '''+ DateTimeToStr(DateTimePicker2.Date) + ''''
因为引用的是字段名，不是值

 

X

xiaoping622

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2006-12-31

• #4

select * from 表名 where 字段名 between x1 and x2