| ... Help for Next_Record [message #122266] |
Sat, 04 June 2005 09:24  |
orcl_dba
Messages: 84
Registered: March 2005
|
Member |
|
|
declare
total number(4):=0;
Begin
Hi i know this post contains a very basic level question but then again i would like expert to answer this so that many other junior people can get benefit for that ..
i want to calculate the total number of records in a data block..
i have a button and a text item..
i want that wheneever i press button the text box will show the total number of records that particular table ( data block) contains..
this is the code i m using but showing me error..
i checkd that if the cursor is on the last record.. then move it to first record and while its not last record add one number to total and in the end i display the total..
Hope to reveive early replies..
If (:system.last_record=True) Then
Move(:system.First_record);
while (system.last_record<>True)
Next_record;
total := total + 1;
End while;
:T3:= total;
end if ;
end;
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
