topic Re: Finding FieldValue from a specific table in script in App Development

Finding FieldValue from a specific table in script

zakpullen — Fri, 20 May 2022 09:29:04 GMT

Hi,

Is there a way to specifiy the table the field value should be returned from? This line is from a master calendar.

Max(FieldValue('PeriodDate', RecNo())) as MaxDate

Many thanks

Re: Finding FieldValue from a specific table in script

rubenmarin — Fri, 20 May 2022 10:21:20 GMT

Hi, FildValue() uses all values of the field, witout specifying the table. In the table you want to retrieve values you can add a field like "PeriodDate as PeriodDateCalendar" and use this field to iterato through it's values.

Also you can do a resident load but it will be slower if the table has many records.

Re: Finding FieldValue from a specific table in script

zakpullen — Fri, 20 May 2022 14:08:16 GMT

Thank you!