×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

How to use Validate Record embeds (Range Checking or Filter Checking)

How to use Validate Record embeds (Range Checking or Filter Checking)

How to use Validate Record embeds (Range Checking or Filter Checking)

(OP)
Hello every body,

I don't understand how using these embeds.

I need to add a filter in a browse, but the field I have to filtered is not a field of the record, but the result of a calc in "format an element of the browse queue".


For exemple :

"MyCondition" (S1) is the result of a calc/condition in "format an element of the browse queue".

I add "MyCondition" in the FileBoxFormat => the browse is OK and the good value for "MyCondition" is displayed for each line of the browse.

Now, I want to display only records where the value of "MyCondition" is 'Y'

I kwow I had to uses "Validate Records" embeds but I don't know how to do!

Thank you very much if you could help me

best regards

RE: How to use Validate Record embeds (Range Checking or Filter Checking)

(OP)
I forgot to say I'm in C5EE legacy

RE: How to use Validate Record embeds (Range Checking or Filter Checking)

(OP)
Nobody to help me?

RE: How to use Validate Record embeds (Range Checking or Filter Checking)

Hello,

The if condition returning record:filtered will filter out the corresponding record. The snippet below shows where about to put your condition.

In short returning a record:fitered will filter out the record in process.

Best Regards

Samir

BRW1::RecordStatus BYTE,AUTO
! [Priority 8500]

! End of "Browser Method Data Section"
CODE
! Start of "Browser Method Code Section"
! [Priority 2500]

! Parent Call
ReturnValue = PARENT.ValidateRecord()
! [Priority 5050]
if ~INSTRING('m',CLI:NAME,1,1)
ReturnValue = Record:Filtered
end

BRW1::RecordStatus=ReturnValue
IF BRW1::RecordStatus NOT=Record:OK THEN RETURN BRW1::RecordStatus.
! [Priority 6600]

ReturnValue=BRW1::RecordStatus
! [Priority 9000]

! End of "Browser Method Code Section"
RETURN ReturnValue

RE: How to use Validate Record embeds (Range Checking or Filter Checking)

(OP)
Thank you Samir ... very late!!!

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close