Board index » delphi » Grid with subset (grid) feature

Mike Shkolnik

Delphi Developer
Sun, 28 Aug 2005 18:00:29 GMT

Grid with subset (grid) feature

Standard TDBGrid support the nested grids. This is not look same as in MS
Access (like tree) but when you'll click in cell, a new dropdowned grid is
displayed with detail records.

Why not use this standard behaviour? - check a demo in DEMOS folder...

--
With best regards, Mike Shkolnik
EMail: mshkol...@scalabium.com
http://www.scalabium.com

"Roland" <rolandelNONS...@usa.net> ???Y/???Y ????? ???Y??:
news:3e6ec3b3$1@newsgroups.borland.com...

Quote
> Hi:

> Is there any component available to display both master table and detail
> table as subset in Grid component like Access 2000 grid?

> Thanks

> Roland Zhang

 
Mike Shkolni

Delphi Developer
Mon, 29 Aug 2005 01:13:35 GMT

Re:Grid with subset (grid) feature


Delphi\Demos\ADO\Shape

Just scroll a grid with customers to end and you'll see an Orders column.
Click on cell and you'll receive a grid with orders for this customer.

Same behaviour allow any grid that is inherited from TDBGrid. For example,
my freeware TSMDBGrid: http://www.scalabium.com/smdbgrid.htm

--
With best regards, Mike Shkolnik
EMail: mshkol...@scalabium.com
http://www.scalabium.com

"Andy Vines" <andyvi...@amcukfasteners.co.uk> ???Y/???Y ?????
???Y??: news:3e6f655c@newsgroups.borland.com...

Quote
> Looked for this Demo but couldn't find it, can you tell me the name of the
> Demo?

> Andy

> "Mike Shkolnik" <mshkolnik2...@ukr.net> wrote in message
> news:3e6f058b@newsgroups.borland.com...
> > Standard TDBGrid support the nested grids. This is not look same as in
MS
> > Access (like tree) but when you'll click in cell, a new dropdowned grid
is
> > displayed with detail records.

> > Why not use this standard behaviour? - check a demo in DEMOS folder...

> > --
> > With best regards, Mike Shkolnik
> > EMail: mshkol...@scalabium.com
> > http://www.scalabium.com

> > "Roland" <rolandelNONS...@usa.net> ???Y/???Y ?????
???Y??:
> > news:3e6ec3b3$1@newsgroups.borland.com...
> > > Hi:

> > > Is there any component available to display both master table and
detail
> > > table as subset in Grid component like Access 2000 grid?

> > > Thanks

> > > Roland Zhang

Andy Vine

Delphi Developer
Mon, 29 Aug 2005 00:50:59 GMT

Re:Grid with subset (grid) feature


Looked for this Demo but couldn't find it, can you tell me the name of the
Demo?

Andy

Quote
"Mike Shkolnik" <mshkolnik2...@ukr.net> wrote in message

news:3e6f058b@newsgroups.borland.com...
Quote
> Standard TDBGrid support the nested grids. This is not look same as in MS
> Access (like tree) but when you'll click in cell, a new dropdowned grid is
> displayed with detail records.

> Why not use this standard behaviour? - check a demo in DEMOS folder...

> --
> With best regards, Mike Shkolnik
> EMail: mshkol...@scalabium.com
> http://www.scalabium.com

> "Roland" <rolandelNONS...@usa.net> ???Y/???Y ????? ???Y??:
> news:3e6ec3b3$1@newsgroups.borland.com...
> > Hi:

> > Is there any component available to display both master table and detail
> > table as subset in Grid component like Access 2000 grid?

> > Thanks

> > Roland Zhang

Jose A.Molin

Delphi Developer
Sun, 28 Aug 2005 19:07:08 GMT

Re:Grid with subset (grid) feature


Hi Roland,

When using JfControls, a dbgrid can be placed on a popup window linked to a
column of the main grid without problems whatsoever, althoug our components
also allow a whole world of things more.
You could want to download our JfControls Grid demo program from
http://www.jfactivesoft.com/endowndemos.htm, just to take a look and check
it out.

Anyway, if you need further details or have any kind of doubt, don't
hesitate to contact us by email at any moment.

Best wishes,

Jose Antonio Molina
JfActiveSoft

http://www.jfactivesoft.com
i...@jfactivesoft.com
supp...@jfactivesoft.com
sa...@jfactivesoft.com

"Roland" <rolandelNONS...@usa.net> escribi en el mensaje
news:3e6ec3b3$1@newsgroups.borland.com...

Quote
> Hi:

> Is there any component available to display both master table and detail
> table as subset in Grid component like Access 2000 grid?

> Thanks

> Roland Zhang

Rolan

Delphi Developer
Sun, 28 Aug 2005 13:19:39 GMT

Re:Grid with subset (grid) feature


Hi:

Is there any component available to display both master table and detail
table as subset in Grid component like Access 2000 grid?

Thanks

Roland Zhang

Jean-Pierre Lienar

Delphi Developer
Sun, 28 Aug 2005 16:26:38 GMT

Re:Grid with subset (grid) feature


INFOPOWER is WYNIWYG  (What You Need Is What You Get...)

go and see www.woll2woll.com

JP Lienard
DataRag scrl

"Roland" <rolandelNONS...@usa.net> a crit dans le message de news:
3e6ec3b...@newsgroups.borland.com...

Quote
> Hi:

> Is there any component available to display both master table and detail
> table as subset in Grid component like Access 2000 grid?

> Thanks

> Roland Zhang

Rolan

Delphi Developer
Mon, 29 Aug 2005 07:19:44 GMT

Re:Grid with subset (grid) feature


Thank Mike:

That's only worked for ADO, I guess.

Roland Zhang

Quote
Mike Shkolnik <mshkolnik2...@ukr.net> wrote in message

news:3e6f058b@newsgroups.borland.com...
Quote
> Standard TDBGrid support the nested grids. This is not look same as in MS
> Access (like tree) but when you'll click in cell, a new dropdowned grid is
> displayed with detail records.

> Why not use this standard behaviour? - check a demo in DEMOS folder...

> --
> With best regards, Mike Shkolnik
> EMail: mshkol...@scalabium.com
> http://www.scalabium.com

> "Roland" <rolandelNONS...@usa.net> ???Y/???Y ????? ???Y??:
> news:3e6ec3b3$1@newsgroups.borland.com...
> > Hi:

> > Is there any component available to display both master table and detail
> > table as subset in Grid component like Access 2000 grid?

> > Thanks

> > Roland Zhang

Rolan

Delphi Developer
Mon, 29 Aug 2005 06:52:28 GMT

Re:Grid with subset (grid) feature


Thank you for all your responses. I will check these components.

Roland Zhang

Quote
Jose A.Molina <i...@jfactivesoft.com> wrote in message

news:3e6f14d1$1@newsgroups.borland.com...
Quote
> Hi Roland,

> When using JfControls, a dbgrid can be placed on a popup window linked to
a
> column of the main grid without problems whatsoever, althoug our
components
> also allow a whole world of things more.
> You could want to download our JfControls Grid demo program from
> http://www.jfactivesoft.com/endowndemos.htm, just to take a look and check
> it out.

> Anyway, if you need further details or have any kind of doubt, don't
> hesitate to contact us by email at any moment.

> Best wishes,

> Jose Antonio Molina
> JfActiveSoft

> http://www.jfactivesoft.com
> i...@jfactivesoft.com
> supp...@jfactivesoft.com
> sa...@jfactivesoft.com

> "Roland" <rolandelNONS...@usa.net> escribi en el mensaje
> news:3e6ec3b3$1@newsgroups.borland.com...
> > Hi:

> > Is there any component available to display both master table and detail
> > table as subset in Grid component like Access 2000 grid?

> > Thanks

> > Roland Zhang

Mike Shkolni

Delphi Developer
Mon, 29 Aug 2005 14:09:01 GMT

Re:Grid with subset (grid) feature


I think that this feature must work with any Master-Detail relation for any
engine, not only ADO...

--
With best regards, Mike Shkolnik
E-mail: mshkol...@scalabium.com
WEB: http://www.scalabium.com

Quote
"Roland" <rolandelNONS...@usa.net> wrote in message

news:3e6fc0a3@newsgroups.borland.com...
Quote
> Thank Mike:

> That's only worked for ADO, I guess.

> Roland Zhang

> Mike Shkolnik <mshkolnik2...@ukr.net> wrote in message
> news:3e6f058b@newsgroups.borland.com...
> > Standard TDBGrid support the nested grids. This is not look same as in
MS
> > Access (like tree) but when you'll click in cell, a new dropdowned grid
is
> > displayed with detail records.

> > Why not use this standard behaviour? - check a demo in DEMOS folder...

> > --
> > With best regards, Mike Shkolnik
> > EMail: mshkol...@scalabium.com
> > http://www.scalabium.com

> > "Roland" <rolandelNONS...@usa.net> ???Y/???Y ?????
???Y??:
> > news:3e6ec3b3$1@newsgroups.borland.com...
> > > Hi:

> > > Is there any component available to display both master table and
detail
> > > table as subset in Grid component like Access 2000 grid?

> > > Thanks

> > > Roland Zhang

Other Threads

1. 2 or 3 Tier deep grid (grid inside another grid)

2. 2 or 3 Tier deep grid (grid inside another grid)

3. Grids Grids Grids

4. Grid similar to Netscape Grid

5. ADO+GRID or DBE+GRID memory usage

6. I need a grid control like the grid in ms word

7. string grid - grid line colors

8. Coloring Grid or Grid Fonts

9. How to drag record from grid to grid

10. [GRID.PAS] Bug inside VCL Grids