You’re offline. This is a read only version of the page.
Announcements
511
Dear Experts
Hope all are fine and safe.
Need your support to solve the issue
I have two tables
Frequncy master-Item id, frequency
Inventsserial-Itemid, status, sub part id(1 item id in frequency master can have many sub part id)
I have new customized form where
item id, countoftstatus(taken from inventserial like machine, available, issued etc)
I want to get count of subpart which are due in last 15 days(today-15 dayd back) and display on grid
The issue is
in display method if i write while select table a join table b where iitemid==itemid , and put that display on grid, the form takes time to load and also the grid flcikers
If i add addcachemethod in the init of form datasorce the user cannot open the form(not sure what cacheaddmethod has to do with user opening forms)
can you please tell me how can i use while loop in display method and also make sure the form dont take time to load and the grid is not blining(the grid only blinks because of while loop and while loop use only retrives correct values)
Hi - instead of using join, can you try using exist join and check the code.
thanks
Hi,
Share your code so it is easier for us to help you.
Please share the code you have currently so that we can look for a solution.
Thanks for the quick reply. I have written the diplay method on the frequency master same like above
However if i use the select loop it dont retrieves value as it dnt loop through all records hence using the while loop ig loops through all the reords
how do i loop the records if not use of while
Hi,
Could you please share the code you are using for display method?
Is the code at the form level or at the table level?
Also, why are you using while select? Can you not do a count(recId)
Share
Report
All responses (
Answers (
Counter numofSubPart;
slect count(RecId) from table A
join tableB where tableB.ItemId == tableA.ItemId;
numofSubPart = tableA.RecId;
return numofSubPart;
#1
André Arnaud de Cal...
293,304
Super User 2025 Season 1
#2
Martin Dráb
232,149
Most Valuable Professional
#3
nmaenpaa
101,156
Moderator
