Devart Forums

Hi Antaeus, the TMyQuery Object has the property NullforZeroDate that shows NULL for Dates with value Zero. You can create a NULLFor30121899Date property? what functions in the same way? hiding the "30-12-1899" dates.

this property would be very good, with it does not to clean the fields it datetime.

We will investigate the possibility to add such option,
but due to low number of users' requests, it is unlikely that we will add it in
the nearest time.

Antaeus wrote:We will investigate the possibility to add such option,
but due to low number of users' requests, it is unlikely that we will add it in
the nearest time.

Hi Antaeus, thank for information, but this option is so simple that you it makes with the closed eyes and the hands moored without counting that this still leaves mydac more complete.

Thank you, mydac is a very good.

Yes, this option is simple to implement, but it makes MyDAC interface less intuitive. We will wait for other users' requests to take this decision.

Hi DevArt...

Zeos DBO show a Null value for a Date if = 30/12/1899, date = 0

you can implement a simple feature in MyDAC??

see the picture.

Please describe in what case do you need in this functionality?
The point is that the 30/12/1899 date is the correct date. If in your tables this date is equal to NULL value, you can just update tables and change 30/12/1899 to NULL.

The Problem is that 30/12/1899 are a date = 0, the majority of the desenvolvedores uses the date = zero to mark that the field dates is empty, and in the hour to show appears date 30/12/1899.

The behavior to hide date 30/12/1899 is native in the Zeos, does not exist a property for activated or to disactivate and nobody complains, for the opposite, the people likes very

Hi Anteus
I am one more to ask for the same thing. I agree with Eduardo (and you appears to have the same opnion) that this implementation is not a dificult thing to be done.
Best regards
Edison Garcia

Devart? please, implement this behavior. you can create a property to Enable or Disable this..

We have investigated this problem and we will add option to convert the "30-12-1899" date to NULL in the next MyDAC build.

Dimon wrote:We have investigated this problem and we will add option to convert the "30-12-1899" date to NULL in the next MyDAC build.

Thank's Dimon, i'm waiting

Hi Dimon

Thank you - I think it will be very usefull

Best regards

Edison

Dimon wrote:We have investigated this problem and we will add option to convert the "30-12-1899" date to NULL in the next MyDAC build.

Thank's for this new feature!

eduardosic wrote:

Dimon wrote:We have investigated this problem and we will add option to convert the "30-12-1899" date to NULL in the next MyDAC build.

Thank's for this new feature!

Dimon, i think in use Unidac.. this feature will be included in Unidac?

Yes, it does.