|
Server : Apache/2.4.62 System : FreeBSD fbsdweb2.web.rcn.net 14.1-RELEASE FreeBSD 14.1-RELEASE releng/14.1-n267679-10e31f0946d8 GENERIC amd64 User : www ( 80) PHP Version : 8.3.8 Disable Function : NONE Directory : /domains/mguerinweb/Offline_Archive/TableEditor/ |
Upload File : |
========================================================
R E A D M E
========================================================
2eNetWorX TableEditoR v0.81 Beta
http://www.2enetworx.com/dev/projects/tableeditor.asp
--------------------------------------------------------------
1. How to Install?
Please see install.txt.
2. What's New in Summary?
* TableEditoR v0.81 Beta is made possible by the team:
� Rami Kattan - Development and implementation
� Jeff Wilkinson - Testing, feedback and ideas
� Most contributions are compiled into this release
� Client side TDC dataview for Internet Explorer
� Dynamically configure your settings over the web
� Dynamically define your connections over the web
� Dynamic paging support
� Export to XML
� Export to Excel
� Better support for parameterized queries and stored procedures
� Security fixes
� Fixes for well known and small bugs
3. What's New in Detail?
This update was based on official TableEditor v0.7 Beta release.
What's new in v0.81 including features in v0.8:
-----------------------------------------------
* Table contents are viewed using Microsoft Tabular Data Control (TDC), that means the table is built client-side, not server side, server only sends the base data in CSV (Comma Seperated Values) format. This saves a lot of the transfered data (see note 1 below).
NOTES:
* I don't know how to test Stored Procedures, so this TDC may have errors.
* Search also work with this TDC view.
* TDC works in Internet Explorer (4.0 and above).
* Sometimes, when adding/deleteing records, and pages become more or less, and navigation buttons doesn't show, click once or twice on "Refresh".
* Added May 2, 2002: In addition to the TDC viewing, normal table viewing is also available (automatic check for browser).
- Sorting: sorts the according to any column Ascending or Descending.
+ Databases are defined in a database, and can be administrated via web.
+ Defining new Access databases is easy, user can select through a list (Explorer-like) of databases in a folder.
+ Configurations are in the administrator database, not te_config.asp, can be changed easily with a web browser.
+ Administrator can check Active Users (in Config, enable: CountActiveUsers).
* Autoincrement fields are automatically incremented, no need to fill them.
* Date fields have an option to insert today's date.
* Required fields (don't accept null) are marked with [*] (Under experiment)
* Interface changes, highlight rows on mouse over/click (in Config, enable: HighLight).
+ Dynamic paging functions (in Config, enable: PageSelector).
* Compact/Backup all access databases (administrators only) (in Config, enable: BulkCompact).
+ Switch between tables and databases using combo boxes (in Config, enable: ComboTables).
Fixes and updates:
-------------------
+ Fixed export to Excel
+ Better compatibility for more browsers
- Fixed the security risk in v0.7 (by Jeff Wilkinson)
+ Display OLE images (by schwarzk)
+ View all records in a table (by Pete Stucke)
* Dynamic recordset paging (by PStucke) + fixed when records per page become more, while we are on last page, it will go automatically to the real last page (will not display blank page)
+ Export to excel (by Pete Stucke) (in Config, enable: ExportExcel)
+ Multidelete check/uncheck all (by Pete Stucke)
+ Backup database (by unknown)
- ... and some few other fixes, that are not so visible (at least to my testing).
Legend:
+ Added
* Improved
- Fixed
Compatibility:
--------------
Browsers:
- Internet Explorer 4.0 and above (for TDC advanced viewing)
- Other browsers (Normal viewing):
+ Netscape 6.0 (most features work)
+ Mozilla 1.0 (99% of features work)
+ Konqueror for Linux (most features work)
Databases:
- Access
- DSN
- SQL Server 2000 (basic testing)
-------------------------------------------------------------------
(1) Performance experiment
Tested data transfer for a 800 record database, results were:
New format: Page = 14566 Byte DB = 492443 Byte
total = 507009 Byte
Old format: Page = 1018065 Byte
Saves nearly 50% of the transfered data
-------------------------------------------------------------------