Consultor Eletrônico



Kbase P116008: -NL parameter is ignored with using buffer FIND methods
Autor   Progress Software Corporation - Progress
Acesso   Público
Publicação   22/05/2006
Status: Unverified

SYMPTOM(s):

-NL parameter is ignored with using buffer FIND methods

Compiling code with buffer method FIND-FIRST without lock statement and using -NL does not make the find use no-lock

Compiling code with FIND FIRST without lock statement and using -NL parameter causes the FIND statement to use no-lock

Client uses -NL startup parameter with code compiled with -NL still locks records when using FIND-FIRST buffer method

CAUSE:

This is a know issue being investigated by Development

FIX:

Change the code to add the NO-LOCK statement to the FIND-FIRST call.

Before workaround:
hCustBuff:FIND-FIRST("WHERE customer.custNum > 100").

After applying workaround:
hCustBuff:FIND-FIRST("WHERE customer.custNum > 100", NO-LOCK).