You are not logged in.
Announcement
Unanswered posts
|
Pages: 1

Hi
I dont need to obtain a working "update" for an import of data :
my first table, for input :
Cahier_input
------------
Format
NomCahier
NomEdition
datePublication
I got a lookup table :
Parution
------------
idEdition
idParution
NomEdition
datePublication
The join is made on (Nom Edition,datePublication) for the lookup.
I want to feed a table Cahier_Output with NomCahier (from Cahier_input) and idParution(from Parution).
The idCahier field is auto-incremanted :
Cahier_output
-------------
idCahier
NomCahier
idParution
When i set "Action on data" on the component Output on "Insert", all is fine.
But i want that when the "Cahier_input" is loaded again, the data of "Cahier_output" to be updated for the Cahier_input rows where the couple {idParution, NomCahier} already exists in "Cahier_Output"
I try to specify "action on data" of "cahier_output" component on "update or insert" and i have specified in the "advanced settings" tabs the fields "idParution" and "NomCahier" as keys for update, but it doesn't work.
What is the good way to proceed ??
Offline
Hello
When i set "Action on data" on the component Output on "Insert"
Try the action 'insert or update'
Best regards
shong
Offline
Pages: 1