Home » Developer & Programmer » Forms » prevent duplicate data entry (form builder 6i)
icon4.gif  prevent duplicate data entry [message #344153] Thu, 28 August 2008 22:39 Go to next message
fadhzone
Messages: 61
Registered: April 2008
Member
hi experts...

my form multiple colums n rows just like this :

branch 9999 xxxxxxxxxxxxxxxxxx
slip no 99999999


no payee code payee name cheque date ref.no
----------------------------------------------------------
99 xxxxxx xxxxxxxxxxxxxxx dd/mm/yyyy xxxx
99 xxxxxx xxxxxxxxxxxxxxx dd/mm/yyyy xxxx
99 xxxxxx xxxxxxxxxxxxxxx dd/mm/yyyy xxxx
99 xxxxxx xxxxxxxxxxxxxxx dd/mm/yyyy xxxx
99 xxxxxx xxxxxxxxxxxxxxx dd/mm/yyyy xxxx

how can i write the script to make sure the user
1)will not enter same payee code?
2)will not enter difference month and year(can be difference day) of cheque date.all the cheque month must be entered base on first row?

the records will grow as much as user enter.

thanks. Embarassed
Re: prevent duplicate data entry [message #344158 is a reply to message #344153] Thu, 28 August 2008 23:25 Go to previous messageGo to next message
hamidmahmood
Messages: 30
Registered: August 2006
Member
AoA

1 First count the record with respect to your requierd where clause for eg where year=:ab.year

2 Then if Count> 0 then dispaly message you already enter this record.

3 else do which u want

you may use this code in On-next_key ,validate Trigger


depend on your senario



Re: prevent duplicate data entry [message #344197 is a reply to message #344158] Fri, 29 August 2008 01:31 Go to previous messageGo to next message
fadhzone
Messages: 61
Registered: April 2008
Member
ok..i got what mean..but i dont know how to write it..
i really cannot write the script that involve with looping Embarassed
Re: prevent duplicate data entry [message #344386 is a reply to message #344197] Fri, 29 August 2008 10:14 Go to previous messageGo to next message
durgadas.menon
Messages: 365
Registered: December 2007
Location: Nowhere
Senior Member
you will need to learn SQL and PL/SQL for this..start by searching the net
Re: prevent duplicate data entry [message #344439 is a reply to message #344153] Fri, 29 August 2008 16:12 Go to previous messageGo to next message
Littlefoot
Messages: 20891
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
There've already been similar questions (and answers) on this forum; use its Search facility).
Re: prevent duplicate data entry [message #344466 is a reply to message #344439] Fri, 29 August 2008 22:19 Go to previous messageGo to next message
fadhzone
Messages: 61
Registered: April 2008
Member
i already used search facility but i couldn't find the similiar case..please help me.. Embarassed Sad
Re: prevent duplicate data entry [message #344477 is a reply to message #344153] Fri, 29 August 2008 23:59 Go to previous messageGo to next message
hamidmahmood
Messages: 30
Registered: August 2006
Member
Dear try it you will get it in this way you learn more
Re: prevent duplicate data entry [message #344524 is a reply to message #344466] Sat, 30 August 2008 03:27 Go to previous message
Littlefoot
Messages: 20891
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
fadhzone wrote on Sat, 30 August 2008 05:19
i already used search facility but i couldn't find the similiar case..please help me

I'm afraid you'll have to upgrade your search skills. This question really has been asked and answered. I've been hanging around this forum for quite a while now, and I know that the answer exists. Do your homework and search for the answer by yourself. Spoonfeeding ./fa/3943/0/ season is over.
Previous Topic: form error
Next Topic: Icon Display
Goto Forum:
  


Current Time: Sun Dec 04 08:48:30 CST 2016

Total time taken to generate the page: 0.13898 seconds