Subject Re: Query error From Tom <IHaveNoEmail@ddress> Date Sat, 2 Sep 2023 12:06:55 -0400 Newsgroups dbase.getting-started On 9/2/23 11:36 AM, Mervyn Bick wrote: > On 2023/09/02 15:18, Tom wrote: > >> Revision3: >> * >> sql = "select CAST(d.TestDate as char(10)) Test_Date from Demodata d >> WHERE Test_date LIKE :TestDate" >> >> // Note: above query is a verbatim copy of your first sql above with >> close ')' included. Same error message. >> * >> params["TestDate"] = '%' >> >> Picture of table design attached. I do not see any field name spelling >> errors. >> >> Tom > > Try removing the WHERE CLAUSE and the "TestDate" parameter. > > I'm afraid I can't look at this further now and the power is going off > again in 30 minutes.  More tomorrow. > > Mervyn. > * Same error message ... * Take your time, I'm in no rush. Thanks for your efforts. Tom