| function [message #141091] |
Thu, 06 October 2005 22:09  |
selvakumar_82
Messages: 138
Registered: October 2005
Location: chennai
|
Senior Member |
|
|
Hi ,
go_block('transview');
EXECUTE_QUERY;
first_record;
while :transview.UD1_TRANSACTION_ID is not null loop
................
.....................
In this coding , Exe_query is a procedure or executes following query,
Or better anyone explain what is the operation of coding
|
|
|
|
| Re: function [message #141098 is a reply to message #141091] |
Thu, 06 October 2005 23:37  |
 |
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
|
Senior Member
Account Moderator |
|
|
I assume that this is in a When-Button-Pressed trigger ... it looks like a manual replacement for a Post-Query trigger. I again assume that there is a next_record statement in the loop.
I would put the code that is in the loop in a Post-Query trigger making sure that the next_record statement is removed. That way, the WHOLE table is not loaded but just the number of records specified in the block properties. It would give you a faster 'first screen' response.
David
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
