Welcome! Log In Create A New Profile

Advanced

Drag'n'Drop

Posted by Aelfassi 
Forum List Message List New Topic
Aelfassi
Drag'n'Drop
June 09, 2009 12:41PM
Hello,

I have two memory tables filled from queries, I would like to drag a row from source table to destination table but if the record exists already in the destination table the drop is cancelled.

If somebody has done this before, I appreciate his help.

Regards,
Reply Quote
Jan de Bruin
Re: Drag'n'Drop
June 09, 2009 03:19PM
Hoi

You can do a tableseek in the second table and take actiojn or no action ??


Jan
Reply Quote
Frans
Re: Drag'n'Drop
June 09, 2009 06:54PM
Hello Aelfassi ,

Has the second table a unique field?

Reply Quote
Aelfassi
Re: Drag'n'Drop
June 09, 2009 09:45PM
Hi Frans,

Yes, there is an ID Column, which is the same as the Source Table. The source Table is from Database A and the Destination table is from Database B, I want to take just records that are not in the Database B to update it.

Regards,
Reply Quote
Newer Topic Older Topic
Author:

Your Email:


Subject:
Spam prevention:
Please, enter the code that you see below in the input field. This is for blocking bots that try to post this form automatically. If the code is hard to read, then just try to guess it right. If you enter the wrong code, a new image is created and you get another chance to enter it right.
Message: