Re: Help!!How to check number of records been displayed?
From: John Strange <jstrange_at_imtn.dsccc.com>
Date: 1996/12/17
Message-ID: <596e33$rjg_at_camelot.dsccc.com>#1/1
: I am creating a FORM which has two blocks. There is a field called #RECORDS
: which will control the total number of records that user can enter in the
: BLOCK II.
: For instances,
: if #RECORDS = 10, then block II can only have 10 records entered.
Date: 1996/12/17
Message-ID: <596e33$rjg_at_camelot.dsccc.com>#1/1
select max (rowid) into :ctrl.rec_total from block1's table in your block2 when_new_block_instence trigger.
Test and bump your block2 counter in block2 preinsert trigger. reduce your counter in block2 post delete trigger.
ignore any misspells please.
Joe (kauj_at_lfs.loral.com) wrote:
: Hello,
: I am creating a FORM which has two blocks. There is a field called #RECORDS
: which will control the total number of records that user can enter in the
: BLOCK II.
: For instances,
: if #RECORDS = 10, then block II can only have 10 records entered.
: Now, question is how can I get the total number of records that BLOCK II
: have, so I can use this number to compare with the #RECORDS in BOLCK I.
: This case, I can stop the user entering extra record in block II.
: Any help will be appreciated.
-- This posting represents the personal opinions of the author. It is not the official opinion or policy of the author's employer. Warranty expired when you opened this article and I will not be responsible for its contents or use.Received on Tue Dec 17 1996 - 00:00:00 CET