Grid / PageFrame 1

[Gert]

Hi all

(1)
I got a pageframe y 5 page, each one of the pages go one defferent grid with a table, but when I run the form only one off the table show up data, the rest of then show only the header of the grid, can I add some properties or code to see the data from all table in each pageframe??.

(2)
Can I hide rows in a grid using some condition like:

DODEFAULT()
WITH This
thisform.Grid1.SetAll("DynamicBackColor", ;
&quot;IIF(amount<=0), RGB(255,255,255) ;
, RGB(0,255,0))&quot;, &quot;Column&quot
ENDWITH

thanks

 

[TomasDill]

Hi!

1) Grid require to have Record Source property set and this record source should be opened BEFORE grid initialization. Otherwise grid will get reconstructed by VFP. When you want open record source in run-time on-demand, put grid on the page in run-time or use empty cursor created at the form load with the name similar to the record source name (do this for each grid record source). After initialization grids will be shown correctly with no records (cursors are empty). When you switch to the page with grid, set grid record source to &quot;&quot; programmatically, close cursor and open/prepare real record source data, than assign record source name again.

Read more about this and otehr useful things at the FAQ article at the

http://www.universalthread.com,

August UT magazine at that site, or just here in the FAQ Grid reconstruction behaviour and how to avoid it.

2. You can highlight the row this way. Well, if color of text match to color of background, you will hide information in row, but not the row. To hide row, set the filter on the record source using SET FILTER or SET KEY commands.


Vlad Grynchyshyn
vgryn@softserve.lviv.ua

http://www.softservecom.com

The professional level of programmer could be determined by level of stupidity of his/her bugs