On Feb 28, 2009, at 8:56 PM, tim awa wrote:
> I would guess that the order which these values are returned by
> getParams
> match the order of the parameter declaration in the WHERE clause.
> Correct?
Well, yeah, unless you like surprises! ;-)
> Hmmm ... how about this:
>
> select * from tbldoc where position('%s' in docnote) > 0
>
> In the above sql, I am trying to select records whose docnote field
> contains
> the parameter string. Let us just suppose that this parameter is set
> by the
> user from a bizobj lookup table. Can one get the parameter value off
> the
> bizobj after the user has set the record pointer of the lookup
> dataset?
I wouldn't get the value from the bizobj; instead, when the user
makes the selection, the form would get that value from the control
and call a bizobj method, passing the value. The unrelated bizobj may
be needed for the lookup values, but if you aren't using that value in
a foreign key relationship, then the form should just pass it to the
main bizobj.
-- Ed Leafe
_______________________________________________
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]
