Listers- For some reason I am having a very tough time with an active link qualification. I am using a display-only form with display fields to parse the contents of an XML data file into discreet fields to push to a regular form. The basic process is to use the XML tags to isolate the data in each element and do a set fields to a display field on the form, then strip the XML element (tags and data) from the front of the string and proceed to the next element. I am walking a table to loop through all the elements.
My problem is that any given record in the XML data may have zero to many Comments. There is an opening tag <COMMENTS> that will show there is at least one comment but if there are no comments then it will have a <COMMENTS/> tag instead. I have an active link that looks at the string and decides whether or not to call the guide for parsing out the comments but the qualification is not working at all. I first tried to test for the existence of the opening tag with this qualification where XML Data is the character field (size 0) that holds the contents of the XML file: 'XML Data' LIKE "<COMMENTS>%" However even when I can see that a previous active link set fields has set the XML Data field to a string that starts with <COMMENTS> this qualification fails. I tried to go the other way by using 'XML Data' LIKE "<COMMENTS/>%" (the tag which indicates no comments are present) and NOT 'XML Data' LIKE "<COMMENTS>%" but no matter what I try the qualification always fails. Am I missing something obvious about the way a LIKE operation works on a character field in an active link? I found documentation that it may not work properly when comparing to the database value of an unlimited character field but this is just a display field on a display-only staging form. Any suggestions would be greatly appreciated. Below is a screen shot of the data field at the time the qualification is evaluated: AR 7.6.04 SP2, custom application Windows Server 2008 MS-SQL Server 2008 -Rick ___________________________ Rick Westbrock QMX Support Services _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
