StudioWorks - Features - SQL Made Easy

StudioWorks comes with pre-written logon object classes and table classes that handle different relational databases. (FrontBase, OmnisSQL, MySQL, PostgreSQL, SQLServer, ...) A generic sign-in (logon) window is provided.

You can get an application up and running and logged onto a SQL relational database without having to first study non-visual DAMs, session objects, statement objects, table classes, etc.

Special code in the base table class makes it possible to issue a $dowork (insert/update/delete records) with a smartlist that is based on a query class that joins multiple tables. Something not normally possible to do in Omnis Studio.