Best practice question on Date columns


Author
Message
Ross L. Rooker, Sr.
Ross L. Rooker, Sr.
StrataFrame User (245 reputation)StrataFrame User (245 reputation)StrataFrame User (245 reputation)StrataFrame User (245 reputation)StrataFrame User (245 reputation)StrataFrame User (245 reputation)StrataFrame User (245 reputation)StrataFrame User (245 reputation)StrataFrame User (245 reputation)
Group: Forum Members
Posts: 153, Visits: 462
If we have a BO that has a datetime column that we may at times want to use the date picker against in Strataframe what is the best method of setting the default in the BO Mapper and what is the difference between each method? IE... advantages, etc: FYI I mainly have used the first method which seems to work for SQL and Oracle.

First Setting: NULL VALUE OPTION = Return Alternate on Null / Set Null on Alternate (Value Type) and the NULL REPLACEMENT VALUE = new DateTime(1800, 1, 1)

Second setting:  NULL VALUE OPTION = Return Alernate on Null and the NULL REPLACEMENT VALUE = Convert.ToDateTime("1800-01-01 00:00:00.000")

Replies
Charles R Hankey
Charles R Hankey
StrataFrame VIP (1.3K reputation)StrataFrame VIP (1.3K reputation)StrataFrame VIP (1.3K reputation)StrataFrame VIP (1.3K reputation)StrataFrame VIP (1.3K reputation)StrataFrame VIP (1.3K reputation)StrataFrame VIP (1.3K reputation)StrataFrame VIP (1.3K reputation)StrataFrame VIP (1.3K reputation)
Group: Forum Members
Posts: 524, Visits: 30K
Regarding the Datebox :



Just substituting them for three dtPickers on a form and found that the TOController setting may not work the same way



Tabbing from the Day column takes one to the day column of the next datebox rather than out of the control and to the next control in the TOController sequence. Is there something I should be setting to change this behavior.



2nd question - I like the keys for first day of month etc. Is there fairly straightforward way - either by using subclasses or extension methods - to add the Quicken-like ability to increment and decrement the date by using the shifted or unshifterd plus and minus keys?



If it is more complicated I would suggest it as an ER.



(and yes, I will be looking closely at the source code to see if I can figure it out on my own, but thought there might be quick answer like availble Smile )

TIA

Trent Taylor
Trent Taylor
StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)
Group: StrataFrame Developers
Posts: 6.6K, Visits: 7K
Tab order should work the same. We use it on a daily basis and so it should work fine. I never say never as there could be something not taking into account, but it is based off of a control. So it should follow the same logic. Also, we use it in our medical app in a vast number of locations and have not had any issues. So you might need to give me a sample so I can see what you are running into.



Is there fairly straightforward way - either by using subclasses or extension methods - to add the Quicken-like ability to increment and decrement the date by using the shifted or unshifterd plus and minus keys?




At the moment, no. Plus and minus just move forward and backward on the date. Will take this into consideration.
GO

Merge Selected

Merge into selected topic...



Merge into merge target...



Merge into a specific topic ID...





Similar Topics

Reading This Topic

Login

Explore
Messages
Mentions
Search