Assign Null value to date mySQL

[Lainkes 0]

Hello,

 

I have a DateTimePicker field. The value (date) is saved to a field in my database (mySQL).

I have a checkbox that indicates that no date is needed when it is checked.

How can I write a Null value to my database instead of a date?

 

Thanks

 

Alain

[Uwe Raabe 2083]

How do you currently write a date?

[Lainkes 0]

I use this

FieldByName('STAT_CLOSED_DATE').AsDateTime := DTP_Close_Dossier.Date;: 

So I wrrte the value of the DateTimePicker to the database. 

The database field is a Date format.

[Attila Kovacs 634]

FieldByName('STAT_CLOSED_DATE').Clear;

[Cristian Peța 108]

 FieldByName('STAT_CLOSED_DATE').Value := Null

Easier to read for me.