Subject Re: Like query From Tom <IHaveNoEmail@ddress> Date Fri, 27 May 2022 07:00:42 -0400 Newsgroups dbase.getting-started On 5/27/22 6:20 AM, Mervyn Bick wrote: > On 2022/05/26 22:57, Tom wrote: > >> As I read the enclosed Local SQL Help file excerpt, you should be able >> to 'cast' the 'Order Date' field *directly* to a string as opposed to >> creating a new field and without permanent damage to the original date >> values. Is this possible? > > OOPS. :-( I have no idea where I got the idea but for years I've > believed that fieldnames containing spaces were a problem in the SELECT > statement in a query object.  When I created the example for you I > simply created the temporary fields without actually trying to use the > fieldnames with spaces. > > I set out to create a little example to show you it doesn't work and, of > course, the damn thing worked.  What I assumed to be a bug isn't. > > I have now reworked the example so as not to need the temporary fields. >   As there are no temporary fields the query can be made active when it > opens. I've also added the ability to search on either or both fields. > > Both sets of radio buttons use a common onChange() event handler and > both entryfields now  use a common onKey event handler. > > Mervyn. > > > > * MAGIC :) I do notice the need to type a leading zero for April dates is no longer necessary. Saves me some typing. Tell your wife I will stop bothering you now. She will be pleased. Thank you, Tom