The DRI functional language has a new built in function. It accepts a path to a database and a SQL statement. The sql statement should return a record with one or more fields.
The function will create a variable with the same name and value of each field in the record. The variable names may be given an optional prefix to avoid conflicts with existing variables or keywords.
This command supports communication among the various modules of the system.
For instance, suppose a tooling rule is dependent on a property of a product processed by the engineering system. An example of this would be the method of profiling a window cutout in a door skin changing for different classes of light kits that could be installed in the door. The tooling system could query the engineering system and access details such as the light kit class being used.
The syntax of the function is:
+FSQLFIELDSASVARS(<DATABASE PATH>,<SQL EXPRESSION>[,<VARIABLE PREFIX>])
where the last parameter is optional and considered blank by default.