Prevent griddata flash on change recordsource 1

[DirkVFP]

Hello all,

How can I prevent the flashing of my griddata when I change its recordsource? The recordsource is a cursor which is filled from a select statement (RecoursourceType = Alias).

In my program the user is working with orders per day, so whenever a user selects a different day than the current one, I need to refill the cursor so it will contain the correct information.

First I let the grid recordsource use a dummy grid (so the layout will be safe), second I'm filling the cursor with the appropriate information and last I'm reassinging the cursor to the grid's recordsource. This results in a flash which I really want to prevent.

 

[bborissov]

3 ways:
1.

thosform.LockScreen = .t.
*** reassign Grid RecordSource
*** Grid Refresh
thosform.LockScreen = .f.

2. Do not change recordSource, there where yuo need to change data:

thisform.LockScreen = .t.
SELECT ... INTO CURSOR crsTest && Get right data to different cursor

SELECT GridRecordSource
ZAP
APPEND FROM (DBF("crsTest"))
USE IN crsTest
thisform.LockScreen = .f.

3. Use Parametrised View or CursorAdapter as a RecordSource of the Grid. Then just Requery or CursorRefresh()


Borislav Borissov

 

[DirkVFP]

Thanks Borislav, I will try out the ways you provided.

Since I'm using a treeview on my form which' content is also changed per day (and it flashes too) I tried the LockScreen property and that didn't stop the flashing.

So I'm now trying the two other ways.

 

[bborissov]

No ActiveX controls didn't affect thisform.LockScreen.
Try:

DECLARE INTEGER LockWindowUpdate IN Win32API INTEGER nHandle 
LockWindowUpdate(_VFP.hWnd)
*** Do something here
LockWindowUpdate(0)
CLEAR DLLS LockWindowUpdate

Borislav Borissov

 

[DirkVFP]

Thanks, that works perfect!
Do you perhaps have a link to a website with more handy Windows functions like these which I'm unaware (or SHOULD be aware) of?

(Sometimes I wish I had a co-worker just like you around Borislav, but alas that is not the situation ;-) )

 

[bborissov]

http://www.news2news.com/vfp/index.php

payed site but the price is reasonable and worth it

Also this site offer API Viewr for VFP. You could find it at:

http://www.news2news.com/vfp/?article=12&src=frontpage

Borislav Borissov

 

[DirkVFP]

Excellent site which I directly added on top of my favorites.
Thanks again for your help.

I will report on what solution proved best to me regarding the flashing problem of the grid.