DbDateTimePicker.caption???
lazarus / 31-LCL

----------------------------------------------------------------------
JanRoza · 2015-02-13 12:34

Hi,

I always thought that to get the value from a (zv)dbdatetimepicker
element you had to use the caption property, but as you can see from
the attached picture caption is empty while the formfield definitely
has a value in it.
Is this a bug in dbdatetimepicker or am I using the wrong property?
I've tested this with Lazarus 1.2.6 and FPC 2.6.4 and with Lazarus 1.4
and FPC 3.0.1 using a SQLite database.
Any suggestions to help me out of this problem are welcome.

----------------------------------------------------------------------
Zoran · 2015-02-13 13:41

Quote from: JanRoza on February 13, 2015, 01:34:00 pmI always thought
that to get the value from a (zv)dbdatetimepicker element you had to
use the caption property,

To get the value from a DB-aware component, you should use the
underlying field value, not the control's caption or text properties.
Please take a look at the conversation we had almost four years ago: h
ttp://forum.lazarus.freepascal.org/index.php/topic,12677.msg65875.html
#msg65875

Quote from: JanRoza on February 13, 2015, 01:34:00 pmAny suggestions
to help me out of this problem are welcome.

Label1.Caption := FormatDateTime('yyyy-mm-dd',
DBDateTimePicker1.Field.AsDateTime);

----------------------------------------------------------------------
JanRoza · 2015-02-13 23:41

Thanks Zoran!
Four years already? Time flies.
Unfortunately it turns out to be a database problem as the display now
shows the correct date but the moment I click away the message the old
data value reappears in the dbdatetimepicker.
So somehow my database is not accepting the value.
I'll have to do some more digging, strange things are happening here.