Validate record in browse

[sabra]

Hi,

I have a browse with parts. I only want to display records which have a record in an other table. Normally i would use the ABC validaterecord() method and return record:filtered

What's the nettalk equivilent?

My code in the netbrowse validaterecord is :

  if LRA:ProductGrp
    krg:Levnr   = LRA:LevNr
    krg:CDsuppl = clip(LRA:ProductGrp)
     
    if ~access:kortinggroep.fetch(krg:FKeyLevnr)
       kra:Relnr   = p_web.GSV(g_eUsername)
       kra:CD      =  krg:CD
       if access:kortingAfspraak.fetch(kra:FKeyRelnr) = level:benign
         Found = True
       end
    end  !access
     
  end !value <> 0
     
  if ~found
  end


Best Regards

Walter van der Horst
Sabra Systems
The Netherlands

[Rob Mikkelsen]

Walter,

Look for the embed point

Inside Browse Loop
1.  Validate Record

  add your code ...
  if ~found
     CYCLE
   end

Look at the source code for specific syntax.  I haven't tried it (I usually use a filter) but it should work.

Rob

[Rene Simons]

Walter/Rob,

Cycle works just fine.

René