Date issue

3 posts Page 1 of 1
Contributors
User avatar
Dummy1912
VIP - Donator
VIP - Donator
Posts: 1969
Joined: Sat Aug 21, 2010 2:17 pm

Date issue
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
visit us on:


http://www.softpedia.com/get/System/Lau ... -Run.shtml
Check it out ! http://www.softpedia.com/publisher/I-A- ... 90017.html
Check it out ! http://www.softpedia.com/get/Desktop-En ... lock.shtml
User avatar
CodenStuff
Site Admin
Site Admin
Posts: 4389
Joined: Tue Aug 04, 2009 1:47 am

Re: Date issue
CodenStuff
Have you tried:
Code: Select all
mydate.value.date
Welcome to CodenStuff.com Learn Code, Love Code. Thank you for being a member of the community.
User avatar
Dummy1912
VIP - Donator
VIP - Donator
Posts: 1969
Joined: Sat Aug 21, 2010 2:17 pm

Re: Date issue
Dummy1912
Hello,

Yeah i did but still empty
visit us on:


http://www.softpedia.com/get/System/Lau ... -Run.shtml
Check it out ! http://www.softpedia.com/publisher/I-A- ... 90017.html
Check it out ! http://www.softpedia.com/get/Desktop-En ... lock.shtml
3 posts Page 1 of 1
Return to “Help & Support”