OraFAQ Forum: Forms » HOW TO COMPARE ?

Home » Developer & Programmer » Forms » HOW TO COMPARE ?

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

HOW TO COMPARE ? [message #238614]

Fri, 18 May 2007 13:02

rajat_chaudhary
Messages: 141
Registered: November 2006
Location: india

Senior Member

Again Hi Everyone,
i want to compare multiple records( in Forms6i) with the multiple records in database using two tables havind parent-child relationship.

if the entering records are already exist in child table against any value of "foreign key" then
it is duplicate
else
saved.

REGARDS
RAJAT CHAUDHARY

Report message to a moderator

Re: HOW TO COMPARE ? [message #238973 is a reply to message #238614]

Mon, 21 May 2007 01:35

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Then write code in the Post-Query trigger that looks to see if the data exists and if it doesn't then 'insert' it.

If that doesn't work, then have a big button in the middle of the screen that runs a procedure to do the work.

David

[Updated on: Mon, 21 May 2007 01:36]

Report message to a moderator

Re: HOW TO COMPARE ? [message #239111 is a reply to message #238973]

Mon, 21 May 2007 09:06

rajat_chaudhary
Messages: 141
Registered: November 2006
Location: india

Senior Member

hi djmartin,
actually i want a coding of my question by which i can modify it for my requirement.
so can u please give me a module which is comparing multiple rows with multiple rows in the database.

THANKS IN ADVANCE

Report message to a moderator

Re: HOW TO COMPARE ? [message #239658 is a reply to message #239111]

Wed, 23 May 2007 00:15

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

How about you write some code and we help you to get it to work.

David

Report message to a moderator

Re: HOW TO COMPARE ? [message #239950 is a reply to message #239658]

Wed, 23 May 2007 13:28

rajat_chaudhary
Messages: 141
Registered: November 2006
Location: india

Senior Member

hi djmartin,
actually i am not understanding from where should to start the coding , so please forgive me for this.
and if possible then please lift me out of this dig......

Report message to a moderator

Previous Topic:	Stop Typing in Database Text Item
Next Topic:	Header & Line Level Information

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 27 02:14:36 CDT 2024