We have a process which selects a record from a progress table, then issues an update against that record.
If we do not do the select, then the update works all day long. If we do the select, then the update times out.
The select query is pretty simple and looks like:
select fg."alphakey", n."first-name", n."last-name"
from pub.name n
inner join pub."family-guardian" fg
on (fg."name-id" = n."name-id")
where fg."alphakey" = 'somevalue'
We've confirmed that if the above statement is not present then it works. However, if the above statement is present then the *UPDATE* fails. The update goes against the name table. Unfortunately, I don't have that code as it executes through a third party.
Two questions:
- Is this normal for progress?
- What is the best way to get around the issue?
Asked by ChrisLively
(887 rep)
Sep 24, 2012, 04:06 PM
Last activity: May 6, 2014, 05:01 PM
Last activity: May 6, 2014, 05:01 PM