Subject | Re: [IBO] Difference between MasterLinks Parameter and normal Parameter? |
---|---|
Author | Andreas Hesse |
Post date | 2005-06-15T07:58:18Z |
Alan McDonald wrote:
Example:
The Sql is: select * from employee where Dep_ID = :My_Filter_Dep
MasterSource is set to: DsLand
MasterLinks are set to: Land=Land
So I get 2 Params after Preparing.
Now I want to know the source of the param:
1) Source is SQL -> Show some information about it
2) Source is MasterLinks -> internal parameter, don't show information
The only way I see now is the parametername. Internal parameters have
special names.
Any other ways?
Thanks,
Andreas
>>>How can I differ between a normal Parameter of a QueryI want to find out the source for a param:
>>>(defined in SQL
>>>property) and an automatic Parameter defined for example with
>>>MasterLinks?
>>>
>>>I searched the help file and didn't find an answer.
>>
>>You make use of the MasterParamLinks property that allows you to link a
>>parameter value to the value in another query referenced via MasterSource.
>>
>>PARAMNAME=MASTERCOLUMN
>>
>>Jason Wharton
>
>
> I think he would like to combine mastersource fields with a secondary query
> not referenced in mastersource
> Alan
>
>
>
Example:
The Sql is: select * from employee where Dep_ID = :My_Filter_Dep
MasterSource is set to: DsLand
MasterLinks are set to: Land=Land
So I get 2 Params after Preparing.
Now I want to know the source of the param:
1) Source is SQL -> Show some information about it
2) Source is MasterLinks -> internal parameter, don't show information
The only way I see now is the parametername. Internal parameters have
special names.
Any other ways?
Thanks,
Andreas