Hi Folks,
I discovered something curious about attachment fields. I've never had an attachment field which had a value (ie a file) with a non-null location in a myriad of tables. I got one such from the Report table. A type = buffer. Locations are used when updating attachment fields - or so I had thought. No matter, I was using getblob to create the file even if the buffer was already in memory for another reason (when I had done a getblob to a buffer). I now simply create the file myself when an attachment field comes in “already retried” in a buffer, so there are no problems with this. Presumably, these “special” attachments are identified simply by their non-null attachment location on retrieval. I would wager that if I update this attachment field, it would transform this record’s attachment into a normal value and a record would be created in the Bxxx table. – I shall do that test shortly. Check out the Report form, there are a few records there with non-null attachment fields AND no record in the Bxxx table. When data is retrieved from those records, the attachment value has a name and the data in a buffer. When an update to an attachment field is made, no matter if a buffer or file is used, a new record is added to the Bxxx table. How is this attachment different than all the others? Data from my 9.1.02 system: 04/10/2018 13:10:35 e:\ > SthMry -S Report "'1' = \"000000000000842\"" om 1 matches) in Report <ArIds returned start> <Id: 000000000000842 →→ →→→ nullWeb nullCBK:ChargeBack null802; null2 null> <ArIds returned end > <-------------------->000000000000842 Request ID 000000000000842 Submitter BMC Software Create Date 2003/01/24 13:14:58 Assigned To Last Modified By AR_ESCALATOR Modified Date 2015/04/09 15:27:04 Status Active Short Description →→ →→ →→ →→→ Status History 1043439298♦dev_caga♥♥1482978799♦Action Request Installer Account♥ Assignee Groups 802; Locale ko Instance ID AG0050569E2243w0gPSAayxAdASvcH Assignee Groups_Parent zFormIdentificationMarkerField Form Name CBK:ChargeBack Report Type Web Report Attachment Field CBK_Adjustment.rptdesign Report Set Name Adjustment Report Server %% Override Query No Report Name →→ →→→ Designer Version Lock Override Option Yes Visible In Console No zTempInstanceCount Report Parameters Base Qualification '179' != $\NULL$ Date Range Field ID Date Range Report No Datatag config-fin Category 1 Category 2 Category 3 > mqry -q select schemaid from arschema where name='Report' "001" <-------------------->SQL row: 1 Col 0: 140 > mqry -q select * from B140 where c1 = '000000000000842' 131548.456 i ArQryGet returns 0 records for select * from B140 where c1 = '000000000000842' Cheers, Ben Chernys Senior Software Architect Canada / Deutschland Mobile: +49 171 380 2329 GMT - 7 + [ DST ] Mobile +1 403 554 0887 Email: Ben.Chernys_AT_softwaretoolhouse.com <mailto:Ben.Chernys_AT_softwaretoolhouse.com> Web: <http://www.softwaretoolhouse.com/> www.softwaretoolhouse.com We are a BMC Technology Alliance Partner Check out Software Tool House's free Diary Editor and our Freebies Section for ITSM Forms and Fields spreadsheet. <http://www.softwaretoolhouse.com/product/SthMupd/index.html> Meta-Update, our premium ARS Data tool, lets you automate your imports, migrations, in no time at all, without programming, without staging forms, without merge workflow. <http://www.softwaretoolhouse.com/product/SthArch/index.html> Meta-Archive does ITSM Archiving your way: with your forms and your multi-tenant rules, treating each root request as a complete tree and checking associatuions. Archive output to different servers, HTML pages with links to attachments or archive forms. <http://www.softwaretoolhouse.com/product/Databot/index.html> Meta-Databot is an automated, extensible BMC Data Wizard. It reads a file of data changes and sports an Undo feature. Pre ITSM 9.1.04? Clarify? HP? Roll your own? No problem! You can keep your valuable data! <http://www.softwaretoolhouse.com/> http://www.softwaretoolhouse.com/
image004.emz
Description: Binary data
-- ARSList mailing list [email protected] https://mailman.rrr.se/cgi/listinfo/arslist
