Date, Time, and DateTimeOffset Data Types

Labels
AJAX(112) App Studio(7) Apple(1) Application Builder(245) Application Factory(207) ASP.NET(95) ASP.NET 3.5(45) ASP.NET Code Generator(72) ASP.NET Membership(28) Azure(18) Barcode(2) Barcodes(3) BLOB(18) Business Rules(1) Business Rules/Logic(140) BYOD(13) Caching(2) Calendar(5) Charts(29) Cloud(14) Cloud On Time(2) Cloud On Time for Windows 7(2) Code Generator(54) Collaboration(11) command line(1) Conflict Detection(1) Content Management System(12) COT Tools for Excel(26) CRUD(1) Custom Actions(1) Data Aquarium Framework(122) Data Sheet(9) Data Sources(22) Database Lookups(50) Deployment(22) Designer(177) Device(1) DotNetNuke(12) EASE(20) Email(6) Features(101) Firebird(1) Form Builder(14) Globalization and Localization(6) How To(1) Hypermedia(2) Inline Editing(1) Installation(5) JavaScript(20) Kiosk(1) Low Code(3) Mac(1) Many-To-Many(4) Maps(6) Master/Detail(36) Microservices(4) Mobile(63) Mode Builder(3) Model Builder(3) MySQL(10) Native Apps(5) News(18) OAuth(8) OAuth Scopes(1) OAuth2(11) Offline(20) Offline Apps(4) Offline Sync(5) Oracle(10) PKCE(2) PostgreSQL(2) PWA(2) QR codes(2) Rapid Application Development(5) Reading Pane(2) Release Notes(180) Reports(48) REST(29) RESTful(29) RESTful Workshop(15) RFID tags(1) SaaS(7) Security(80) SharePoint(12) SPA(6) SQL Anywhere(3) SQL Server(26) SSO(1) Stored Procedure(4) Teamwork(15) Tips and Tricks(87) Tools for Excel(2) Touch UI(93) Transactions(5) Tutorials(183) Universal Windows Platform(3) User Interface(338) Video Tutorial(37) Web 2.0(100) Web App Generator(101) Web Application Generator(607) Web Form Builder(40) Web.Config(9) Workflow(28)
Archive
Blog
Tuesday, December 22, 2009PrintSubscribe
Date, Time, and DateTimeOffset Data Types

The latest update of the premium projects includes an improved handling of Microsoft SQL Server 2008 data types date, time, and datetimeoffset in generated code and Code OnTime Designer.

Adaptive filtering now works correctly with time and datetimeoffset. Filtering of datetimeoffset fields has been improved to automatically perform range filtering by including in the filtered results any matching dates in a range –14 hours to + 14 hours from the selected date.

Styling of tabs in  Web Site Factory applications has been slightly improved to make them “seem” large even though only 1 pixel of height has been added to tabs. You can see the current styling at http://dev.codeontime.com/demo/WebSiteFactory1/Pages/Home.aspx.

Coming Soon

The upcoming updates will include support for HtmlEncode attribute on fields to allow display of HTML markup stored in the database in the client-side views. The encoding occurs by default. It will be possible to turn it off.

We will be providing additional themes for Web Site Factory applications. The themes will be available to Code OnTime Designer subscribers only.

We are working on support for actions sets. An action set is a collection of action groups that you normally find in data controllers. It will be possible to develop custom action sets and link them to data controllers. This will make data controllers much smaller and will make it easier to maintain large projects.