|
| [WD20] Integrity Bug - Children Not Deleted |
| Iniciado por guest, 22,oct. 2015 17:24 - 6 respuestas |
| |
| | | |
|
| |
| Publicado el 22,octubre 2015 - 17:24 |
I am using client/server. I have a file named Inventory and a file named InventoryItem. I have set up a link between the two with the option, "Delete the Inventory and all InventoryItem". When I delete an Inventory from my program the children(InventoryItem) do not get deleted. My deletion code is HDelete(Inventory,HRecNum(Inventory)).
Thoughts? |
| |
| |
| | | |
|
| | |
| |
| Publicado el 22,octubre 2015 - 21:50 |
Hi,
Maybe your index is corrupted. Try repair. |
| |
| |
| | | |
|
| | |
| |
| Publicado el 22,octubre 2015 - 23:22 |
| Did not change anything. Thanks though! |
| |
| |
| | | |
|
| | |
| |
| Publicado el 23,octubre 2015 - 07:43 |
Hi Curtis,
it may be that the analysis includes duplicate file links after some changes to the analysis. Just use the HFSQL Control Center to view the file links of the two files and delete / correct the situation there. |
| |
| |
| | | |
|
| | |
| |
| Publicado el 23,octubre 2015 - 21:56 |
| Was not able to find any duplicate links, thanks though! |
| |
| |
| | | |
|
| | |
| |
| Publicado el 24,octubre 2015 - 00:17 |
| Fixed it by deleting the link, checking back in to scm, checking back out and re-adding the link. Maybe something was corrupt that did not get fixed by repairing and reindexing the db? |
| |
| |
| | | |
|
| | |
| |
| Publicado el 24,octubre 2015 - 09:38 |
Hi Curtis,
This is a cool feature but I personally never use it.
I alway do following.
1 Before removing the inventory surch if ther eare any lines . If so delete all of them
If Hreadseekfirst( inventoryline, inventoryID,Invetory. InventoryID) then
For all inventoryline where inverntoryID = inventory.inventoryID
Hdelete( inventoryline)
end
End
Then you can delete the inventory file .
Bit more coding but it gives me a more save fealing
Regards
Allard |
| |
| |
| | | |
|
| | | | |
| | |
|