Hi.

I'm having a problem that I'll try to explain in my "spanglish".

In my proyect I have a procedure to assign the number of documents bearing in mind when
working several users don't must repeat the number. Something like that:

while not True do begin
 try
   TableCounter.edit;
   Number:=TableCounter.FieldByname('NUMBER').AsInteger+1;
  
TableCounter.FieldByname('NUMBER').AsInteger:=TableCounter.FieldByname('NUMBER').AsInteger+1;
   TableCounter.Post;
   break;
 except
 end;
end;

With this procedure I insure myself that two users don't access to the record at the same
time to assign the number of document (I think).

Since about tree months ago in several of my customers, and only a few times, the number
of document doubles in two differents users and I don't know why because the code have no
changes and I don't know if may be for the database version.

It seems that when update record don't update to another users and takes and old value of
the field.

I'm now using EDB 2.02 b15 and when don't have problem I used 2.02 b13.

Any idea?

Thank's

Francisco,

<< It seems that when update record don't update to another users and takes
and old value of the field. >>

Are you using pessimistic row locking (the default) ?

http://www.elevatesoft.com/manual?action=mancompprop&id=edb2&product=d&version=7&comp=TEDBSession&prop=RecordLockProtocol

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim.

<<Are you using pessimistic row locking (the default) ?>>

Yes. Very very pessimistic.

Francisco,

<< Yes. Very very pessimistic. >>

There should be no way that what you describe is occurring.  Are you sure
that you're using the exact code that you posted, and not SQL where you
retrieve the column value, and then update it ?

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim.

I'm sure everything I can be, anyway I will continue checking with my customers.

Thanks.

Francisco,

<< I'm sure everything I can be, anyway I will continue checking with my
customers. >>

What OS are they using ?  Are they using the ElevateDB Server, or
file-sharing ?

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim.

<<What OS are they using ?  Are they using the ElevateDB Server, or
file-sharing ?>>

Windows file-sharing, one with a windows 2003 server, others with xp in all users.

Francisco,

<< Windows file-sharing, one with a windows 2003 server, others with xp in
all users. >>

Have they had issues with users shutting down their machines or applications
improperly ?  That could account for such an issue.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim.

<<Have they had issues with users shutting down their machines or applications
improperly ?  That could account for such an issue.>>

No, all working normally. I'm trying closing table when I read, write and post record.

May be any windows cache or similar?