Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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.
Thank you!