| |
| Publicado el 17,junio 2015 - 23:00 |
I have 2 Analysis files/tables that are linked together and the deletion rule of the parent table is to delete the parent and all children. If I delete a parent record with HDelete() that should delete all corresponding children right?
ParentFile(0,n)----->ChildFile(1,1) on ParentID
Deletion rule is the parent and all children
I just tried this, and it did not delete the child records of the parent I deleted. Am I grasping this correctly? |
| |
| |
| | | |
|
| | |
| |
| Publicado el 18,junio 2015 - 17:40 |
Yes, you are correct.
I've not tried this, and it's just a guess, but could there be another Parent linked to the same child?
Like:
Parent1 --> Child1
Parent2 --> Child1 |
| |
| |
| | | |
|
| | |
| |
| Publicado el 19,junio 2015 - 16:36 |
| Nope. The way it is set up each child can only have one parent. Hmmmmmm. I wonder why it's not working as intended. |
| |
| |
| | | |
|
| | |
| |
| Publicado el 19,junio 2015 - 18:18 |
Hi Curtis,
If you're using HFSQL then you should check if the link is correctly propagated to the HFSQL server.
Check the tab "links"in the control center.
Note that links are only updated by the synchronization of analysis and data if the data files are actually created before updating.
If not, first create the files and do another update.
Regards,
Piet |
| |
| |
| | | |
|
| | |
| |
| Publicado el 19,junio 2015 - 18:31 |
| The link exists in the HFSQL control center. Deletion is set to Cascading. |
| |
| |
| | | |
|
| | |
| |
| Publicado el 19,junio 2015 - 19:47 |
There was been an updated release of HFSQL CS yesterday.
If you have not already done so install this and see if cascading deletes work. |
| |
| |
| | | |
|
| | |
| |
| Publicado el 19,junio 2015 - 20:43 |
Derek,
I'm assume the final version 20 I downloaded and installed yesterday came with the updated HFSQL? |
| |
| |
| | | |
|
| | |
| |
| Publicado el 20,junio 2015 - 17:49 |
Hi
I used to use this feature in the past but now always do it with coding. It is easily done
and can be used to delete more items like parent child grant chield.
Just my opinion
regards
Allard |
| |
| |
| | | |
|
| | |
| |
| Publicado el 20,junio 2015 - 18:27 |
Curtis
Yes, it is an option on the install menus.
Alternatively you can download it independently from the WD download page.
I would assume, but do not know, that they are the same thing. |
| |
| |
| | | |
|
| | |