Matthew,

<< What is the best way for me to send you the source? The app uses
RemObjects, and has the DevExpress grid version 4 (though that isn't
actually vital TBH - I could easily delete it if it helps). Also Raize
omponents v3 is used a lot. Oh yes, and it uses SVCom to make it into a
service. Thoughts? >>

Just send me the whole thing - I'll rip out what I don't need and pare it
down to the essentials.

--
Tim Young
Elevate Software
www.elevatesoft.com

Matthew,

<< I can get a situation where multiple threads are stuck trying to lock the
table. Is this relevant?  >>

Perhaps.  Are you talking about a record lock contention or a read/write
lock error ?

<< Let's go over my understanding of multi-threaded DBISAM. My understanding
is that all I have to do is make sure that each thread has a separate
session ID. To do that, the AutoSessionName can be set to true on forms and
data modules, and that "just takes care of it". For manually created
sessions, etc, I have to "wire" up the session name myself, but all that is
needed is to create the session, get it to auto-name, then use that name in
the queries that I create in that thread. (As per my code already posted).
I've just checked this with the manual, and all is well there - nothing I'm
not expecting.  >>

This is all 100% correct.  However, you might have to make sure that the
creation order is good.  IOW, you always want to make sure that the session
component is created first.

<< I'll add a log item to output the session name for each thread, but
beyond that I'm open to any suggestions. Oh, and I have the madExcept dump
from the lock if that is of interest. The key parts are that there is one
delete, two inserts and a read all happening at the same time. >>

Sure, anything and everything will help.

<< Before posting this, I thought I'd be sure of my sessions names. This is
odd. The main form has a session ID of "sessionServer_1". The state  machine
which does the work has a session ID of "sessionServer_2". All of the
RemObjects data modules get a session ID of "sessionServer_3" or
"sessionServer_4". Never a 5 or anything more. Okay, on printing the thread
ID as well, they are always matching. I'm surprised at this given I have 50
threads in the client, but it isn't relevant to the matter in hand here -
all the sessions are independent, but I can lock them and I can get error
8965. >>

You should get session IDs higher than 5 if you have more than 5 threads
with unique sessions in each.

--
Tim Young
Elevate Software
www.elevatesoft.com

Thanks for the response. I'll put something together for you, and email
you at the timyoung address with the download details. It goes without
saying of course that this is confidential etc, but I expect you are used
to such.

/Matthew Jones/

YHM with the link.

/Matthew Jones/

Or you would, but I get:

.... while talking to mail.elevatesoft.com.:
>>> DATA
<<< 554 Transaction failed - invalid message headers
554 5.0.0 timyoung@elevatesoft.com... Service unavailable

I'll try another path to you. Perhaps a GMail account...

/Matthew Jones/

In case it matters, we aren't getting any SMTP inbound email at the moment
for some reason. I suspect our spam filtering company is having trouble!

In any case, you should have me as "technical" at the domain I sent the
email from if that matters too!

/Matthew Jones/

Matthew,

<< In case it matters, we aren't getting any SMTP inbound email at the
moment for some reason. I suspect our spam filtering company is having
trouble!

In any case, you should have me as "technical" at the domain I sent the
email from if that matters too! >>

No problem.  I got the project and will be looking at it this evening.

--
Tim Young
Elevate Software
www.elevatesoft.com

FWIW, Tim cut my project down, and has now identified the problem. Fix
in DBISAM coming soon.

I have to say this is a fantastic level of support, very fast, and I'll
have Tim's babies any day. 8-)

/Matthew Jones/

Matthew,

<< I have to say this is a fantastic level of support, very fast, and I'll
have Tim's babies any day. 8-) >>

And I'd just like to stress that everything above is completely true except
for the last part.

--
Tim Young
Elevate Software
www.elevatesoft.com

LOL! Yes, I suppose it could be read in more than one way can't it.

That said, my wife says my tummy looks like I'm pregnant... 8-)

/Matthew Jones/

(and she's organising a bit of exercise for me this year too!