急：order by Date怎么不能进行时间排序呢？帮我看看，好吗？

[webnetmax]

query1.close;
query1.sql.clear;
Query1.SQL.Add('Select * from mail Where Muser='curuser' and MailBox='MailBox' order by Date');
if (Not Query1.Prepared) then Query1.Prepare;
query1.Open;

报错说：
Invalid use of keyword.
Token:Date
Line Number:1.

[idilent]

有date这个字段吗？

[webnetmax]

有date这个字段，Date为日期型

[耙子]

order by [Date]

Data 是保留字，最好改个名字

[leeky]

Date 这个字段是否改个其它的名称？

[hnhb]

如果curuser和MailBox是变量的话
query1.close;
query1.sql.clear;
Query1.SQL.Add('Select * from mail Where Muser='+curuser+' and MailBox='+MailBox+' order by Date');
if (Not Query1.Prepared) then Query1.Prepare;
query1.Open;

如果curuser和MailBox是Edit组件的话
query1.close;
query1.sql.clear;
Query1.SQL.Add('Select * from mail Where Muser='+curuser.text+' and MailBox='+MailBox.text+' order by Date');
if (Not Query1.Prepared) then Query1.Prepare;
query1.Open;

[sundayzhao]

order by [Date] 就可以了

[dinaphp]

Query1.SQL.Add('Select * from mail Where Muser='curuser' and MailBox='MailBox' order by Date');
兄弟，你这句话对吗？
1.你的引号都不对 .
2.Date 该成[Date]
应改成
'Select * from mail Where Muser=''curuser'' and MailBox=''MailBox'' order by Date'

[hongjg]

Date 是保留字，最好改个名字!