Re: OPO List Objects in Repeaters

In article <422snf$j0r_at_crl13.crl.com>, bworljon_at_crl.com (Barbara Worthing-Jones) wrote:

> It worked up until I tried child2.repeater.popup.updatelist() and got told
> that only aggregate functions worked in repeater fields [not the 1st time
> I've seen it].

It's a problem not being able to set object properties when the object is in a repeater. I hope Oracle fixes this soon. (send them a request!) For now, there is a way to get around it, but it's ugly.

1. Make a user-defined method in the control (popup) that sets the property you want. i.e.

  sub setme()
self.translation = "=select col2, col2 from table2 where table2.col1 = '" & form1.field1.value & "'"
(you could probably put a call to self.updatelist here too if needed)

2) Make a user-defined method in the repeat_panel that finds the control whose property you want to set and calls it. i.e.

  sub setme()
f = self.firstchild
i = 0
while i = 0
  if f.name = "popup1" then i =1 else f = self.nextcontrol() wend
f.setme

3) Make a user-defined method in the repeater that calls the repeat_panel method, i.e.

  sub setme()
firstchild.setme

4) Call the repeater method from somewhere like the postchange() method of a text field, i.e.

form1.repeater.setme

I told you it was ugly. I hope there's a better way to do this, but I haven't found it yet. Regards,

Michael Kranzdorf                      ---           mikek_at_krt.com
Director of Information Systems        ---                NYSE:KRT
Kranzco Realty Trust                   ---            610.941.9292