刚入门的菜鸟的我在写一件SQL是有一个问题不能知如何用好分号.'select* from 表名 where 字段
between'+ 'formatDatetime('YYYY-MM-DD',DatetimePicker1.date)'+ ' and'+ 'formatDatetime('YYYY-MM-DD',DatetimePicker1.date)';在写这句时分号出了问题,请高手指点?
那有这方面的例子就好了。每次写这些时都会头大.
between'+ 'formatDatetime('YYYY-MM-DD',DatetimePicker1.date)'+ ' and'+ 'formatDatetime('YYYY-MM-DD',DatetimePicker1.date)';在写这句时分号出了问题,请高手指点?
那有这方面的例子就好了。每次写这些时都会头大.
between'+ quotedstr(formatDatetime('YYYY-MM-DD',DatetimePicker1.date))+ ' and'+ quotedstr(formatDatetime('YYYY-MM-DD',DatetimePicker1.date));使用quotedstr()函数引号就少写了,出错概率就小了。
between'''+ formatDatetime('YYYY-MM-DD',DatetimePicker1.date)+''' and '''+formatDatetime('YYYY-MM-DD',DatetimePicker1.date)+''';
between''' + formatDatetime('YYYY-MM-DD',DatetimePicker1.date)+ ' and'''+ formatDatetime('YYYY-MM-DD',DatetimePicker1.date)+''';
formatDatetime('YYYY-MM-DD',DatetimePicker1.date)+ ' and '+
formatDatetime('YYYY-MM-DD',DatetimePicker1.date);