Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics SL forum
Unanswered

How do I search a loaded grid for a value?

Posted on by 1,615

When the user adds a new line to the grid (tasks tab on the Project Maintenance) , I want to check through all  values already in the grid to see if a certain value has been entered before.   The value I am looking at is a new field I have added to the grid - PJPENT.User1.

Can anyone help me please?

  • Barry Flynn Profile Picture
    Barry Flynn 3,090 on at
    Re: How do I search a loaded grid for a value?

    Just a couple of quick comments

    Its difficult to "scan existing items in the grid" while a grid line is being entered or modified.

    This is because you need to navigate the array "behind the grid" at a time when the "current" grid lien has not been inserted/updated into that array.

    So, if you do an "mFirst" you will probably clobber the line you are currently working on.

    You may be able to od it at Save time.

    Your code would do something like (and I am typing from memory, so there will be lots of typos

    - use mGetRowNum to find the current grid row number.

    - Use mFirst / mNext to navigare the grid, looking at your value.

    - If you should decide that some sort of error requires fixing, use MessBox to put up the error warning, and set RetVakl to ErrNoMess to prevent the Save from proceeding

    - And, use mSetRowNum, followed by mDisplay to "reset the grid" to "where it was" before you strarted traversing it.

    Hope that's some help...

    Barry

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,537 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,520 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans