Universal Table Editor is an ASP application to view and edit data in any database you can reach via ADO from your IIS. Compatible databases are e.g. MS Access™, MS SQL Server™ or Oracle™.

UTE is also able to export the data of a table into comma delimited text files (.CSV) which are readable e.g. by MS Excel™.

UTE is a set of files representing just one single VBScript class clsUTE which can be used in simple ASP pages or the most complex environments.

Everything UTE uses is encapsulated within the clsUTE class so there shouldn't be any namespace problems at all. UTE defines all variables correctly so it is option explicit proof. The layout of UTE is completely style sheet driven so it is quite simple adjustable to any layout.

Former UTE versions (<= 1.4) used session variables quite extensively. This is history now! UTE uses no session variables any more. UTE includes an .inc file defining all language dependant settings and strings.

It already comes with a number of pre-defined language files (English, German, French, Italian, Spanish) but it is not much of a problem for you to extend this list by your own.

Features:

• Insert, edit and delete records in a table.


• Define any number of filters to shorten the number of records.


• Export complete table content as .CSV file.


• Show the exact field definitions.


• Sorting of each column.


• Automatic primary key detection.


• Display the currently used SQL statement to read the datas from the Database.


• UTE is one VBScript class with some few easy to use public properties and functions.


• In action UTE is controlled via URL parameters.


• The layout is completely style sheet driven.


• All displayed strings are defined in a special language include file.


• Error management.


• UTE is option explicit proof.


• Binary Data types will not be displayed and are not editable