Update

[Ruslan Zasukhin]

on 9/3/03 9:07 PM, Eric Frericks at efrericks at imaginatics.com wrote:

> Steps to duplicate the 362 Error:
> 
> 1. Run project from Debug menu
> 2. Select "Reports" from the MenuBar then the "Activities" sub menu
> 3. Next you will be presented with a query window, just click OK
> 4. An error is produced when I try and get the RecordCount of pCursor, as an
> error of 362 has been produced.
> 
> This happens consistently, so its probably ignorance on my part. The other
> problem with all records being deleted does not seem to happen consistently,
> but I will try and reproduce it. Thanks

Hi Eric,

Look. You have 4 place where you call SqlSelect()
Set breakpoints on each.

Now when I run app I see calls in the next order

1) 
    pCursor = app.pObjDataBase.SQLselect(strSQL, kV_Server, kV_ReadWrite,
kV_Random)


2)
me.pCursor = app.pObjDataBase.SQLselect(strSQL )


As you see your first SELECT have assign READWRITE lock.
But second try set READ LOCK. And of course it fails.

You need our use in each 4 place NoLock parameter,
Or spend more attention to
    who lock
    what lock
    how lock
    how long locks.


I think yin your case just use NoLocks

-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------