Date issue
Posted: Sat Dec 08, 2018 6:56 pm
Hello,
please i need some help
i can't save the date from a datetimepicker into our db
it keeps blank
please i need some help
i can't save the date from a datetimepicker into our db
it keeps blank
Code: Select all
DB:
Planner.mdlProcedures.modifyDatabase("INSERT INTO historypayments VALUES (null, " & Util.quote(6) & ", " & Util.quote(mydate.value) & ", " & Util.quote(1) & ", " & Util.quote(0) & ");")
Code: Select all
Thank youCREATE TABLE [HistoryPayments] (
[mid] INTEGER PRIMARY KEY AUTOINCREMENT NULL,
[mnum] INTEGER NULL,
[mdate] DATE NULL,
[mstatus] INTEGER DEFAULT '1' NULL,
[mskip] INTEGER NULL
)