BorlandTalk.com

Penny · Guest

Hi,

We had our applications made in Delphi 7 and we were used to use MSAccess as
Database. Now where the database has increased enough, we decided to move to
SQL Server.

The problem is that Access allows us to update fields in a join query and
now with SQL Server we have a terrible problem.

When you need to update some columns of a table, through a grid, and it is
absolutely needed to lookup (or join) some information from other tables,
which is the best way?

What I'm thinking is using lookup fields which is terrible slow, or creating
help tables which make me feel insecure.

Thanks in advance!

Kevin Frevert · Guest

Penny,

This may be worth a look..

http://community.borland.com/article/0,1410,22571,00.htm

Good luck,
krf

"Penny" <pennyargyrou (AT) hotmail (DOT) com> wrote

Del Murray · Guest

Penny,
Look into the "distinct" table method. That causes the updates to only be
applied to one table (of your choosing) from the dataset. Also, have a go at
tBetterAdoDataset http://betterado.hit.bg/.

Arthur Hoornweg · Guest

Tell the ADO dataset which table to update prior
to opening the joined query. Place it in an event
handler, e.g. in the "BeforeOpen" handler:

MyAdoDataset.Recordset.Properties['Unique Table']:='Tablename';

Subsequently, the dataset will assume you want to modify
only table "tablename" even if the join contains multiple
tables.

--
Arthur Hoornweg
(please remove the ".net" from my e-mail address)