On 3 Mar 2007, at 03:49, Dennis Birch wrote: > I've saved my REALSQLDatabase-based application's date data in date > columns (e.g. field.DateValue = d). Now how do I write an SQLSelect > statement that can compare a given date with what I've saved in the > database? You obviously can't write "SELECT * FROM myTable WHERE > entryDate = d. I've tried using "d.SqlDate", but that doesn't work. > What does?
You generally have to quote dates, so the following should work: strSQL = "SELECT * FROM myTable WHERE entryDate = '" + d.SQLDate + "'" Is that what you've tried already? Regards, Ian _______________________________________________ Unsubscribe or switch delivery mode: <http://www.realsoftware.com/support/listmanager/> Search the archives: <http://support.realsoftware.com/listarchives/lists.html>
