Further to this... Developer Studio does seems NOT offer this facility. I need further investigation it would seem. Though I have a suspicion that type=Query may be such that the query is executed once at server start-up time (or form save time) and should be treated as type="Custom". But finally this all may be a red herring and - alas - Query type enums seems an idea mooted and abandoned. I am also suspicious that I've had a memory hit (7.1 Win libs against Win 7.5p3) and the effect was not noticed until later. It seems that the enum causing the blow up in one form does not do so when the CSV option is applied. It is a rather large one but I would have thought I had encountered such before in the 7.1 v of ITSM. "SRM:MSM:SRMS",1000003217,"Status Reason2","Status Reason",6,"",0, "Enum: 1000: No Longer Required, 2000: Funding Not Available, 3000: To Be Re-Scheduled, 4000: Resources Not Available, 5000: Successful, 6000: Successful with Issues, 7000: Unsuccessful, 8000: Backed Out, 9000: Final Review Complete, 10000: Final Review Required, 11000: Additional Coding Required, 12000: Insufficient Task Data, 13000: In Verification, 14000: In Rollout, 15000: Insufficient Change Data, 16000: Schedule Conflicts, 17000: In Development, 18000: In Test, 19000: In Build, 20000: In Rollback, 21000: In Documentation, 22000: Vendor Purchase, 23000: Support Group Communication, 24000: Task Review, 25000: Miscellaneous, 26000: Future Enhancement, 27000: Manager Intervention, 28000: Accepted, 29000: Assigned, 30000: Built, 31000: On Hold, 32000: Need More Information, 33000: Approval, 34000: System Error, 35000: With Issues, 36000: Automatically Closed, 37000: More Information, 38000: Cancelled, 39000: Rejected", "$NULL$","" There are a small set of tables that cause my code to fail and I saw a trace that suggested it was in this area of the code. I worked around it by dumping one table at a time and then noting which tables caused problems. Tables are consistent but not across different arguments (dump fields only, to csv, fields and wf). I did a cursory inspection of the tables in the - what's it called - Developer Studio? Am finding it a bit difficult to get around there - but then I didn't watch those videos earlier. Nothing untoward here. When I get some more time - and perhaps my own VM upgraded :) - I'll dig into it a bit more. Cheers Ben
_____ From: Ben Chernys [mailto:[email protected]] Sent: January 30, 2010 8:45 AM To: '[email protected]' Subject: Finally, in 7,5, ENUM_STYLE_QUERY is in use! Some Qs ... Hi Guys, Gals, I have a bit of a question and (damn) it's a snowy weekend and I should be skiing instead. I noticed (with a protection exception in an error situation while trying to get a schema dump of ITSM 7.6) that AR_ENUM_STYLE_QUERY is now in use. Introduced in the 5.12 API, there have been no Remedy Administrators that offered the facility (until now presumably). There are a few forms in ITSM 7.6 that use this. My questions are rather simple. Do I have to perform the query myself? Or is there a convenient function that I can call to give me the appropriate set or single num/text (for my locale in ar_control - of-course). How is any server reference resolved? I may not match it against any servers I have and I may not even be signed on to it. (I don't copy user/pwd info in multiple ar_controls or sessions). And just how dynamic is this? Does the concept of a "set" make sense here? For example, can the query include fields from a user's "working record" or gotten record? Must I run the query each time I need a value / text check? (We may need an attribute like refreshcode from ARGetCharMenu() - why not in the CharMenu struct?). Menus do have a f() "Expand" for which I have this q() as well: How do I supply a set of fields/values for the queries? When I have an assignment to a record's enum I may have a variety of records gotten or even no records at all - as in Assign "xxxxx" to an enum field. It's obviously the way to go for a "data driven", "data customisable" app like ITSM (it's interesting to add association types etc to ITSM 7x). I would hope some expansion f()s are included with its use. I'm sure I'll have a bit more to ask as I delve a bit deeper into fleshing out this area. Looking forward to your responses. Cheers Ben Chernys www.softwaretoolhouse.com _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"
