Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 2 of 2 total
Thread table refresh 2.28b11
Thu, Apr 26 2018 4:12 AMPermanent Link

Roy Lambert

NLH Associates

Team Elevate Team Elevate

I finally tracked down my problem with OpenSSL (I had the wrong dll but the right one was being loaded from elsewhere on my PC - I now have a bit of code to track which dll is actually loaded!) and got my email service running on a server again rather than in-app.

The server ran in its current form for several years so I was surprised when it had problems. I finally traced it down to this

procedure TsrCommonsBase.RefreshTables;
var
Cntr: integer;
begin
for Cntr := 0 to iDatabase.DataSetCount - 1 do begin
 if iDatabase.DataSets[Cntr].Active and (not (iDatabase.DataSets[Cntr].State in dsEditModes)) then begin
  iDatabase.DataSets[Cntr].Refresh;
 end;
end;
RefreshEMDC;
end;

It seems that prior to 2.28 this caused the table cursor to be reset to First, and since 2.28 it isn't. I could be wrong but adding    iDatabase.DataSets[Cntr].First; after the refresh has solved the issue so its my best guess.

Roy Lambert
Fri, Apr 27 2018 10:24 AMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Roy,

<< It seems that prior to 2.28 this caused the table cursor to be reset to First, and since 2.28 it isn't. >>

While you may be right about what is causing your issue, 2.28 didn't change anything with regard to the refreshing of cursors.  The primary additions in 2.28 are the internal locking changes, the buffered file I/O, and the statement/procedure caching.

Tim Young
Elevate Software
www.elevatesoft.com
Image