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.

Notes:

1. In these configurations scrollbars are hidden when the menu is displayed (the scrollbars interfered with the menus).
2. 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.
3. LiveGridForms is not recommended with Opera due to a bug in the way it handles select boxes.

1. Basic Accordion
2. Accordion with 3D backgrounds
3. Accordion used for site navigation
4. Nested accordions
5. Tabbed panels

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.

1. 4 SimpleGrids arranged in a 2x2 table
2. 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
• Same as above, but editable via pop-up forms
• 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
• Same as above, but editable via pop-up forms
• Same as above, but the 3 grids are displayed one at a time (created dynamically)
• 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
• Rico Spreadsheet
• Yahoo Weather via AJAX

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, DB2 Express-C, 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
• Same as above, but editable via pop-up forms
• 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
• Same as above, but editable via pop-up forms
• Same as above, but the 3 grids are displayed one at a time (created dynamically)
• 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
• Rico Spreadsheet

The .net-based XML data provider (ricoXMLquery.aspx, ricoXmlResponse.ascx) has been tested with the following databases: SQL Server 2005, Oracle XE, DB2 Express-C, MySQL 4.1, MS Access. The code is based on the ADO.net library, so it should work with any database that has an ADO.net data provider.

• 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
• Same as above, but editable via pop-up forms
• 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
• Same as above, but editable via pop-up forms
• Same as above, but the 3 grids are displayed one at a time (created dynamically)
• 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
• Rico Spreadsheet

The Perl-based XML data provider (ricoXMLquery.pl) is based on the dbi library and has been tested with the following databases: SQL Server 2000/2005, Oracle XE, MySQL 4.1, MS Access. Perl's lack of direct support for session variables has made it difficult to port code from the other Rico plug-ins. We are looking for contributors who would like to take up this challenge and more fully integrate this plug-in with Rico.

1. Simple demo with pre-filled grid - takes advantage of LiveGrid scrolling, but no AJAX
2. Simple demo with 1 grid - orders for all customers are retrieved via AJAX