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

  • Hello,

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


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


    the query return nothing without error.

    the value of dateaircraftpartinstallation is from:

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

    Do you know how can I solve this problem?

    Thank you very much


  • 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'))

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

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


    Using the right id, of course.

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

  • This post is deleted!

  • 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 ;-)

Log in to reply