Grid with footer, column incremental search  
Author Message
Descarte





PostPosted: Wed Apr 26 10:40:08 CDT 2006 Top

Exchange Servers >> Grid with footer, column incremental search

This is a multi-part message in MIME format.

------=_NextPart_000_0024_01C66917.0EB253D0
Content-Type: text/plain;
charset="windows-874"
Content-Transfer-Encoding: quoted-printable

Hi,

Is there any Grid complete with following :-

- footer
- incremental search on few key coloumns
- freeze coloumn (this one available in VFP9 )
- color each row

Regards
Hoe
------=_NextPart_000_0024_01C66917.0EB253D0
Content-Type: text/html;
charset="windows-874"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Dwindows-874">
<META content=3D"MSHTML 6.00.2900.2873" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>Hi,</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>Is there any Grid complete with =
following=20
:-</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>- footer</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>- incremental search on few key=20
coloumns</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>- freeze coloumn (this one available in =
VFP9=20
)</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>- color each row</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>Regards</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>Hoe</FONT></DIV></BODY></HTML>

------=_NextPart_000_0024_01C66917.0EB253D0--

Exchange Server4  
 
 
Dan





PostPosted: Wed Apr 26 10:40:08 CDT 2006 Top

Exchange Servers >> Grid with footer, column incremental search You're not being very specific. What do you mean by footer? How do you want
to color each row?

Anything is do-able with the VFP grid, and much has already been done. If
you can be more specific someone will surely come up with some suggestions.

Dan


> Hi,
>
> Is there any Grid complete with following :-
>
> - footer
> - incremental search on few key coloumns
> - freeze coloumn (this one available in VFP9 )
> - color each row
>
> Regards
> Hoe


 
 
AA





PostPosted: Wed Apr 26 06:10:45 CDT 2006 Top

Exchange Servers >> Grid with footer, column incremental search This is a multi-part message in MIME format.

------=_NextPart_000_007E_01C66932.D4529120
Content-Type: text/plain;
charset="windows-874"
Content-Transfer-Encoding: quoted-printable

1. Incremental search. Lokk for INGRID.PRG
2. Yes
3. Column.Backcolor, Column.Forecolor, Colmn.DynamicBackcolor, =
Column.DynamicForecolor
Anders



Hi,

Is there any Grid complete with following :-

- footer
- incremental search on few key coloumns
- freeze coloumn (this one available in VFP9 )
- color each row

Regards
Hoe
------=_NextPart_000_007E_01C66932.D4529120
Content-Type: text/html;
charset="windows-874"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Dwindows-874">
<META content=3D"MSHTML 6.00.2900.2873" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>1. Incremental search. Lokk for=20
INGRID.PRG</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>2. Yes</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>3. Column.Backcolor, Column.Forecolor,=20
Colmn.DynamicBackcolor, Column.DynamicForecolor</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>Anders</FONT></DIV>
<DIV>&nbsp;</DIV>
<BLOCKQUOTE dir=3Dltr=20
style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; =
BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV>"tnhoe" &lt;<A=20

meddelandet <A=20
=

>...</DIV>
<DIV><FONT face=3DArial size=3D2>Hi,</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>Is there any Grid complete with =
following=20
:-</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>- footer</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>- incremental search on few key=20
coloumns</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>- freeze coloumn (this one available =
in VFP9=20
)</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>- color each row</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>Regards</FONT></DIV>
<DIV><FONT face=3DArial =
size=3D2>Hoe</FONT></DIV></BLOCKQUOTE></BODY></HTML>

------=_NextPart_000_007E_01C66932.D4529120--

 
 
Jeff





PostPosted: Wed Apr 26 14:24:39 CDT 2006 Top

Exchange Servers >> Grid with footer, column incremental search I would assume that what he means by "footer" is a row at the bottom of the
grid which contains information and does not move just like the header is at
the top of the grid. I'm guessing but he can correct me if I'm wrong.

I could see a use for this with something like an AR aging where you might
place the totals in the "footer", column headings in the header, and
scrollable details in between. This way the totals would always appear on
the screen while the grid is scrolled through.

I've accomplished this with textboxes at the bottom of the grid but I can
see the value in having it build in.

Jeff


> You're not being very specific. What do you mean by footer? How do you
> want
> to color each row?
>
> Anything is do-able with the VFP grid, and much has already been done. If
> you can be more specific someone will surely come up with some
> suggestions.
>
> Dan
>

>> Hi,
>>
>> Is there any Grid complete with following :-
>>
>> - footer
>> - incremental search on few key coloumns
>> - freeze coloumn (this one available in VFP9 )
>> - color each row
>>
>> Regards
>> Hoe
>
>


 
 
tnhoe





PostPosted: Wed Apr 26 14:55:04 CDT 2006 Top

Exchange Servers >> Grid with footer, column incremental search Thanks all for reply.

Example a grid with field columns : stock code, description, quantity,
price, amount

=> can it have a 'footer' for certain column at 'bottom of grid', like the
'header' of grid column which follows grid cell cursor scroll left/right, to
show some memory variables (eg: total of quantity, total of amount ) ?



 
 
AA





PostPosted: Wed Apr 26 16:04:21 CDT 2006 Top

Exchange Servers >> Grid with footer, column incremental search you can put some textboxes in a Container and move them left or right with
the Scrolled event of the Grid.
Move the leftmost box first and the the other relatively:
newleft= -300
WITH Thisform.Container1
.Controls(1).Left= M.newleft
FOR i = 2 to .ControlCount
.Controls(i).Left=.Controls(i-1).Left+.Controls(i-1).Width+1
NEXT
ENDWITH

-Anders



> Thanks all for reply.
>
> Example a grid with field columns : stock code, description, quantity,
> price, amount
>
> => can it have a 'footer' for certain column at 'bottom of grid', like the
> 'header' of grid column which follows grid cell cursor scroll left/right,
> to show some memory variables (eg: total of quantity, total of amount ) ?
>
>
>


 
 
Nikki





PostPosted: Wed Apr 26 18:21:23 CDT 2006 Top

Exchange Servers >> Grid with footer, column incremental search This is a multi-part message in MIME format.

------=_NextPart_000_0031_01C669DB.F3EAE650
Content-Type: text/plain;
charset="windows-874"
Content-Transfer-Encoding: quoted-printable

What is INGRID.PRG?
Where can we find this?


1. Incremental search. Lokk for INGRID.PRG
2. Yes
3. Column.Backcolor, Column.Forecolor, Colmn.DynamicBackcolor, =
Column.DynamicForecolor
Anders



Hi,

Is there any Grid complete with following :-

- footer
- incremental search on few key coloumns
- freeze coloumn (this one available in VFP9 )
- color each row

Regards
Hoe
------=_NextPart_000_0031_01C669DB.F3EAE650
Content-Type: text/html;
charset="windows-874"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Dwindows-874">
<META content=3D"MSHTML 6.00.2900.2873" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>What is INGRID.PRG?</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>Where can we find this?</FONT></DIV>
<BLOCKQUOTE dir=3Dltr=20
style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; =
BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">

=

@TK2MSFTNGP03.phx.gbl</A>...</DIV>
<DIV><FONT face=3DArial size=3D2>1. Incremental search. Lokk for=20
INGRID.PRG</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>2. Yes</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>3. Column.Backcolor, =
Column.Forecolor,=20
Colmn.DynamicBackcolor, Column.DynamicForecolor</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>Anders</FONT></DIV>
<DIV>&nbsp;</DIV>
<BLOCKQUOTE dir=3Dltr=20
style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; =
BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV>"tnhoe" &lt;<A=20

i=20
meddelandet <A=20
=

>...</DIV>
<DIV><FONT face=3DArial size=3D2>Hi,</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>Is there any Grid complete with =
following=20
:-</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>- footer</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>- incremental search on few key=20
coloumns</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>- freeze coloumn (this one =
available in VFP9=20
)</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>- color each row</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>Regards</FONT></DIV>
<DIV><FONT face=3DArial=20
size=3D2>Hoe</FONT></DIV></BLOCKQUOTE></BLOCKQUOTE></BODY></HTML>

------=_NextPart_000_0031_01C669DB.F3EAE650--

 
 
Nikki





PostPosted: Wed Apr 26 18:49:30 CDT 2006 Top

Exchange Servers >> Grid with footer, column incremental search All of them can be done in VFP:

1).footer
- Add two additional rows to your table (so that they'll be at the bottom).
This can be easily be done.

- If you want to have custom header captions for the footer then do as
follows:
- The second last row in the grid will have labels instead of textboxes. Use
the DynamicCurrentControl property in the columns to achieve this. And set
the captions as you need

- The last record will have the data you need to be displayed in the grid
(which will be the footer).

2).incremental search on few key coloumns
- Perfect and Generic solution for this can be found in FoxProAdvisor.com
(for VFP 8 and 9)

Details:

Print issue May 2004
On page 20 of the magazine.
Doc #13886

Simplify Grids
Use this BINDEVENT() alternative to column/header subclassing.
By Drew Speedie, Contributing Editor, FoxPro Advisor


3).freeze coloumn (this one available in VFP9 )
- You've got your own answer yourself

4).color each row
- Use DynamicForeColor & DynamicBackColor properties of the Grid




Hi,

Is there any Grid complete with following :-

- footer
- incremental search on few key coloumns
- freeze coloumn (this one available in VFP9 )
- color each row

Regards
Hoe


 
 
AA





PostPosted: Thu Apr 27 08:19:22 CDT 2006 Top

Exchange Servers >> Grid with footer, column incremental search This is a multi-part message in MIME format.

------=_NextPart_000_00BD_01C66A0D.F6916280
Content-Type: text/plain;
charset="windows-874"
Content-Transfer-Encoding: quoted-printable

It used to be popular. It might not ber available any more.
Incremental search is quite easy if the colummn is indexed. The user =
ypes into a textbox. for each letter you call SEEK() in the Keypress =
event and SetFocus back and forth between the Grid and the texbox as =
long as SEEK() returns .T.
-Anders



What is INGRID.PRG?
Where can we find this?


1. Incremental search. Lokk for INGRID.PRG
2. Yes
3. Column.Backcolor, Column.Forecolor, Colmn.DynamicBackcolor, =
Column.DynamicForecolor
Anders



Hi,

Is there any Grid complete with following :-

- footer
- incremental search on few key coloumns
- freeze coloumn (this one available in VFP9 )
- color each row

Regards
Hoe
------=_NextPart_000_00BD_01C66A0D.F6916280
Content-Type: text/html;
charset="windows-874"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Dwindows-874">
<META content=3D"MSHTML 6.00.2900.2873" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>It used to be popular. It might not ber =
available=20
any more.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>Incremental search is quite easy if the =
colummn is=20
indexed. The user ypes into a textbox. for each letter you&nbsp;call =
SEEK() in=20
the Keypress event and SetFocus back and forth between the Grid and the =
texbox=20
as long as SEEK() returns .T.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>-Anders</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<BLOCKQUOTE dir=3Dltr=20
style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; =
BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV>"Nikki" &lt;<A =

i meddelandet <A=20
=

@TK2MSFTNGP04.phx.gbl</A>...</DIV>
<DIV><FONT face=3DArial size=3D2>What is INGRID.PRG?</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>Where can we find this?</FONT></DIV>
<BLOCKQUOTE dir=3Dltr=20
style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; =
BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">


=

@TK2MSFTNGP03.phx.gbl</A>...</DIV>
<DIV><FONT face=3DArial size=3D2>1. Incremental search. Lokk for=20
INGRID.PRG</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>2. Yes</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>3. Column.Backcolor, =
Column.Forecolor,=20
Colmn.DynamicBackcolor, Column.DynamicForecolor</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>Anders</FONT></DIV>
<DIV>&nbsp;</DIV>
<BLOCKQUOTE dir=3Dltr=20
style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; =
BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV>"tnhoe" &lt;<A=20

skrev i=20
meddelandet <A=20
=

>...</DIV>
<DIV><FONT face=3DArial size=3D2>Hi,</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>Is there any Grid complete with =
following=20
:-</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>- footer</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>- incremental search on few key=20
coloumns</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>- freeze coloumn (this one =
available in VFP9=20
)</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>- color each row</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>Regards</FONT></DIV>
<DIV><FONT face=3DArial=20
size=3D2>Hoe</FONT></DIV></BLOCKQUOTE></BLOCKQUOTE></BLOCKQUOTE></BODY></=
HTML>

------=_NextPart_000_00BD_01C66A0D.F6916280--