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