Subject Re: Query error From Tom <IHaveNoEmail@ddress> Date Sat, 2 Sep 2023 09:53:58 -0400 Newsgroups dbase.getting-started Mervyn, Found the following excerpt in 'test_combobox_lookupForm' dated 2018/01/07 ... * I have no idea if this is helpful or not. Tom      this.PARTS2 = new QUERY(this)     with (this.PARTS2)        left = 147.0        top = 22.0        width = 35.0        height = 37.0        database = form.dbasesamples1        l0 = "select p.*,description||'    Color: '||color||'    Weight: '||cast(weight as character(7))||'    Price:'||cast(price as character(7)) as combo from PARTS.DBF p  where description||'    Color: '||color||'    Weight: '||cast(weight as character(7))||'    Pri"        l0 += "ce:'||cast(price as character(7)) = :combo"        sql = l0        params["combo"] = " "        active = true     endwith     this.PARTS1 = new QUERY(this)     with (this.PARTS1)        left = 14.0        top = 22.0        width = 35.0        height = 37.0        database = form.dbasesamples1        sql = "select p.*,description||'    Color: '||color||'    Weight: '||cast(weight as character(7))||'    Price:'||cast(price as character(7)) as combo from PARTS.DBF p  order by description,color,weight,price"        active = true     endwith