Home » Developer & Programmer » Forms » HOW TO COMPARE ?
HOW TO COMPARE ? [message #238614] Fri, 18 May 2007 13:02 Go to next message
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
Re: HOW TO COMPARE ? [message #238973 is a reply to message #238614] Mon, 21 May 2007 01:35 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT 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 Go to previous messageGo to next message
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
Re: HOW TO COMPARE ? [message #239658 is a reply to message #239111] Wed, 23 May 2007 00:15 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
How about you write some code and we help you to get it to work.

David
Re: HOW TO COMPARE ? [message #239950 is a reply to message #239658] Wed, 23 May 2007 13:28 Go to previous message
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......


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


Current Time: Wed Dec 07 05:02:31 CST 2016

Total time taken to generate the page: 0.12053 seconds