## Rico 2.0 Examples

- LiveGrid Wiki
- Online LiveGrid Examples

Browser Compatibility

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:

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.

Accordion & Panel

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

SimpleGrid

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

LiveGrid: PHP

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.

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
3. Filter as you type - same as previous example, except filters are applied as you type
4. 3 grids on a page - drill down from customer, to orders for a customer, to line items on a specific order
5. Select a range of cells and fill them in from the pop-up menu
6. Check boxes generated by SQL query
7. Check boxes in pre-filled grid
8. Editable grid with pop-up forms
9. Yahoo Weather via AJAX
10. Rico Spreadsheet

LiveGrid: ASP

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.

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
3. Filter as you type - same as previous example, except filters are applied as you type
4. 3 grids on a page - drill down from customer, to orders for a customer, to line items on a specific order
5. Select a range of cells and fill them in from the pop-up menu
6. Check boxes generated by SQL query
7. Check boxes in pre-filled grid
8. Editable grid with pop-up forms
9. Yahoo Weather via AJAX
10. Rico Spreadsheet

LiveGrid: .net

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.

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
3. Filter as you type - same as previous example, except filters are applied as you type
4. 3 grids on a page - drill down from customer, to orders for a customer, to line items on a specific order
5. Select a range of cells and fill them in from the pop-up menu
6. Check boxes generated by SQL query
7. Check boxes in pre-filled grid
8. Editable grid with pop-up forms
9. Yahoo Weather via AJAX

LiveGrid: Perl

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.

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
3. Filter as you type - same as previous example, except filters are applied as you type
4. 3 grids on a page - drill down from customer, to orders for a customer, to line items on a specific order
5. Select a range of cells and fill them in from the pop-up menu
6. Check boxes generated by SQL query
7. Check boxes in pre-filled grid
8. Editable grid with pop-up forms
9. Yahoo Weather via AJAX