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

Announcements

News and Announcements icon
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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the June Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics SL (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans