Search found 1 match
- 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) ...