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
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
#1
André Arnaud de Cal...
291,711
Super User 2024 Season 2
#2
Martin Dráb
230,458
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
