Hi

Can someone please help me understand what situations would cause the following code to
raise an 8708 error at post when the LockProtocol is lpOptimistic.

It works fine if LockProtocol is lpPessimistic.  

Other info:
- Database is local, only running in one app
- StrictChangeDetection is False
- DBISAM 3.30, Delphi 2007
- Happens on first post.  Table has not been modified elsewhere in the app


     MyDB.StartTransaction;
     tblLinks.first;
     while not tblLinks.eof do
     begin
       Output.add(tblLinksID.AsString);
       try
         tblLinks.Edit;
         tblLinksGroupID.AsInteger := iGroup;
         tblLinks.Post; // <-- 8708 Error when LockProtocol is lpOptimistic
       except
         raise;
       end;

       inc(iProcessed);
       if (iProcessed mod COMMIT_FREQUENCY=0) then
         MyDB.FlushTransaction;
     end;

     etc.

"Davey Crackpot" <davey.crackpot@gmail.com> wrote in message
news:513292DA-729A-459E-B656-64291610DCEC@news.elevatesoft.com...
> Hi
>
> Can someone please help me understand what situations would cause the
> following code to
> raise an 8708 error at post when the LockProtocol is lpOptimistic.
>
> It works fine if LockProtocol is lpPessimistic.
>
> Other info:
> - Database is local, only running in one app
> - StrictChangeDetection is False
> - DBISAM 3.30, Delphi 2007
> - Happens on first post.  Table has not been modified elsewhere in the app
>

Where's the Table.Next?

Robert

"Robert" wrote:
> Where's the Table.Next?

Oh, I neglected to mention that.  tblLinks is filtered to show only those items of
GroupID=xyz (and thus disappears from the results when we set GroupID to its new value).

Could that be the issue?  Are we somehow affecting the filtered results (and so moving the
cursor) before even calling post?

Davey,

<< Oh, I neglected to mention that.  tblLinks is filtered to show only those
items of GroupID=xyz (and thus disappears from the results when we set
GroupID to its new value).

Could that be the issue?  Are we somehow affecting the filtered results
(and so moving the cursor) before even calling post? >>

Does the error occur on the first loop, the second, etc. ?

--
Tim Young
Elevate Software
www.elevatesoft.com

> Does the error occur on the first loop, the second, etc. ?

On the very first loop.

Davey,

<< On the very first loop. >>

Hmmm, can you send me a project that reproduces this ?  I'm not sure what is
going on since the StartTransaction should perform the change detection,
thus making it impossible for any later Edits or Posts to encounter changes
by other sessions.

--
Tim Young
Elevate Software
www.elevatesoft.com