web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics SL (Archived)

How do I search a loaded grid for a value?

(0) ShareShare
ReportReport
Posted on by 1,639

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?

*This post is locked for comments

I have the same question (0)
  • Barry Flynn Profile Picture
    3,090 on at

    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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics SL (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans