PDA

View Full Version : PID Drawing number not populating in report


dave
11-20-2006, 10:01 AM
We had a problem a while back with one of our drawings (AT-2530). Basically it died (wagon wheeled everything) yet remarkably the data was still in the database even after I deleted the drawing (selecting all the appropriate check boxes). I created a new drawing (AT-2530) and created additional links on all of the data. So now in DM, I have line CD-0203 showing twice, one with a PID link and one without. I cannot PURP or delete the line number as it has already been ISO'd.

The problem is the report is using the blank value instead of the number value. How can I correct this for just one drawing? I created a new field in hopes that I could populate it and say, "if [pid no] is null then [pid2] else [pid no] When I try to populate the field in DM, it denies me saying "the field could not be updated. Please check the query definition..."

help?
PeterJ
11-20-2006, 01:32 PM
Dave, it looks like the entries in the key-link (and maybe the *-lnk) table are still present, but the entry in DOC_REG is gone.
You can try to clean these with the audit tool (be sure to have a backup !!) or clean the db yourself with some delete query.
You could also put a 'IsNotNull'-filter in the doc_name field in your query, but that will also remove items that you put on purpose only in your DB.

ps : do you know how the links are stored in the database?
dave
11-20-2006, 01:46 PM
Peter, thanks for the follow up.

I think I know how the links are stored, but I am sure your explanation will enighten me

The isNotNull filter will filter out stuff i need as you said.:)

Can you send me the audit tool. I have been without it for some time now. Thanks!
PeterJ
11-20-2006, 02:10 PM
I'll give some info on the Db relations later
The audit tool is in your own download-section ...
dave
11-20-2006, 03:33 PM
Sadly, the audit tool has been mysteriously deleted and I have been asking for someone to send it to me :)
tw_echo
11-21-2006, 10:12 AM
Dave,
Did you get the Audit Tool yet? If not, let me know and I will email it to you.

Tim...
dave
11-21-2006, 10:41 AM
I did not. Thanks Tim!
dave
11-21-2006, 02:15 PM
OK Peter J sent me the audit tool. Thanks Peter. I have run an audit on the drawing in question. I see the line numbers. If I right click / delete, will it delete the keytag and therefore my data? see attachment
dave
11-21-2006, 02:24 PM
w00, smooth like butta. Worked great. The bad data is out and the tag_number maintained it's integrity. I will re-link download for the audit tool from PeterJ