I am getting the following compile error. Does anyone know what this means.
Numeric expression expected. (While expanding macro 'db.retry.point')
'exit' not expected. (While expanding macro 'db.retry.point') Here is my code

select tiitm001.targ
from tiitm001 for update
where tiitm001._index1 = {:item}
selectdo
db.retry.point()
message = "Updated"
tiitm001.targ = n.wght
db.update(ttiitm001, db.retry)
commit.transaction()
endselect

The error message is stating the error line with code - db.retry.point().

Thanks in advance for any help.

Hi,

I tried your code. I got a different error which is "old fashion function call: use message()"

When I changed that, the code was compiled successfully.

- George

Message is a function indeed, so you better rename it. The retrypoint should be before the SELECT FOR UPDATE query. Have you tried this?

db.retry.point()
select tiitm001.targ
from tiitm001 for update
where tiitm001._index1 = {:item}
selectdo
mesg = "Updated"
tiitm001.targ = n.wght
db.update(ttiitm001, db.retry)
endselect
commit.transaction()

Hope it helps,
Dick

Thank you so much. Poor choice of the name of my variable.