StudioWorks - Features
The following is a summary of some of the features included in StudioWorks. Click on a feature to obtain a more detailed description and see screenshots of how it is used.
Meta-Data Editor
The power of StudioWorks lies in the meta-data. The StudioWorks Meta-Data Editor lets you add extra properties to your schema classes and schema class columns. Meta-data includes display properties, database properties, default values... read more
SQL Made Easy
StudioWorks comes with pre-written logon object classes and table classes which let you avoid having to learn “raw SQL” and all the non-visual DAMs jargon. This make it very simple for you to get an application up and running without first learning SQL... read more
Database Administrator
Setting up and keeping your database in sync with your Omnis Studio application can be a lot work. The StudioWorks Database Administrator tool makes it easy. Using the SQL meta-data the Database Administrator can intelligently add tables, add columns, alter column datatypes, add indexes, add primary and foreign keys, set constraints, and collations... read more
Multi-Language
The applications you build in StudioWorks automatically support multiple languages. Windows, reports, buttons, menus, toolbars, and tooltips immediately reflect the language the user chooses when logging on... read more
Lookup Type-Ahead Field Handler
A lookup type-ahead field handler comes with StudioWorks. If multiple matching records are found the type-ahead handler defaults to the record last selected by the user... read more
Subwindow Toolbars
The toolbar class in Omnis Studio can not be instantiated in a subwindow. StudioWorks includes a toolbar subwindow which you can instantiate inside any subwindow... read more
Quick Search Bar
The quick search bar subwindow that comes with StudioWorks is completely generic. StudioWorks generates the column selection droplists from the meta-data... read more
Multi-Criteria Search Window
The multi-criteria search window that comes with StudioWorks is completely generic. Each user's last search is automatically recalled... read more
Auto-Configure Headed Lists
StudioWorks includes an auto-configure headed list subwindow. The auto-configure headed lists also support mult-sorting. When the user closes the window, StudioWorks stores the current sorting and column widths... read more
Auto-Configure Edit Windows
StudioWorks includes an auto-configure edit subwindow. The auto-configure subwindow is generated from the query class that you use for the subwindow... read more
Report Builder
You can simply send a SQL defined list of records to the StudioWorks report builder and the report builder generates a report for you on the fly... read more
Export Data
Export data code is included with StudioWorks, creating a tab delimited file with the records and columns that are displayed in the headed list... read more
Error Handler
Whenever you trap an error in your code, you send an error message to the StudioWorks error handler object. The error handler writes the error information to a local error log file or a table in the database... read more
Prompt Windows
StudioWorks includes an “oPrompts” object class with a whole series of generic prompt windows which support: 1000s of characters of message text, multiple input fields, auto-configure headed lists, radio buttons... read more
Security
StudioWorks provides several layers of security and hooks for developers to add more. Groups are created and given access to specific window instances. Groups are granted (or denied) view/edit/insert/delete permission for schema classes. Users can belong to multiple groups... read more
Menus on-the-fly
Window menus and context menus are created on-the-fly, and they use the current language text... read more
Documentation via StudioTips
A special enhancement was added to StudioTips to allow developers to view StudioWorks documentation through the StudioTips browser... read more