DBGrid und Values from linked Tables

Thomas_Rich...@t-online.de

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

DBGrid und Values from linked Tables

I am looking for a Dbgrid that may show, change, delete ...
Values from other Tables

-a) 1:1 linked or
-b) 1:n linked in a DBCombobox in Grid Cells

i am using Delphi 4 C/S
Thanks for any help

Ciao
Thomas

--------------------------------
Thomas Richter
Home: Thomas_Rich...@t-online.de
Job: i...@lfa.mk.lsa-net.de
--------------------------------

Steve Koters

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

Re:DBGrid und Values from linked Tables

Quote

On Sat, 08 Jan 2000 10:16:56 GMT, Thomas_Rich...@t-online.de wrote:
>I am looking for a Dbgrid that may show, change, delete ...
>Values from other Tables

>-a) 1:1 linked or

In the online help, see cached updates. From the table of contents,
navigate through the topic titles:

Developing Database Applications
Working witgh cached updates

Quote

>-b) 1:n linked in a DBCombobox in Grid Cells

In the online help, see look-up fields (a variety of persistent fields). In
the index for the online help, go to:

lookup fields, caching values
defining

_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
Steve Koterski "Health nuts are going to feel stupid someday,
Felton, CA lying in hospitals dying of nothing."
-- Redd Foxx

Juha Mannine

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

Re:DBGrid und Values from linked Tables

Quote

Steve Koterski wrote:
> In the online help, see cached updates. From the table of contents,
> navigate through the topic titles:

> Developing Database Applications
> Working witgh cached updates

Hei!
The Cached Updates work only in TQuery, not in TADOQuery. I am using the latter
because I was not able to connect to Access Database with TQuery.
I am also looking for a modified BDGrid, which would allow the user to accept
or cancel all changes (eg. Buttons OK & Cancel).
Now I have built one version using StringGrid, but that lacks much of the
functionality of DBGrid.
Has anybody seen or heard about or made such a Grid?

Juha Manninen

Steve Koters

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

Re:DBGrid und Values from linked Tables

On Wed, 12 Jan 2000 14:24:25 +0200, Juha Manninen

Quote

<juha.manni...@datex-ohmeda.com> wrote:

[...]

Quote

>The Cached Updates work only in TQuery, not in TADOQuery. I am using the latter
>because I was not able to connect to Access Database with TQuery.
>I am also looking for a modified BDGrid, which would allow the user to accept
>or cancel all changes (eg. Buttons OK & Cancel).
>Now I have built one version using StringGrid, but that lacks much of the
>functionality of DBGrid.
>Has anybody seen or heard about or made such a Grid?

The cached updates you know is BDE-based and, as ADOExpress does not
utilize the BDE in any way, cannot be used with ADO database operations.
ADO has its own, built-in form of data change caching. The UpdateBatch and
CancelUpdates methods (originating in TCustomADODataSet) are direct
implementations of the ADO methods.

The architect of the ADOExpress components has expressed interest in adding
a cached updates scheme compatible with ADO in a future version of Delphi.
We shall see...

_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
Steve Koterski "Health nuts are going to feel stupid someday,
Felton, CA lying in hospitals dying of nothing."
-- Redd Foxx

Other Threads

1. Literatur und Links gesucht

2. DBGrid and Tables default value

3. dbGrid ::: How to change row color according to some data value in table

4. D4- Linked Master/Detail not updating linked DbGrid

5. Deleting from table based on info in linked table

6. How to link one table to two tables - new to Delphi

7. Linked Tables, Error: Table is read only

8. How to Update a column in a Table w/ values from another table

9. Link query does not display the FKEY value ???

10. DBGrid detail table Calc Field Totals in a master table