Hi again It turns out that it was a regional setting in windows, which was in turn formatting the number in the field with the set digit separator...
with regards, Jonas Stumph Stevnsvig Remedy Developer BEC Competence Centre Phone (+45) 46 38 20 08 Mobile (+45) 61 56 20 08 [email protected] [email protected] ________________________________ Fra: Action Request System discussion list(ARSList) [mailto:[email protected]] På vegne af Jonas Stumph Stevnsvig Sendt: 13. august 2009 10:00 Til: [email protected] Emne: Have I misunderstood something? [Vendor forms and DataType.Attachment] ** HI listers, I have this nagging problem. I just read through this plugin one of my colleagues has writtenm since it keeps inserting thousand seperators in integer values, which makes it impossible to use the value for a further lookup. eg 861002000 becomes 861.002.000 - now to the fun stuff: The field in the database is an integer. The field is regarded as a decimal in remedy. The API only formats fields of type Datatype.ATTACHMENT as %s.%s.%s and finally, my questions: 1. I thought Remedy disallowed attachemnt fields in vendor forms? 2. why is the integer interpreted as an attachment? 3. how can remedy justify allowing multiple decimal points in a decimal field? (ARS 7.5 patch 2, W2k3, MSSQL, vendor form connects to DB2 DB) I hope someone can help me spread some light on this subject. with regards, Jonas Stumph Stevnsvig Remedy Developer BEC Competence Centre Phone (+45) 46 38 20 08 Mobile (+45) 61 56 20 08 [email protected] [email protected] _Platinum Sponsor: [email protected] ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"
