Paul McNary wrote:
> Hello
>
> I need some syntax help with getDataSet for a bizObj
>
> I have a section of code:
>
> self.Form.getBizobj("public.alchemy_generic_product").setWhereClause("name
> like '%%%s%%'" % self.Value)
>
> self.Form.getBizobj("public.alchemy_generic_product").setOrderByClause("name")
> dsGenericProduct =
> self.Form.getBizobj("public.alchemy_generic_product").getDataSet(flds=("genericproductid",
>
> "name"), rows=10)
Define a local biz reference first to avoid writing
'self.Form.getBizobj..." over and over. IOW:
biz = self.Form.getBizobj("public.alchemy_generic_product")
biz.setWhereClause("name like '%%%s%%'" % self.Value)
biz.setOrderByClause("name")
dsGenericProduct = biz.getDataSet(flds=("genericproductid", "name"),
rows=10)
print dsGenericProduct
> I am misunderstanding how to use the:
> getDataSet(flds=("genericproductid", "name"), rows=10)
>
> I assumed that would return 10 rows in a dataset based on the bizObj
> "public.alchemy_generic_product"
> with just columns genericproductid and name.
Looks like you have that syntax correct, but you've never requeried the
bizobj after setting the where clause and order clause. IOW, you need a:
self.Form.requery("public.alchemy_generic_product")
before calling getDataSet()
HTH
Paul
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users
Searchable Archives: http://leafe.com/archives/search/dabo-users
This message: http://leafe.com/archives/byMID/[EMAIL PROTECTED]
