Rico 2.0 LiveGrid examples have been tested on the following browsers and operating systems.
Except where noted, all aspects of the grid were fully functional.
|
Operating System |
Browser |
Windows XP |
Macintosh 10.4 |
Linux (Knoppix 5) |
IE6 |
*** |
|
|
IE7 |
*** |
|
|
FF 1.5/2.0 |
*** |
***1 |
*** |
Opera 9 |
***1,2,3 |
|
|
Safari 2.0 |
|
*** |
|
Camino |
|
***1 |
|
Konqueror 3.5 |
|
|
*** |
Notes:
- In these configurations scrollbars are hidden when the menu is displayed
(the scrollbars interfered with the menus).
- In Opera, when using double-clicking to invoke menus, you should
turn off Opera's "Double click text to display context menu" setting by
going to Tools -> Preferences -> Advanced tab -> Toolbars.
- LiveGridForms is not recommended with Opera due to a bug in the way it handles select boxes.
SimpleGrid's are new to Rico 2.0 and share some of the same functionality as LiveGrids - resizable columns, frozen columns, and frozen headings.
However, unlike a LiveGrid, the data is static (no buffering, no AJAX refreshes, no sorting, no filtering).
Why would you use a SimpleGrid? Because in some circumstances, it can perform better on the client than LiveGrid.
It is also more flexible in what each cell can contain - cells in a column do not all have to be of the same type.
If your web page is XHTML compliant, then they are also very easy to implement - just include an XSL stylesheet in your page
(which is included in Rico 2.0) and presto - your tables are turned into grids! The stylesheet just looks for tables
with a specific class and then does the transformation for you.
- 4 SimpleGrids arranged in a 2x2 table
- 4 SimpleGrids in a Rico Accordian
The PHP-based XML data provider (ricoXMLquery.php, dbClass2.php, ricoXmlResponse.php) has been tested with the following databases: MySQL 4.1, Oracle XE, SQL Server 2005, MS Access.
- Simple demo with pre-filled grid - takes advantage of LiveGrid scrolling, but no AJAX
- Simple demo with 1 grid - orders for all customers are retrieved via AJAX
- Filter as you type - same as previous example, except filters are applied as you type
- 3 grids on a page - drill down from customer, to orders for a customer, to line items on a specific order
- Select a range of cells and fill them in from the pop-up menu
- Check boxes generated by SQL query
- Check boxes in pre-filled grid
- Editable grid with pop-up forms
- Yahoo Weather via AJAX
- Rico Spreadsheet
The ASP-based XML data provider (ricoXMLquery.asp, dbClass2.vbs, ricoXmlResponse.vbs) has been tested with the following databases: SQL Server 2000/2005, Oracle XE, MySQL 4.1, MS Access. The code is based on the ADO library, so it should work with most ADO compatible databases.
- Simple demo with pre-filled grid - takes advantage of LiveGrid scrolling, but no AJAX
- Simple demo with 1 grid - orders for all customers are retrieved via AJAX
- Filter as you type - same as previous example, except filters are applied as you type
- 3 grids on a page - drill down from customer, to orders for a customer, to line items on a specific order
- Select a range of cells and fill them in from the pop-up menu
- Check boxes generated by SQL query
- Check boxes in pre-filled grid
- Editable grid with pop-up forms
- Yahoo Weather via AJAX
- Rico Spreadsheet
The .net-based XML data provider (ricoXMLquery.aspx, dbClass2.ascx, ricoXmlResponse.ascx) has been tested with the following databases: SQL Server 2000/2005, Oracle XE, MySQL 4.1, MS Access. The code is based on the ADO.net library, so it should work with most ADO.net compatible databases.
- Simple demo with pre-filled grid - takes advantage of LiveGrid scrolling, but no AJAX
- Simple demo with 1 grid - orders for all customers are retrieved via AJAX
- Filter as you type - same as previous example, except filters are applied as you type
- 3 grids on a page - drill down from customer, to orders for a customer, to line items on a specific order
- Select a range of cells and fill them in from the pop-up menu
- Check boxes generated by SQL query
- Check boxes in pre-filled grid
- Editable grid with pop-up forms
- Yahoo Weather via AJAX
The Perl-based XML data provider (ricoXMLquery.pl) has been tested with the following databases: SQL Server 2000/2005, Oracle XE, MySQL 4.1, MS Access. The code is based on the dbi library, so it should work with most dbi compatible databases.
- Simple demo with pre-filled grid - takes advantage of LiveGrid scrolling, but no AJAX
- Simple demo with 1 grid - orders for all customers are retrieved via AJAX
- Filter as you type - same as previous example, except filters are applied as you type
- 3 grids on a page - drill down from customer, to orders for a customer, to line items on a specific order
- Select a range of cells and fill them in from the pop-up menu
- Check boxes generated by SQL query
- Check boxes in pre-filled grid
- Editable grid with pop-up forms
- Yahoo Weather via AJAX