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

Report message to a moderator

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: 557
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.

Report message to a moderator

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: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Look at the 'count_query' command. Search this forum for 'count_query'.

David

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 27 04:25:35 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.