Field Reference parameter

[Peter van Rooij]

Hello Xavier

Calculate lFieldName as ‘Whatever'
Do ivMaestro.$TestForAUniqueIndexValue(lFieldName) Returns #F 


> On 17 Jan 2018, at 16:53, IT <it at plastipol.com> wrote:
> 
> Hi All,
> 
> I have a table with a method to test for a unique index value running SQL not DML.
> The method $TestForAUniqueIndexValue has a Field parameter.
> If i pass a variable, the method works ok. Any try to use some kind of dynamic parameter fails.Things like a calculation results in an error: "Attempt to assign a calculation to a field reference parameter”. Using the nam() function or enclosing the variable name in quotes or square bracket fail.
> 
> This works
> Do ivMaestro.$TestForAUniqueIndexValue(ivMaestro.USR_CODIGO) Returns #F 
> 
> This doesn’t work
> Do ivMaestro.$TestForAUniqueIndexValue(#EN) Returns #F     ;; 
> 
> Any one know if there is a way to send the name of the field as a parameter in a dynamically way?
> 
> regards
> 
> 
> xavier 
> _____________________________________________________________
> Manage your list subscriptions at http://lists.omnis-dev.com