Subject Re: Query error From Mervyn Bick <invalid@invalid.invalid> Date Sat, 2 Sep 2023 14:34:53 +0200 Newsgroups dbase.getting-started On 2023/09/02 14:32, Mervyn Bick wrote: > On 2023/09/02 14:04, Tom wrote: > >> Sorry Mervyn but I am still confused here. The following 'cut down' >> version still has the 'invalid field name' error. Trying to get this >> to work correctly then I can add back the rest of my original query. >> >> Revision2: >> * >> >> sql = "Select CAST(d.TestDate as Char(10)) Test_Date, d.TestDate, >> d.Provider, d.Client, d.Category, d.Allergen, d.TestLevel, >> d.StdTestRange, n.Demodata_Notes FROM DemoData d Left Join DemoNotes n >> On n.Fk_DemoData = d.Pk_DemoData WHERE Test_Date LIKE :TestDate" >> * >> params["TestDate"] = "%" > > This error message usually means there is a typo in one of the field > names.  If you've checked the fieldname spelling and the problem still > persists then I'm afraid it's a process of elimination.  Start from > scratch and add a field at a time. > > sql = "select CAST(d.TestDate as char(10) Test_Date from Demodata d > WHERE Test_date LIKE :TestDate" > > sql = "select CAST(d.TestDate as char(10) Test_Date,d.TestDate from > Demodata d WHERE Test_date LIKE :TestDate" > > sql = "select CAST(d.TestDate as char(10) > Test_Date,d.TestDate,d.Provider from Demodata d WHERE Test_date LIKE > :TestDate" > > and so on. > > > Mervyn. > OOPs.  Missing closing bracket for the CAST function each time. :-( More haste, less speed.  :-) Mervyn.