-
John Fauss
- PowerBuilder
- Thursday, 16 February 2023 04:16 AM UTC
Are there any documented restrictions or limitations on the use of global functions used in DataWindow expressions, where the global functions utilize non-visual objects (NVO's) and a DataStore?
Background:
I'm experimenting with global functions that analyze and encode string data to produce a variety of one-dimensional barcode styles (such as a UPC barcode) in a DataWindow, using TrueType barcode fonts. My goal is to be able to directly produce these barcodes in DataWindows utilizing these global functions in an expression contained within a computed field DWObject, eliminating the need to perform the necessary data encoding in a separate step in the application.
For most barcode styles, the data encoding steps are relatively simple. The steps can be coded in PowerScript within one or two global functions, and the computed field expressions work flawlessly to produce a barcode. However, GS1-128 barcodes are a different animal.
The GS1-128 barcode specification supports fields/records (called Application Identifiers, or AI's) within a single barcode. Each AI begins with a numeric prefix, followed by additional character and/or digit sequence(s). There are over 200 defined AI's, each with its own layout, so the parsing, validation, and encoding of GS1-128 data is considerably more complex than what is needed for other 1D-barcodes. I've created a DataStore for the AI definitions that has self-contained data (no data retrieval is needed) that is used in the data parsing and validation steps.
Problem:
Whenever a DataWindow expression that uses these GS1-128 barcode global functions is evaluated, PowerBuilder briefly hesitates, then goes POOF and terminates without any error messages. I suspect the DataWindow expression evaluator is blowing a gasket due to the creation and/or use of the pre-loaded DataStore, or the creation of the NVO's that contain the parsing, validation, and encoding logic, but at this stage that's only a guess on my part.
Question:
I realize these conditions are fairly unique. Has anyone ever successfully utilized a DataStore or other manually-instantiated non-visual objects in a global function that is referenced in a DataWindow expression? Any tips, suggestions or experiences are welcomed and appreciated.
John
Find Questions by Tag
Helpful?
If a reply or comment is helpful for you, please don’t hesitate to click the Helpful button. This action is further confirmation of their invaluable contribution to the Appeon Community.