accessing an open database

[Ruslan Zasukhin]

On 3/22/05 1:36 AM, "jda" <jda at his.com> wrote:

>> Please explain again.
>> 
>> You have in the app SINGLE db object, yes?
> 
> yes. a database.
> 
>> 
>> And each thread share this object ?
> 
> they can (I'd like that).
> 
> But for now I'd be happy if each thread would just wait until the
> thread before it was finished. And then open the database.

John, then I simply not understand.

    db = new mydb

thread1
    db.open

-------------
Threadi

    mutex.access
    if( db.IsOpen = false )
        db.Open()
    
    ...

I think this way should work with no problems...


And why you CLOSE db ?
Or you in fact have many dbs ?
I am lost 

>> Or each thread create own db object ?
>> 
> 
> No, each thread opens an existing db (a file).
> 
> And yes, I get a -61 error on this line
> 
> 
> myCursor = myDatabase.SQLSelect("select *,** from thereferences
>   where " + searchString, EVCursorLocation.kServerSide,
> EVLockType.kNolocks)
> 
> This is after I've opened a database in use by looping, and waiting
> for the -61 error to go away on this line
> 
> myDatabase.open(f) -- f is the database folderitem.

-- 
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
-------------------------------------------------------------