Page 1 of 1

Date issue

Posted: Sat Dec 08, 2018 6:56 pm
by 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

Re: Date issue

Posted: Sun Dec 09, 2018 3:18 pm
by CodenStuff
Have you tried:
Code: Select all
mydate.value.date

Re: Date issue

Posted: Sun Dec 09, 2018 3:25 pm
by Dummy1912
Hello,

Yeah i did but still empty