AppGini Community Forums

Hi,

I have a table that I am listing some events. Sometimes we don't know the starting time so we erase the content of the field and when I save that record the event starting time defaults back to 7:00 PM and I would like to leave that field blank if I don't know at what time the event starts. How do I clear that default or even some times default to a preset time that I assing. But I need to know mostly how to leave it blank for now.


Thanks,

I had a similar problema this is how I do it:
I just update the field with NULL based on a condition.

Something like:
Update tablename set Time = Null where Started <> 'Yes'

SOLVED
An it was way too easy you just change the default format into the default text of the field. In my case was 1:00 Am so I put the default text for that field was: 01:00:00 and that took care of the problem. Hope this answers many people asking for this.

nycwebmaster please can you expand a little on this with some code examples as I'm completely stuck! Thanks!

Maybe I am not understanding. You can put in a time in that Default box. I just created a new column of type Time and that Default was blank.

~Paul

Yes, I couldn't believe it was that easy myself.
Just put the default time you want as shown in the image in the Default textbox.