The following is a listing of some of the calculated variables on a form named :
fmtype_g_cusform, that is based on a table named : g_transactions.
The following is the formula for a page footer which gives me the number of records in the table,
the number of records in the query and the sequence number of the record in the query that is displayed.
NOW.... I have used both 'show_count' and 'new_show_count' and both fail in the same way.
If you are on the last record when the form is initiated, it will state 'record 200 of 200'. (In case you might
wonder how that is accomplished, go to the last record, go to design mode and then save and return)
If you are sequencing thru the records, all of the numbers are correct until you reach the last record.
The display stays at the second last record number eg: '199 of 200'. If you jump from any record to the last
record, the record number stays on the number of the previous record displayed.
Is there any way to make the variable 'item_num' display the last record number correctly??
D
fmtype_g_cusform, that is based on a table named : g_transactions.
Code:
item_num = run_count(Tbl_Record_Id) show_count = count(Tbl_Record_Id) new_show_count = :fmtype_g_cusform.Records_Get()
the number of records in the query and the sequence number of the record in the query that is displayed.
Code:
pg_rec_footer = "Record Number "+alltrim(str(calc->Item_Num,5,0))+" of " +alltrim(str(calc->New_Show_Count))+" Records in the Searched Set. (" +alltrim(str(reccount("g_transactions")))+" Total Records in the Table.)"
If you are on the last record when the form is initiated, it will state 'record 200 of 200'. (In case you might
wonder how that is accomplished, go to the last record, go to design mode and then save and return)
If you are sequencing thru the records, all of the numbers are correct until you reach the last record.
The display stays at the second last record number eg: '199 of 200'. If you jump from any record to the last
record, the record number stays on the number of the previous record displayed.
Is there any way to make the variable 'item_num' display the last record number correctly??
D
Comment