>Your select statement must provide "all" the fields that are part of the
>bizobj you defined. So:
>addField("field1")
>addField("field2")
>
>Your SQL statement must provide field2 and field2.
>
>So the error is tell you that 'musRecs.pkid' is missing from your select
>statement.
First of all, it's quite possible in a situation like this to involve two
or more fields with the same name from two or more different tables in a
complex query. How can the bizobj handle that?
Second, I'm pretty sure Ed said that I can either use bizobj stuff like
addField() and setWhereClause(), OR use UserSQL, but not both.
Ken
--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.5.446 / Virus Database: 268.18.6/708 - Release Date: 3/2/2007 4:19 PM
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users