On Fri, 2 Mar 2007 07:39:42 -0500, Ed Leafe wrote:
> A better choice, IMO, would be to not mess with UserSQL at all, and
> instead continue to work with the SQL Builder code. In this
> particular case, you want to find a record based on PK. I would
> approach it like this: set the where clause to take a parameter, and
> then pass the desired value when you need it. Example:
>
> biz.setWhere("pkid = %s")
>
> #User enters '123' as the PK and clicks
> biz.setParams(self.keyBox.Value)
> self.requery()
Neat, but how would you construct a where clause using the SQL %
wildcard? as in
name LIKE % sm%
--
Bill Bedford
"Nothing is as important as model railways and even that isn't very
important"
-some wiseguy somewhere
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users
