Re: Is is possible in forms6 ?

okay, then perhaps this way (you have to name your items in a sequence-manner, like ITEM1, ITEM2, ITEM3...):

DECLARE
  Counter NUMBER := 1;
BEGIN
  LOOP
    EXIT WHEN Counter = <WhatEver>;
    IF Name_In ('Block1.Item'||To_Char(Counter)) != Name_In ('Block2.Item'||To_Char(Counter)) THEN

      ...
    ELSE
      ...
    END IF;
    Counter := Counter + 1;
  END LOOP;
END; rds1 <rstolarek_at_jmk.lodz.pl> schrieb in im Newsbeitrag: v9wW4.19843$zA1.501603_at_news.tpnet.pl...
> I would like to loop through the records on first block and compare values
> of all fields in first block to corresponding values in the second block
> without doing
>
> GO_BLOCK('second_block')
> find the corresponding record to the record in first_block.
> Compare values of the fields in current record to the values in first
 block.
>
> Something like you access data in an array to compare values.
>
> block1.item1[1] - first record in block 1
> block1.item1[2] - second record in block 1
>
> block2.item1[1] - first record in block 2
> block2.item1[2] - first record in block 2
>
>
>
>
> u¿ytkownik Markus Schwabe <mschwabe_at_gscout.de> w wiadomo¶ci do grup
> dyskusyjnych napisa³:8gdu58$eds$1_at_news4.muc.eurocyber.net...
> > IF :<BlockName1>.<ItemName1> != :<BlockName2>.<ItemName2> THEN
> > ...
> > ELSE
> > ...
> > END IF;
> >
> >
> > rds1 <rstolarek_at_jmk.lodz.pl> schrieb in im Newsbeitrag:
> > dWtW4.19062$zA1.483070_at_news.tpnet.pl...
> > > I have 2 database multirecord blocks on 2 canvas.
> > > The first canvas is the for updating,inserting data into blocks
> > > The second canvas is only for viewing data.
> > > Blocks have the same fields.
> > >
> > > I would like to change colour of a field in multirecord block which
 value
 is
> > > diffrent (when I've made update of the field ) then the corresponding
> > > field's value on the viewer block.
> > >
> > > My question is :
> > > How to figure out that the values are diffrent without going to both
 fields
> > > and using
> > > :system.cursor_value to compare the values.
> > >
> > >
> > >
> > >
> >
> >
>
>
Received on Tue May 23 2000 - 00:00:00 CEST