Home » Developer & Programmer » Forms » Record Count and Duplicate records
Record Count and Duplicate records [message #256905] Tue, 07 August 2007 01:33 Go to next message
swapnajojo
Messages: 40
Registered: June 2007
Location: India
Member

Hi Team,

1)Is there a way to find the record count in forms ?

2)is there a way to track the duplicate records in a form


Thanks In Advance
Binuja


Re: Record Count and Duplicate records [message #256908 is a reply to message #256905] Tue, 07 August 2007 01:41 Go to previous messageGo to next message
azamkhan
Messages: 548
Registered: August 2005
Senior Member
Use a post query trigger on the block level for which you want to count the no. of records. In the trigger increment by 1 in a parameter and after execute query you can find the number of records.

For checking duplicate records you have to either working on form. I mean write a procedure that will check and compaire each record for duplication after execute query.

Or write a query will compare each record by it self, I mean write a self join query.
Re: Record Count and Duplicate records [message #256909 is a reply to message #256905] Tue, 07 August 2007 02:01 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Look at the 'count_query' command. Search this forum for 'count_query'.

David
Previous Topic: get screern area resolution
Next Topic: FRM-30425
Goto Forum:
  


Current Time: Thu Dec 08 14:41:51 CST 2016

Total time taken to generate the page: 0.10642 seconds