OraFAQ Forum: Forms » prevent duplicate data entry

Home » Developer & Programmer » Forms » prevent duplicate data entry (form builder 6i)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

prevent duplicate data entry [message #344153]

Thu, 28 August 2008 22:39

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

Report message to a moderator

Re: prevent duplicate data entry [message #344158 is a reply to message #344153]

Thu, 28 August 2008 23:25

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

Report message to a moderator

Re: prevent duplicate data entry [message #344197 is a reply to message #344158]

Fri, 29 August 2008 01:31

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

Report message to a moderator

Re: prevent duplicate data entry [message #344386 is a reply to message #344197]

Fri, 29 August 2008 10:14

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

Report message to a moderator

Re: prevent duplicate data entry [message #344439 is a reply to message #344153]

Fri, 29 August 2008 16:12

Littlefoot
Messages: 21826
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).

Report message to a moderator

Re: prevent duplicate data entry [message #344466 is a reply to message #344439]

Fri, 29 August 2008 22:19

fadhzone
Messages: 61
Registered: April 2008

Member

i already used search facility but i couldn't find the similiar case..please help me.. Embarassed

Report message to a moderator

Re: prevent duplicate data entry [message #344477 is a reply to message #344153]

Fri, 29 August 2008 23:59

hamidmahmood
Messages: 30
Registered: August 2006

Member

Dear try it you will get it in this way you learn more

Report message to a moderator

Re: prevent duplicate data entry [message #344524 is a reply to message #344466]

Sat, 30 August 2008 03:27

Littlefoot
Messages: 21826
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 /forum/fa/3943/0/

season is over.

Report message to a moderator

Previous Topic:	form error
Next Topic:	Icon Display

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Sep 11 16:44:36 CDT 2025