Database Process By Global Function Follow
oops: Sorry don't know how to change the topic, It's called that because I want to use a global function to extract the xml data in the field for various text boxes on the 5th template - despatch note. Forgot to mention that.
I have an issue with Bartender that is showing a blank field when it does contain data and would appreciate some help.
The label was getting very crowded and really difficult to maintain so I split it up into 8 templates each template is triggered by a datasource 'bsta', 'bend', 'bord','bdes' etc. which is held in the first non-printed label. The type is decided by the row of the results that effectively specfies the label type. This bit works fine, the correct data is printed in each case.
However, on one of the templates I have an despatch note (des), because the despatch note is basically a separate record in the same set of templates i decided the stored procedure should generate it as an XML field on the row that is the despatch row. This is the reason that the last field is xml meta data in the above example when the record is 'des'.
Again, this is all fine, if i drop a text control onto the form accessing DespatchMeta i see the value is correct.
So basically the label solution works fine (each one on a separate page) except for not being able to process the meta data yet.
So the obvious solution (as a first step) was to simply change the 'Despatch' template address text field type as follows:
VBScript: 'Single-Line Expression'
and watch the meta data flow onto the despatch page, er no!
When i do this nothing is displayed at all. I know that the data is correct but it appears to not have been prepared.
PS: I have tried:
- simpler fields that only contain 3 letters
- using Reference to reference the field
- using EventControlScripts and OnAutoSelectedEvent instead of the above SingleLineExpression
Only using the 'raw dump' of the field works. I need to process this field to extract the data held within it.
So, now I am at a loss. Really don't want to go back to the jumble of labels on one label as it was so difficult to maintain!
Any help or other suggestions of a possible method of doing this elegantly greatly appreciated.
Bartender 10.1 SP1.
Please sign in to leave a comment.