Subject Re: Query error From Mervyn Bick <invalid@invalid.invalid> Date Sat, 2 Sep 2023 17:36:13 +0200 Newsgroups dbase.getting-started 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.