如果你能得到一个“Yes and”的建议，让工具变得更好，那就太好了。我们非常感谢北弗吉尼亚的罗纳德·美拉德先生，他好心地发送了以下增强SQL语句，帮助用户从Cobra数据库中删除一个项目——如果通过正常方式删除是不可用的。
我们发布的原始SQL语句为此，需要拨入SQL代码并替换要清除的每个表的字符串。这有点繁琐，如果您不熟悉SQL语句，可能会有点反感。然而，Ronald的版本为每条记录打开一个提示对话框进行更新，对于我们来说，这是一个风险较低的SQL“不舒服”选项。
SQL是在Cobra的SQL命令实用程序中打开的，但不需要搞乱SQL语句使其工作。您只需单击Execute按钮，并在生成的Prompt对话框中输入要删除的项目名称。
这个脚本从Cobra数据库中的21个不同的表中删除项目，所以只需要输入想要删除的项目名称一次就可以了。我们对此进行了测试，效果很好。
在几秒钟内，我就从数据库中删除了项目，而没有使用任何SQL代码。
像往常一样，您必须通过选择蓝色的双箭头来刷新列表，或者您可以重启Cobra，以看到删除的项目名称从项目表中消失。
谢谢分享这个罗纳德，我相信它会被许多眼镜蛇人欣赏。
将此脚本复制到剪贴板，然后将其粘贴到记事本文件中。或点击这里下载SQL脚本文件。
———————————————————————
／*
*眼镜蛇脚本
＊
*的目的:
*以下语句清除数据
*／
设置vpcProgram = PADR(上层(inputbox(“项目名称”)),goApp.oFields。GetFieldLen(“项目。程序"));
DELETE FROM accounts WHERE PROGRAM = ?
DELETE FROM appmaptg WHERE PROGRAM = ?
DELETE FROM basedetl WHERE PROGRAM = ?
DELETE FROM basehiist WHERE PROGRAM = ?
DELETE FROM baseline WHERE PROGRAM = ?
DELETE FROM BASELOG WHERE PROGRAM = ?
DELETE FROM calcflds WHERE PROGRAM = ?
DELETE FROM cwp WHERE PROGRAM = ?
DELETE FROM classes WHERE PROGRAM = ?
DELETE FROM classeslink WHERE PROGRAM = ?
DELETE FROM codefield WHERE DIR_ID = ?
DELETE FROM costelem WHERE PROGRAM = ?
DELETE FROM costrep WHERE PROGRAM = ?
DELETE FROM costrepclass WHERE PROGRAM = ?
DELETE FROM link WHERE PROGRAM = ?vpcProgram;
DELETE FROM milestone WHERE PROGRAM = ?vpcProgram;
DELETE FROM nartext WHERE PROGRAM = ?
DELETE FROM program WHERE program = ?
DELETE FROM set WHERE DIR_ID = ?vpcProgram;
DELETE FROM tphase WHERE PROGRAM = ?
DELETE FROM WST_DIR WHERE DIR_ID = ?
———————————————————————
阅读更多Deltek的文章点击这里