Breadcrumbs

[Dummy1912]

Hello,

please i need some help
i can't save the date from a datetimepicker into our db

it keeps blank

Code: Select all

        Planner.mdlProcedures.modifyDatabase("INSERT INTO historypayments VALUES (null, " & Util.quote(6) & ", " & Util.quote(mydate.value) & ", " & Util.quote(1) & ", " & Util.quote(0) & ");")

DB:

Code: Select all

CREATE TABLE [HistoryPayments] (
[mid] INTEGER  PRIMARY KEY AUTOINCREMENT NULL,
[mnum] INTEGER  NULL,
[mdate] DATE  NULL,
[mstatus] INTEGER DEFAULT '1' NULL,
[mskip] INTEGER  NULL
)

Thank you

[CodenStuff]

Have you tried:

Code: Select all

mydate.value.date

[Dummy1912]

Hello,

Yeah i did but still empty