NetTalk Central

Author Topic: Not displaying a record on a record by record basis  (Read 2820 times)

terryd

  • Hero Member
  • *****
  • Posts: 759
    • View Profile
    • Davcomm
    • Email
Not displaying a record on a record by record basis
« on: November 24, 2012, 09:02:47 PM »
In normal Clarion I can stop a record from displaying on the browse by entering a
returnvalue = RECORD:Filtered in the
Local Objects\Abc Objects \ Browse on whatever\Validate Record\code After the parent call embed.
In NT I have created a filter which work fine. However under certain circumstances I want to further restrict the records displayed if a child record for the record exists
In Clarion I would enter something like
childfield = parentfield
get(childfile,keychieldfield)
IF errorcode()
    ReturnValue = RECORD:Filtered
END
in the above embed point to further restrict my browse.


What is the best way to do this in NT?
Terry Davidson
Windows 10 64 bit/Windows7 64bit
Clarion 9.1.11529/Clarion10 12567
Nettalk 913
Nettalk 1015
StringTheory267/Winevent515/XFiles298/MessageBox239/Cryptonite186

Bruce

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 11250
    • View Profile
Re: Not displaying a record on a record by record basis
« Reply #1 on: November 24, 2012, 11:05:03 PM »
Hi Terry,

there is a Validate Record embed in the netWebBrowse that does the same thing. Just CYCLE from there to exclude records or BREAK if you have come to the end of a range.

Cheers
Bruce



terryd

  • Hero Member
  • *****
  • Posts: 759
    • View Profile
    • Davcomm
    • Email
Re: Not displaying a record on a record by record basis
« Reply #2 on: November 25, 2012, 01:20:33 AM »
Works perfectly.
I saw the validate routine but I didn't know what the correct syntax was to get that result
Terry Davidson
Windows 10 64 bit/Windows7 64bit
Clarion 9.1.11529/Clarion10 12567
Nettalk 913
Nettalk 1015
StringTheory267/Winevent515/XFiles298/MessageBox239/Cryptonite186