Subject Re: [IBO] Master detail Bug with MasterParamLinks?
Author Jason Wharton
> I thought the inside mechanism was:
> SELECT *
> FROM ORDERS
> WHERE CUSTNO=:P_CUSTNO
> And put on MasterParamLinks:
> P_CUSTNO=CUSTOMER.CUSTNO
>
> IBO Retrieves master CUSTOMER.CUSTNO and place it into a variable
> labeled as "P_CUSTNO"
>
> Use that label to associate
> ParamByName('P_CUSTNO').Value = P_CUSTNO.VALUE
>
> so P_CUSTNO can be "P_WHATEVER", since is chained to the field in the
> WHERE by the WHERE itself (WHERE CUSTNO=:P_WHATEVER).
> If not, I don't see really advantages over MasterLinks where field
> names must be the real ones... or there are situation where you can't
> do without MasterParamLinks?

I'm missing something because I fail to see what the problem is.

There is nothing special about the P_ prefix. You simply gave that as a name
for your parameter and told IBO the column in the master dataset to get its
value from. If you want that value to also be plugged into a column when
inserting a record you have to make the parameter name the same as the
column name to receive the value. That is the way I designed it to work and
that is what I believe it does. If it doesn't, that is what I will make it
do if you say it isn't doing that.

Regards,
Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com