I am trying to get a table that has inner joins to update only the values of the main table.
I am using a BeforeEdit event and setting BeforeEdit=false
then using a Dal update to update the fields.
I am able to get the values fine except for any key fields.
I have tried using values("id") and keys("id") to no joy.
I get the other values but not the ID field. I do have 3 key fields in the inner join table but each are called id, id1, id2.
id is the main key field of the main table called "proof_set_page_annotations".
I can not access any of them through the BeforeEdit event.
Here is the code I have tried:
dal.Table("proof_set_page_annotations").Param("id")=values("id")
dal.Table("proof_set_page_annotations").Value("retouch")=values("retouch")
dal.Table("proof_set_page_annotations").Value("recrop")=values("recrop")
dal.Table("proof_set_page_annotations").Value("pip")=values("pip")
dal.Table("proof_set_page_annotations").Value("pickup")=values("pickup")
dal.Table("proof_set_page_annotations").Value("data")=values("data")
dal.Table("proof_set_page_annotations").Value("unlock_cropping")=values("unlock_cropping")
dal.Table("proof_set_page_annotations").Value("xmpie")=values("xmpie")
dal.Table("proof_set_page_annotations").Update()
BeforeEdit=false
I also uploaded to your demo site:
http://demo.asprunner.net/lbragg_rex3_com/ink29f/assign_task_list.asp