Repeater fields

Whenever I try to reference an object in a repeater, I get an error message telling me that “Repeated control can be used only in aggregation function”. How can I reference a field in a repeater?

I would venture to guess that every OPO developer has come across the fabulous Bas 00394 error message at least one time, and quite probably was vexed by it, at least for a while.

It seems ridiculous that you cannot access an object in a repeater. Just because you are using a repeater to display multiple rows of data does not mean that you don’t want to access individual rows.

The OPO designers did give you some very nice functionality with the repeater – the ability to easily use an object in the repeater for aggregate functions like SUM(), COUNT() or AVG(), where a simple reference to the object will give you aggregates of the values of all instance of the object. This made it difficult to use the same object name in references that do not require all of the objects in the repeater.

You can overcome this problem by remembering that a repeater control is really a window into a recordset. If you want to get the value for an object in the current row selected in a repeater, you can use the


function combination for the recordset, and other recordset methods for setting the value of the object. Any and all changes in the underlying recordset are immediately reflected in the repeater.

If you want to search through the values in a repeater, use an loop to walk through the values of the underlying recordset

Share the Post:
Share on facebook
Share on twitter
Share on linkedin


The Latest

microsoft careers

Top Careers at Microsoft

Microsoft has gained its position as one of the top companies in the world, and Microsoft careers are flourishing. This multinational company is efficiently developing popular software and computers with other consumer electronics. It is a dream come true for so many people to acquire a high paid, high-prestige job

your company's audio

4 Areas of Your Company Where Your Audio Really Matters

Your company probably relies on audio more than you realize. Whether you’re creating a spoken text message to a colleague or giving a speech, you want your audio to shine. Otherwise, you could cause avoidable friction points and potentially hurt your brand reputation. For example, let’s say you create a

chrome os developer mode

How to Turn on Chrome OS Developer Mode

Google’s Chrome OS is a popular operating system that is widely used on Chromebooks and other devices. While it is designed to be simple and user-friendly, there are times when users may want to access additional features and functionality. One way to do this is by turning on Chrome OS