On Mar 3, 2007, at 3:34 PM, Ken Dibble wrote:
> I guess the notion of the bizobj's KeyField is incompatible with
> UserSQL in
> some way, and so there's something else on the bizobj that I need
> to set,
> but I don't know what it is.
No, but you do need to include that KeyField in the UserSQL statement.
> biz = dabo.biz.dBizobj(conn)
>
> # No DataSource; we'll use DataSet instead.
I've never tried running a bizobj without a DataSource. What happens
if you set this to the name of the table?
> # I've tried commenting this out entirely, or using "pkid"
> or "musRecs.pkid" here.
> # In all cases the error has to do with KeyField. It also
> doesn't matter
> # whether or not musRecs.pkid is in SELECT clause of the
> query. And, it doesn't
> # matter whether there's a LIMIT clause in the query. I
> put it in because I thought
> # it just might be taking the data engine a really long
> time to deal with these
> # joins. But I can let it sit for 15 minutes and it
> produces nothing.
> biz.KeyField = "musRecs.pkid"
This should always be just a column name, not a table.column name.
-- Ed Leafe
-- http://leafe.com
-- http://dabodev.com
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users
