matchew
New Member
Good Day,
I am having a trouble with displaying the results of my open query statement to the browse.
Legend
Program Name: memberName.w
Open Query: OPEN QUERY {&browse-name} FOR EACH MemberInf
WHERE MemberInf.lNAME + " " + MemInf.FName BEGINS SELF:SCREEN-VALUE
AND memInfo.memStatus NE MemAppCode.
Problem: First Search of name in the program memberName.w the display of the open query Result to the browse is very slow it makes the window not responding it takes like 10-15 secs to wait.
Second Search everything is OK.
I tried to use index but it makes it even slower I don't know what to do can anyone provide some help?
and I think there is nothing wrong with my search query for the Fill-In.
I am having a trouble with displaying the results of my open query statement to the browse.
Legend
Program Name: memberName.w
Open Query: OPEN QUERY {&browse-name} FOR EACH MemberInf
WHERE MemberInf.lNAME + " " + MemInf.FName BEGINS SELF:SCREEN-VALUE
AND memInfo.memStatus NE MemAppCode.
Problem: First Search of name in the program memberName.w the display of the open query Result to the browse is very slow it makes the window not responding it takes like 10-15 secs to wait.
Second Search everything is OK.
I tried to use index but it makes it even slower I don't know what to do can anyone provide some help?
and I think there is nothing wrong with my search query for the Fill-In.