Subject Re: sql where statement not working correctly
From Mervyn Bick <invalid@invalid.invalid>
Date Sun, 15 Jul 2018 09:02:00 +0200
Newsgroups dbase.getting-started

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.