Search found 1 match

by dpap
28.06.2014, 22:03
Forum: MySQL
Topic: Selecting with datetime
Replies: 0
Views: 2045

Selecting with datetime

I wrote this code with form20.aZQuery do begin emptydataset; SQL.text := 'SELECT COUNT(aDateTimeFieldName) FROM aTable WHERE aDateTimeFieldName='+quotedStr(aDateTimeValueThatDoesntExistInAnyRecord); open; result := not isEmpty; end; I expect to return an empty table (recordcount =0, isEmpty = TRUE) ...