CAPI.Exec() with Delete statement

I'm trying to use CAPI.Exec() with a delete statement to delete some nodes from the dtree table. It works but there is a problem, the parent node's childcount won't change.Any ideas?

Find more posts tagged with

Comments

eLink User

Message from Dylan Wright via eLinkUse DAPI.DeleteNode() or LLNode.NodeDelete()Sql modification of dtree is generally a very bad idea, and DAPI callsare there just so you don't have to worry about that kind of thing. -----Original Message-----From: eLink Discussion: Development Discussion[mailto:development@elinkkc.opentext.com] Sent: Friday, November 02, 2001 3:31 PMTo: eLink RecipientSubject: CAPI.Exec() with Delete statementCAPI.Exec() with Delete statementPosted by EDSCAUser5 on 11/02/2001 06:28 PMI'm trying to use CAPI.Exec() with a delete statement to delete somenodes from the dtree table. It works but there is a problem, the parentnode's childcount won't change. Any ideas?[To reply to this thread, use your normal e-mail reply function.]============================================================Discussion: Development Discussionhttps://knowledge.opentext.com/knowledge/livelink.exe?func=ll&objId=786303&objAction=viewLivelink Server: https://knowledge.opentext.com/knowledge/livelink.exe

Tech_Writer_(edscauser5_-_(deleted))

I thought it's supposed to have some triggers and stored procedures to handle the database modification, not just for the oscript build-in function.

Jeff_Lang_(lang_(Delete)_2245920)

The C++ and oscript handles all the additional calls to the supporting tables. We only use triggers for notification. We try to stay away from triggers and stored procedures because it makes it easier to migrate to other databases and platforms.