[VXCMD] Record Locks

[Robert Brenstein]

>On 8/19/04 6:37 AM, "Bobby" <bobby at inentertainment.com> wrote:
>
>>  Ruslan we keep getting with one particular company record locks when we are
>>  not setting any kind of record locks. What else would cause a 363 error to
>>  occur.  We use SQLSelectRecords and SQLSelect with the "NoLocks" option.
>
>Hi Robert,
>
>We have declaration
>
>     DataBase_SQLSelectRecords(
>         dbRefOrName, SQLstring,
>         [FromRec], [MaxRecords],
>         [fldDelim], [recDelim] )
>
>
>Valentina in this function build cursor using default params:
>
>     kClient, kReadOnly, kForwardOnly
>
>
>
>We have 2 choices now:
>
>1) We add to this function 3 additional parameters.
>     IMHO it will be too much parameters then for it.
>

I just fell into the same tryp as you did, Ruslan. I mean my initial 
reply to this post.

I don't think you need to change the SQLSelectRecords at all!

The cursor created by this call is disposed of right away by the same 
call, so I see no reason for us to specify the new parameters. Kernel 
or external should set them as appropriate internally.

Robert Brenstein