Remove data from database upon deletion

[dave]

The Remove data from database upon deletion check box is greyed out (see attachment). Where can I backdoor it? I think it's the schema but I don't want to poke around in there. Thanks

[dave]

Well, I don't know if I am supposed to do this or not but I did. If you open the schema.mdb / tag_type table. Open it and find the field called "ALWAYS_DEL" If it has a F (false) it will be unchecked. a T (True) means it will be checked. Close Access and restart PA. The check box will be checked. B)

[PeterJ]

The remove from database upon deletion becomes enabled if the DeleteTagNumbers is set to No.
The DeleteTagNumbers can be set in the 'Project preferences' in project administrator or the 'Project Properties' in Document Manager.
That way you can enable the deletion of some tagtypes if the global delete is set to 'no'.

[Data Wrangler]

A question:

How many people store information in the database that is not on a P&ID? My company is only using the P&ID and Datasheet packages at present and we find it useful for audit and workflow purposes to have everything that is going into the database on a P&ID, even though this might mean that the component is placed on a hidden layer.

Are we unusual, or fairly common?

Derek

[dave]

For instruments, we have an instrument matrix drawing that shows all of the instruments that are not on the P&IDs. Depending on the job this page can be jam packed with instrument symbols and information

[dave]

The remove from database upon deletion becomes enabled if the DeleteTagNumbers is set to No.
The DeleteTagNumbers can be set in the 'Project preferences' in project administrator or the 'Project Properties' in Document Manager.
That way you can enable the deletion of some tagtypes if the global delete is set to 'no'.

thanks Peter, that enabled the check box though it appears that data is not being deleted no matter what the check box says

[dave]

Following up on this, I created a project from the base Bentley project. Both deletion fields are set to Yes in the project preferences but the tags are not deleteing out of data manager. I seem to remember this used to work.

[PeterJ]

Dave, is the status of deleted tags set to DEL ? (proj_stat field in INSTR and TAG_REG )
Or ddi you disable the automatic link update ? Check in p&id in p&id pull-down, preferences, link and regen options. The "link update mode" should be 'Automatic'.
If you change this function, it will be valid for all drawings that you edit on your computer.

[dave]

In addition to the PA settings, in P&ID the link and regen opions needed to be set to Automatic and Standard. Works great now. Courtesy of Ron Plasance from Bentley

[dave]

doop, just saw yours Peter, thanks!

[tw_echo]

A couple of questions regarding 'DeleteTagNumbers' and project set up.

Scenerio: 2D/3D project with instrumentation datasheets. I would like to have a project in which all tags are deleted with the exception of all instrumentation tags.

Solution thus far: I have set the project.ini 'DeleteTagNumbers' value to 'no'. Made sure that instrument tags had 'Remove data from database upon deletion' option unchecked. As a sample test I checked 'Remove data from database upon deletion' for the tag types 'AT_PROCESS' and 'AT_PIPERUN'. I have verified that the "link update mode" is set to 'Automatic'.

Discoveries: I found that instrumentation tags behaved just the way I had expected, they remained in the INSTR table with a 'DEL' status..perfect. Upon deleting process line and runs, it deleted the records in the PROCESS table and the PIPE_RUN table, but did not delete the record from TAG_REG but did set its PROJ_STAT ='DEL'. Am I missing a step somewhere or is this the functionality that I am to expect. I would really like to have the tag out of TAG_REG if possible because if the users need to add a tag that has a 'DEL' status, they still get prompted that the tag already exists...create additional link???? This question always throw our users for a loop as they are extremely weary of saying yes in case it is a 'true' additional link. Then they get prompted that the tag has been used and whether they would like to use the tag no. I wish the second prompt was actually asked first to provide some clarity...

Thanks in advance...
Tim