NetTalk Central

Author Topic: How do I not to display a row not using a filter  (Read 3335 times)

terryd

  • Hero Member
  • *****
  • Posts: 759
    • View Profile
    • Davcomm
    • Email
How do I not to display a row not using a filter
« on: December 02, 2014, 11:44:15 PM »
I have a browse on Claim table which is a child of a form.
It is filtered based on the value in one of the fields (CLA:ImageExists Yes/NO) which works fine.
However I would like to additionally restrict  on a value which is in a parent file of Claim.
I can't do this in the filter because at the time of creation of the filter I am not accessing the related parent file record.
What I need to do is something like the RECORD:Filtered return value which we use in standard Clarion after the call to PARENT:ValidateRecord.
Is there anyway to do this in the ValidateRecord embed point?
Terry Davidson
Windows 10 64 bit/Windows7 64bit
Clarion 9.1.11529/Clarion10 12567
Nettalk 913
Nettalk 1015
StringTheory267/Winevent515/XFiles298/MessageBox239/Cryptonite186

Robert Iliuta

  • Sr. Member
  • ****
  • Posts: 472
    • View Profile
    • Email
Re: How do I not to display a row not using a filter
« Reply #1 on: December 02, 2014, 11:56:35 PM »
Hallo Terry,

try this in ValidateRecord:

if CLA:Images = 1 then CYCLE.

Robert

terryd

  • Hero Member
  • *****
  • Posts: 759
    • View Profile
    • Davcomm
    • Email
Re: How do I not to display a row not using a filter
« Reply #2 on: December 03, 2014, 12:25:35 AM »
Thanks Robert
I'll give it a go.
Terry Davidson
Windows 10 64 bit/Windows7 64bit
Clarion 9.1.11529/Clarion10 12567
Nettalk 913
Nettalk 1015
StringTheory267/Winevent515/XFiles298/MessageBox239/Cryptonite186

terryd

  • Hero Member
  • *****
  • Posts: 759
    • View Profile
    • Davcomm
    • Email
Re: How do I not to display a row not using a filter
« Reply #3 on: December 03, 2014, 03:31:54 AM »
Hi Robert thanks

That worked 100%
Much appreciated
Terry Davidson
Windows 10 64 bit/Windows7 64bit
Clarion 9.1.11529/Clarion10 12567
Nettalk 913
Nettalk 1015
StringTheory267/Winevent515/XFiles298/MessageBox239/Cryptonite186