On Oct 24, 2008, at 2:36 PM, johnf wrote:
> We could remove the aggregate bizobj and make a direct sql call.
> But what you
> are saying is I can't use a table twice. You mean that you never
> have done
> something like
>
> use table1
>
> use table1 again alias newtable
In plain VFP, sure, since that was the way it was designed to work.
But never in Codebook apps, which used bizobjs.
> In our case we we want the aggregate because the select statement is
> very
> complex. We want the database engine to do the work and Dabo to
> pass the
> correct key (in this case the pk of the parent).
Then have that query executed as part of the bizobj's afterRequery(),
and store the results locally in the bizobj so that they can be
displayed in your form as needed.
-- Ed Leafe
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-dev
Searchable Archives: http://leafe.com/archives/search/dabo-dev
This message: http://leafe.com/archives/byMID/[EMAIL PROTECTED]
