So, you are saying that you have a record in a table (Report) that's reporting that it has an attachment in an attachment field, but when you go look at the B table it's not showing there?...what about if you look in the BC table? Is the record there?
On Thu, Oct 4, 2018 at 1:27 PM Ben Chernys < [email protected]> wrote: > 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? > > > > [image: Note untranslated value in Report Name & Short Description – a > responsibility of the API. Note also that this is in Korean but the same > file appears in multiple records, presumably most are normal attachments > since all records have attachments and only a few come with the location > already retrieved and an Entry not found when executing the Get_BLOB f().]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 > [image: logoSthInc-sm] > > Canada / Deutschland > Mobile: +49 171 380 2329 GMT - 7 + [ DST ] > > Mobile +1 403 554 0887 > Email: Ben.Chernys_AT_softwaretoolhouse.com > <Ben.Chernys_AT_softwaretoolhouse.com> > > Web: 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. > > *Meta-Update <http://www.softwaretoolhouse.com/product/SthMupd/index.html>* > *,* our premium ARS Data tool, lets you automate your imports, > migrations, *in no time at all*, without programming, without staging > forms, without merge workflow. > > > > *Meta-Archive > <http://www.softwaretoolhouse.com/product/SthArch/index.html>* 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. > > > > *Meta-Databot > <http://www.softwaretoolhouse.com/product/Databot/index.html>* 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/ > > > > > > > > > -- > ARSList mailing list > [email protected] > https://mailman.rrr.se/cgi/listinfo/arslist >
-- ARSList mailing list [email protected] https://mailman.rrr.se/cgi/listinfo/arslist
