Z zhaolin_918 Unregistered / Unconfirmed GUEST, unregistred user! 2008-05-28 #1 SELECT * from cssp where cssj between # 2008-5-18# and DATEADD("d",1,'2008-5-26 ')这个查询语句在Delphi中怎么写?在ACCESS中编译通过了,在Delphi中试了半天没试出来.
SELECT * from cssp where cssj between # 2008-5-18# and DATEADD("d",1,'2008-5-26 ')这个查询语句在Delphi中怎么写?在ACCESS中编译通过了,在Delphi中试了半天没试出来.
H hanpengshan_00 Unregistered / Unconfirmed GUEST, unregistred user! 2008-05-29 #3 SELECT * from cssp where cssj between '2008-5-18' and DATEADD(d,1,'2008-5-26 ')
C Corn3 Unregistered / Unconfirmed GUEST, unregistred user! 2008-05-29 #4 SQL.Add('SELECT * from cssp where cssj between # 2008-5-18# and DATEADD(''d'',1,''2008-5-26'')');
D DIGUA Unregistered / Unconfirmed GUEST, unregistred user! 2008-05-29 #7 因为是字符串,所以SQL要求用单引号 同时delphi对字符串的表示也有自己的要求 故在delphi中写SQL,为了符合SQL要求,需要转换下
