Blog

Utilities for Uniface 10

Modern application development environments need to allow close integration of customer or community tools and utilities, to further enhance developer productivity. The IDE, delivered with Uniface 10, enables closely integrated extension through user defined worksheets and menu options.  

Many of you know that the Uniface Support team often creates utilities to automate or simplify some our day to day activities. With the new user defined integration, we have an ideal way of making these available to the community so have collected a number of these utilities, mainly enhanced versions of components found in the Uniface 9 IDF, together and packaged them up for anyone to use.

 What is included in this toolkit?

  • Create Referential Integrity
  • XSLT Workbench
  • Global Search
  • Cross Reference
  • Copy user data from entity editor

 

Create Referential Integrity

Generate SQL scripts for maintaining referential integrity within the database

 


XSLT Workbench

The XSLT Workbench is a tool for creating and testing XSLT stylesheets.


Global (Proc) Search

You can use the Global Proc Search dialog to search for commands, expressions, and operands in all Proc. It now also features a button that allows to directly open from the search result the related Code Editor.


 

Cross Reference Viewer

With the Cross Reference Viewer you can generate reports from the data of the cross-reference table. It now also allows you to directly open the related Code Editor from the cross-reference search results.


Additions menu

The different utilities can easily be accessed from the Main Menu ( ≡ ) of the IDE.


Additional stuff

The Uniface 10.3 IDE Additions project also includes an extra menu item for the Entity Editor that allows you to directly export the user data of the entity. This can be seen as a partial replacement of the Convert Data utility of the version 9 IDF.


Work in Progress

We still plan to add more features to the Uniface 10.3 IDE Additions project - so this is very much “Work in Progress”.

And the good news is that we are not going to keep this stuff to ourselves. The Additions can be downloaded from here (Uniface utilities, addons and extras). And in order to get the utilities working you just need to include the additions.asn at the top of your (or the default) ide.asn.


ASN example
; your ide.asn
[RESOURCES]
.\uar\ADDITIONS.uar

; ...

[LOGICALS]
IDE_DEFINE_USERMENUS = ADDITIONS
; ...


We hope the Additions utilities are helpful,


Uniface Customer Support


Please note, that although the utilities are uploaded by the Uniface team, it is made available as-is and is not in any way part of the regular Uniface product. Therefore the rules and regulations for Uniface maintenance and support do not apply to the Additions utilities.

Posts

  • No labels

2 Comments

  1. Are there any options to call for the Create Referential Integrity  from the command line, similar to /genSQL for creating database tables?  If not, are there any plans in the works for this?  When we build a new release of our application, we pull all of the components and structure into a fresh repository, recompile all objects, and then create new database structure from that.  The majority of this work is done through Windows command line batch scripting.  However, in Uniface 9.7, there isnt a facility to script database tables or referential integrity from the command line.  Discovering the /genSQL command line switch is huge for us because it allows us to generate table scripting via batch, eliminating a manual step.  Adding the ability to also generate referential integrity scripting via the command line would allow for another manual step to be eliminated.

  2. Daniel Iseli AUTHOR

    Not yet. There is a story on the product backlog of Uniface 10 to extend the /genSql functionality to also generate Referential Integrity scripts. No word yet when this could be picked up.