update failed. found 0 records

[lascala]

Hello,
I working since hours at following problem :

After inserting, saving a new record and then trying to edit it, I receive
this message : "update failed. found 0 records"

my query looks like

SELECT
ucs_users.USER_REALNAME, ucs_users_1.USER_REALNAME, ucs_users.USER_FUNCTION, dta_planning.code_dta_projekt, dta_planning.name, dta_planning.id_par_shdevents
FROM
security.ucs_users
INNER JOIN sac.dta_planning ON ucs_users.USER_ID = dta_planning.id_acc_users
INNER JOIN security.ucs_users ucs_users_1 ON ucs_users_1.USER_ID = dta_planning.id_Respo
INNER JOIN sac.par_shdevents ON par_shdevents.ID = dta_planning.id_par_shdevents
ORDER BY
dta_planning.code_dta_projekt


Any hint would be great

[Dimon]

Set the TCustomDADataSet.Debug property to True to display executing statement and all its parameters' values.
Also you can use the TMySQLMonitor component to monitor dynamic SQL execution in MyDAC based applications.