Question Easiest way to find queries with share-lock?

[Topi]

Hi,

From time to time we find code which has query without no-lock or exclusive-lock. This causes share-locks which causes problem.

Is there any tool available which would go through code repository and point out code without specified locks?

Thanks!

 

[Stefan]

Add -NL to your compile session and any query without a lock status will default to NO-LOCK. Beware that this can give issues when attempting to update a record which has a missing lock status.

 

[TomBascom]

Proparse.

 

[Topi]

Thanks for the ideas. I'll play with Proparse. Enabling -NL would be too risky.

 

[Stefan]

At a minimum turn on -NL on your development and possibly test environments - it will catch your forgetfulness as soon as as you attempt to run the code you are working on instead of having to wait for another proparse batch run to catch it.

 

[Topi]

Do you know if Proparse is compatible with Progress 10.1C? Installation instructions are mentioning OE Architect, which is found from version 10.2B and later(?).

 

[Rob Fitzpatrick]

OpenEdge Architect existed in 10.1C.
http://community.progress.com/cfs-f...nts-files/00-00-00-00-15/0572.oearchitect.pdf

 

[tamhas]

Proparse has no 11.x syntax, but everything below that.