Subject Re: sql where statement not working correctly From Charlie <tm@tc.com> Date Sun, 15 Jul 2018 16:50:42 -0400 Newsgroups dbase.getting-started Hi Mervyn... No need to be sorry.  I really appreciate all the help you have given me!!!!! Mervyn Bick Wrote: > On 2018-07-14 8:15 PM, Charlie wrote: > > Hi Mervyn.. Thanks for the help. > > > > I tried this: > > > > sql = "select sum(qty) as qqty from SPDDATAARCH.DBF where namedate=:spname" > >                 params['spdname'] = trim('spdname') > > > > But I get an error parameter not defined: spdname > > Sorry about that.  A typo AND incorrect use of quotes.  No wonder it > wouldn't work. :-(  Fortunately Heinz was able to sort the problems out > for you.  Depending on where the value in spdname comes from you may not > even need to trim() it. > > Mervyn. >