Subject Re: Type mismatch ? From Tom <IHaveNoEmail@ddress> Date Fri, 8 May 2020 18:32:06 -0400 Newsgroups dbase.getting-started On 5/8/20 4:53 PM, Mervyn Bick wrote: > On 08/05/2020 19:22, Tom wrote: >> Hi all, >> >> I have several queries on my form that use this exact same format. >> They all work fine except this one. I keep getting an error message: >> 'Type mismatch in expression.' The only difference between this query >> and the others is that other queries are of character fields and this >> one is of a memo field. >> >>     this.ZNOTESEARCH = new QUERY(this) >>     with (this.ZNOTESEARCH) >>        left = 466.0 >>        top = 363.0 >>        width = 70.0 >>        height = 37.0 >>        database = form.dbcontactstables >>        sql = "Select Fk_Contact, zNote from zNOTE WHERE UPPER(zNote) >> LIKE :zNote" >>        params["zNote"] = "%" >>        requestLive = false >>        active = true >>     endwith >> >> Can you straighten me out so that this query works without the error >> message? >> > > I'm afraid upper() and lower() can't be used with memo or BOB fields. > Unfortunately this is not covered in the dBASE help file. It is, > however, covered in the localSQL help file. > > dBASE still includes the localSQL help file as a .hlp file which Windows > 10 won't open.  If you search in the binaries newsgroup for LocalSQL > Help you will find .pdf and .chm versions. > > Mervyn. > Thank you Mervyn, Once again, it looks like a job for dBase 'Plan B' ... Guess I will be stealing method and code from Ken's Library.wfm :) Regards, Tom