Page 1 of 1

ODBC Updates twice

Posted: Mon Feb 11, 2008 9:08 am
by G SHIVARANJANI
Hi,

I am working on ODBC stage to connect progress database.

I am applying join on two tables and then getting two records as a result of the join.

and then after getting the two records , am trying to update the two records depending on the keys

But while updating i have kept a reject link to ODBC stage.

so the update occures twice(as per the Log)

If i remove the reject link the update happens only once.

Please suggest

Posted: Mon Feb 11, 2008 4:27 pm
by Teej
Huh?

It is behaving exactly what you want.

2 records, 1 record updated in original stage, and 1 got rejected and updated in the follow-up ODBC stage.

Remove reject link, only 1 get updated as originally.

I don't see what the problem is, can you clarify?

Posted: Tue Feb 12, 2008 1:03 am
by G SHIVARANJANI
Teej wrote:Huh?

It is behaving exactly what you want.

2 records, 1 record updated in original stage, and 1 got rejected and updated in the follow-up ODBC stage.

Remove reject link, only 1 get updated as originally.

I don't see what the problem is, can you clarify?

the issue is Both the records should be updated in ODBC even in the absence of reject link. But only one record is getting updated.