ODBC Updates twice

G SHIVARANJANI · Post by **G SHIVARANJANI** » Mon Feb 11, 2008 9:08 am

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

Teej · Post by **Teej** » Mon Feb 11, 2008 4:27 pm

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?

G SHIVARANJANI · Post by **G SHIVARANJANI** » Tue Feb 12, 2008 1:03 am

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.