replacing date like '2018-01-01' by variable string on SQLITE query QML

filipdns

Hello,

I have JS query and QML calling the function and all is working fine is I write the date manually like here:

JS.dbaddpart(inConversationWith,'2018-01-01')

but when I'm trying to replace the date by variable like here:

JS.dbaddpart(inConversationWith,dateaircraftpartinstallation)

the query return nothing without error.

the value of dateaircraftpartinstallation is from:

Calendar {
            id:dateinstallationcalendar
            height:350
            width: 350
            anchors.verticalCenter: parent.verticalCenter
            anchors.horizontalCenter: parent.horizontalCenter
            focus: true
            visible:false
            onClicked:  {dateaircraftpartinstallation =Qt.formatDate(dateinstallationcalendar.selectedDate,'yyyy-MM-dd')
                }
            style: TouchCalendarStyle {}
        }

Do you know how can I solve this problem?

Thank you very much

Philippe

Leonardo

Where's dateaircraftpartinstallation declared?

If you have no other use for this property, you could also write

JS.dbaddpart(inConversationWith, Qt.formatDate(dateinstallationcalendar.selectedDate,'yyyy-MM-dd'))

filipdns

Hello at the top of the page i declare it with property string

Leonardo

In my experience, using a fully qualified name is always safer. Whenever using dateinstallationcalendar, try:

topofthepage.dateinstallationcalendar

Using the right id, of course.

filipdns

Using console.log I got the good value in the variable

filipdns

This post is deleted!

filipdns

I used the same variable for an other query and it's working...
I'm little bit lost but I will check tomorrow it's too late for today ;-)