On 4/5/13 10:12 PM, Aleq wrote:
> Magic happend with '?' in addWhere clause. Now here is another problem. As I
> understand, bizobject created 'on the fly' and when I put
> biz.addWhere("yr = ?")
> biz.setParams(y)
biz.setParams() takes a sequence, not a single value. Well, if you really only
have
one single value, it'll convert it to a tuple for you. So if you have multiple
parameters, pass them like:
biz.setParams((x, y))
> biz.requery()
> in dTextBox object ( onHit Method), and the rest of the code (connection to
> the database, addFields, etc) is in AfterInit Method of dForm object. I'm
> getting bunch of errors, like:
> "dabo.dException.DBQueryException: Incorrect number of bindings supplied.
> The current statement uses 2, and there are 1 supplied."
It sounds like you have multiple ?'s in your SQL; you need the same number of
parameters.
Paul
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/dabo-users
Searchable Archives: http://leafe.com/archives/search/dabo-users
This message: http://leafe.com/archives/byMID/[email protected]
