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.
|