Roy,

<< I've just been doing a bit of investigation and it seems that the
OnGetCellColor event is fired 3 times for each cell when setting the grid
up. >>

Are you sure that it isn't fired during any repaint ?

<< But that still doesn't answer the question as to why a locate is so much
slower than a prepared parameterised query when they are both executed the
same number of times. >>

I thought that the situation was the opposite ?

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim


><< I've just been doing a bit of investigation and it seems that the
>OnGetCellColor event is fired 3 times for each cell when setting the grid
>up. >>
>
>Are you sure that it isn't fired during any repaint ?

Pretty positive, but with code never absolutely certain. I tried Update and Refresh and the OnGetCellColor event didn't fire.

><< But that still doesn't answer the question as to why a locate is so much
>slower than a prepared parameterised query when they are both executed the
>same number of times. >>
>
>I thought that the situation was the opposite ?

Woops, for slower read faster

Roy Lambert

Roy,

<< Pretty positive, but with code never absolutely certain. I tried Update
and Refresh and the OnGetCellColor event didn't fire. >>

I'll have to double-check, but those may not trigger a repaint unless part
of the control's canvas has been invalidated/changed.

<< Woops, for slower read faster >>

If you want to send me the database and the relevant Locate/query info, I
can tell you for sure what's going on.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim

>If you want to send me the database and the relevant Locate/query info, I
>can tell you for sure what's going on.

Unless you particularly want to delve into it its not worth wasting your time on. I have a solution which works and that's good enough for this bit of the app.

Roy Lambert