topic Which method is better, truncating the attachment table or using remove attachments? in Python Questions

Which method is better, truncating the attachment table or using remove attachments?

RPGIS — Fri, 19 Aug 2022 17:16:52 GMT

Hi,

I have a simple yet general question. I have a script that adds attachments to a related table. However, whenever I script to renew the attachments(remove and add attachments), it seems that they don't attach to the correct records.

My question is, would it be better to write my script to recreate the table to then remove attachments or would the truncate option work as well? I am trying to configure my code to so that the attachments (in the future) are are kept up to date and account for any additional changes.

Re: Which method is better, truncating the attachment table or using remove attachments?

Anonymous User — Fri, 19 Aug 2022 19:50:38 GMT

Some tables (I think versioned tables) will not allow you to truncate. If the the attachments are not attaching to the right record in your refresh script without recreating the whole table, I'd step through it with the debugger and figure out why.

Re: Which method is better, truncating the attachment table or using remove attachments?

RPGIS — Sat, 20 Aug 2022 19:07:41 GMT

That's what I'm working on. I'm rewriting that part of my script to remove and update the attachments. The script is complicated in such that it exports pdfs from a map series and then sets those as attachments.