Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

ApplyUpdates

5 views
Skip to first unread message

Arvo Vill

unread,
Jun 8, 2004, 9:44:54 AM6/8/04
to
Tere.

Kasutan vormil siis järgnevat kooslust:
TQuery -> TDataSetProvider -> TClientDataset -> TDataSource -> TDBGrid

Query SQL'is küsin andmed mitme tabeli peale kokku (JOIN).

Nüüd kui tahan ClientDataset'ile ApplyUpdate'i teha saan EDBEngineErrori'i
(Unknown column 'väljanimi joinitud tabelist' in 'where clause") - ehk siis
probleem teisest tabelist joinitud väljades.

Kas on võimalik seda viga kuidagi vältida (eeldusel, et komponendid jäävad
samaks)??
Tänan.

Delphi6 / MySQL

Arvo Vill

unread,
Jun 8, 2004, 11:18:05 AM6/8/04
to
Leidsin lahenduse. Kui kellelgi huvi, siis :

A second possibility is a multi-table join where fields from a
single table must be updated. First, set the ProviderFlags
property of the individual fields to identify the fields that
should be updated. Then create an OnGetTableName event
handler to return the table name, and the provider will generate
the SQL statements automatically. If you need to update
multiple tables for each record, add a BeforeUpdateRecord
event handler to the DataSetProvider. In the event handler, you
can generate the SQL statements for each table and execute
them.

Tänan.


"Arvo Vill" <ar...@clannet.ee> wrote in message
news:40c5c26d$0$3100$bb62...@diablo.uninet.ee...

0 new messages