Главная страница | назад





Article #19676: Unable to resolve records. Table name not found

 Question and Answer Database
FAQ: FAQ4676D — Unable to resolve records. Table name not found
Category: Multi-tier
Platform: All-32Bit
Product: Delphi3.x, Delphi4.x,
Question:
I'm using ClientDatasets and my query has results from 2 tables.
How come when I insert, delete or update records I get the
error "Unable to resolve records. Table name not found"? I've run
SQL Monitor and notice that the UPDATE statement just says WHERE w.
Answer:
To update multiple tables you must generate the SQL yourself. If you have
Delphi 3, you can use an UpdateSQLProvider. If you have Delphi 4 you must
create 3 TQueries (One each for INSERT, DELETE and UPDATE statements).
From the TProviders BeforeUpdateRecord event determine which query to use
by the updatekind parameter and then execute the appropriate query
(populating the parameters along the way).
6/21/99 2:06:46 PM

Last Modified: 01-SEP-99