Subject Re: sql where statement not working correctly
From Charlie <tm@tc.com>
Date Sat, 14 Jul 2018 18:21:53 -0400
Newsgroups dbase.getting-started

Hi Heinz... Thanks so much.  That cleared things up!  Hope everything is going good your way!

Heinz Kesting Wrote:

> Hi Charlie
>
> > I tried this:
> >   sql = \"select sum(qty) as qqty from SPDDATAARCH.DBF where namedate=:spname\"
> >         params[\'spdname\'] = trim(\'spdname\')
> >
> > However I got an error message that the parameter is not defined spdname
>
> Just a typo??
> In the SQL statement you use spname, but in the next line you use
> spdname, there\'s either a *d* missing or surplus ...
>
> Hope that helps ...
> Kind regards, Heinz