Database



  • what is wrong with this how can I read that value correctly from the database.

    my idea says i have to add ?1 but where

    Group {
    Name "Read13"
    Mode 3
    SQL "SELECT ?2 FROM Schakelaars WHERE Id=1"
    Period 2
    Items "SchakelaarAanString,SchakelaarAan"
    Type "ss"
    }



  • Hi Martijn,

    thank you for your question, however I'm not sure what you are after. Please, can you add some details? What do you get? Source files? What does System Log says?

    I also recommend you to have a look at example "0404-04 MySQL Reading Recipes" (try it out, read "readme") - it can help to achieve your goal.

    Let me know if I can be of assistance.

    Regards
    Tomas



  • @martijnperdaan said in Database:

    Schakelaars

    the input SwitchOn is variable sometimes it is Switch1On and sometimes Switch2On and sometimes Switch3On

    so he has to read the value of for example Switch1On from the tablet Switches
    for example, he should get back 01101010 as answer because it is stored underneath but he returns Switch1On in response

    the system does not log an error because the SQL command line must be normal


Log in to reply