I have a master-detail cached update transaction. the master table uses dbedit boxes while my detail table uses a dbgrid.
My system allows both creating and editing transaction. The problem is with editing the transaction.
1.) I successfully retrived the master-detail tables.
2.) I tried to delete all the detail records then add new detail records onto it.
3.) When i applied updates, the system just hanged! Everytime I repeat this process, it hangs.
When I checked the current activity log of my sql server, the delete sql statement is highlighted. If i'm not mistaken, the deletion caused the sytem to hang. What's more confusing is that, when i transport it to ms access, it caused no problem. Ms Access allows deleting of details records. Why does Sql Server not allow this? anyone encountered this.. Please help!