On 3/4/07, Ian M. Jones <[EMAIL PROTECTED]> wrote: > > Oops, sorry Dennis, I meant to write: > > strSQL = "SELECT * FROM myTable WHERE date(entryDate) = '" + > d.SQLDate + "'"
Thanks Ian. Yesterday I wrote myself a nice little testing utility that allows me to test queries on REALSQLDatabase files. It doesn't allow me to use variables, but using string literals for dates it's not working for me as advertised. It displays the results of every query record in a comma-delimited string, one record to a line of a listbox. If I use the query SELECT * FROM DataEntryTable WHERE de_EntryDate <> "", I get back all the entries in my table. de_EntryDate is defined as not null, so that's working exactly as it should in my estimation. >From the results that are produced, I see there are a few entries with the date field entry "2006-07-13". So I change the query to SELECT * FROM DataEntryTable WHERE de_EntryDate = "2006-07-13". When I run that query, I get 0 results. I have since switched my application to use integers for dates, and I now get the kinds of results I expect. _______________________________________________ Unsubscribe or switch delivery mode: <http://www.realsoftware.com/support/listmanager/> Search the archives: <http://support.realsoftware.com/listarchives/lists.html>
