Cascade Update does not work?

mpol_ch · Post by **mpol_ch** » Wed Aug 07, 2013 7:22 pm

Hello
I have the following two tables. Cascade delete works with no problem. It means when I delete the record in master table then all releated records are deleted in detail table too. But when I update the email in master table then the email in detail table are not updated and the relation from master to detail table is then lost. Am I doing a consideration mistake?

Table Master: users Primary Key: Id [INT], email [VARCHAR 50]
Table Detail: usersactions Primary Key: list_Id [TINYINT] AND Email [VARCHAR 50] (Composed KEY)

Relation: users.email=usersactions.Email`

Thanks for any hint.
mpol_ch

Post by **Webmaster** » Thu Aug 08, 2013 12:12 pm

Try the revised template:
http://www.hkvstore.com/phpmaker/templatefile.asp

mpol_ch · Post by **mpol_ch** » Thu Aug 08, 2013 4:18 pm

hello
thanks. It works perfectly with new template.

mpol_ch