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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

retrieve a single project record with econnect

(0) ShareShare
ReportReport
Posted on by 450

I am using econnect 9. When trying to retrieve one Project_Acct_Project record using 

 eConnectOut.WhereClause = "PAPROJNUMBER = '[InsertProjectNumberHere]'"; 

I am recieving over a thousand records.

 

Is there any way to just get a single record without using the index?

*This post is locked for comments

I have the same question (0)
  • Community Member Profile Picture
    on at

    If you're running into the same problem I did, the problem is likely that you're still hitting the shadow tables instead of the real thing. Try setting FORLIST to 1 and see if that doesn't improve your results.

     Jacob

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans