Code On Time release 7.0.7.0 introduces the following features and enhancements:

• Quick Find supports "OR" if comma “,” or semicolon ";" are entered by the user. Expressions, such as "40 biscuit, beverages 10" are now supported. Quick Find will also skip "aliased" fields when composing a 'where' clause.
   
• Geo Tagging has been introduced in the client library to allow tagging data with latitude/longitude of the geographical location of the user at the time of data entry.
   
• Preview of 2nd generation data sheet view is integrated in the release. The new implementation supports horizontal scrolling and freezing of columns, vertical scrolling of data rows, and rendering of hierarchies in projects based on SQL Server and Oracle. 
   
• PostreSQL database engine is now supported.
   
• DB2 database engine is now supported.
   
• Virtualization node set plugin CreateBusinessRule assigns “id” attribute to enable dynamic registration of business rules.
   
• Designer correctly saves data fields when "Code Filter" property is changed.
   
• Navigation button is displayed correctly in IE10.
   
• Grid view templates are compatible with JavaScript business rules.
   
• Rich Text fields in modal form views will not raise an exception when a field value is changed and the form is closed.
   
• Data field support new "Tag" property to support column freezing, hierarchies, geo-location, and other future client library enhancements.
   
• Projects with custom membership correctly integrate an authentication module used to authenticate export and REST requests.
   
• Batch edit will correctly retain the selection of "update" checkboxes in the views with large number of fields.

A common practice in data sheets is to “freeze” a column so that essential information is always displayed for each row. The second generation data sheet allows both freezing columns at run-time, as well as configuring a column to be frozen at design-time.

Freezing at Run-Time

Create a sample Northwind web application. Browse the site, and navigate to the Order Details page. On the action bar, press Actions | Show in Data Sheet.

Activate the column header dropdown for Product Name, and press Freeze.

All columns up to the frozen column will change color. When the data sheet is scrolled to the right, the frozen columns will continue to be displayed.

Columns can be added or removed from the freeze by activating the Freeze option for that column. You may unfreeze the column by activating the column header dropdown and pressing Unfreeze.

Freezing at Design-Time

Start the Project Designer. In the Project Explorer, double-click on Customers / Order Details / container1 / view1 (OrderDetails, grid1) / grid1 / ProductID –> ProductProductName data field node.

Assign a tag.

Press OK to save the field. On the toolbar, press Browse. On the action bar, press Actions | Show in Data Sheet.

When the data sheet loads, the Product Name column will be frozen by default.

The frozen columns can still be changed by the user using the method described in the previous section.