Database Write



  • is there a limit to the number of lines you can add to the ODBC database driver ?.

    if I add another line, he gives a fault with everything I remove that line again, it is fine again

    see here under my mysql_ioconfig.rio

    ODBC {
    Connection "DRIVER=MySQL;SERVER=;PORT=;DATABAS"
    "E=;UID=;PWD=*******;;"
    #Comment1 "Archive modes: 0=disable, 1=alarm(columns Time,Alar"
    #"mID,Code,Level,Value), 2=group(columns Time,GroupID,Value1,Value2,...), 3=gro"
    #"up(SQL with ? in order Time, ID, value1,...)"
    #Comment2 "Group modes: 0=disable, 1=read (last ID is accepted"
    #"), 2=read(last Time before now is accepted), 3=read(SQL first line is accepte"
    #"d), 129=write, 130=write with Time, 131=write SQL (with ?, Time is ?T)"
    #GUID *******
    Group {
    Name "Read"
    Mode 3
    SQL "SELECT Schakelaar1Uit, Schakelaar1Aan, Schakelaar"
    "2Uit, Schakelaar2Aan, Schakelaar3Uit, Schakelaar3Aan, Schakelaar4Uit, Schakela"
    "ar4Aan, Schakelaar5Uit, Schakelaar5Aan FROM Schakelaars WHERE ID=1"
    Period 2
    Items "Schakelaar1Uit,Schakelaar1Aan,Schakelaar2Uit,Scha"
    "kelaar2Aan,Schakelaar3Uit,Schakelaar3Aan,Schakelaar4Uit,Schakelaar4Aan,Schakel"
    "aar5Uit,Schakelaar5Aan"
    Type "ssssssssss"
    }
    Group {
    Name "Read2"
    Mode 3
    SQL "SELECT Schakelaar6Uit, Schakelaar6Aan, Schakelaar"
    "7Uit, Schakelaar7Aan, Schakelaar8Uit, Schakelaar8Aan, Schakelaar9Uit, Schakela"
    "ar9Aan, Schakelaar10Uit, Schakelaar10Aan FROM Schakelaars WHERE ID=1"
    Period 2
    Items "Schakelaar6Uit,Schakelaar6Aan,Schakelaar7Uit,Scha"
    "kelaar7Aan,Schakelaar8Uit,Schakelaar8Aan,Schakelaar9Uit,Schakelaar9Aan,Schakel"
    "aar10Uit,Schakelaar10Aan"
    Type "ssssssssss"
    }
    Group {
    Name "Read3"
    Mode 3
    SQL "SELECT Schakelaar11Uit, Schakelaar11Aan, Schakela"
    "ar12Uit, Schakelaar12Aan, Schakelaar13Uit, Schakelaar13Aan, Schakelaar14Uit, S"
    "chakelaar14Aan, Schakelaar15Uit, Schakelaar15Aan FROM Schakelaars WHERE ID=1"
    Period 2
    Items "Schakelaar11Uit,Schakelaar11Aan,Schakelaar12Uit,S"
    "chakelaar12Aan,Schakelaar13Uit,Schakelaar13Aan,Schakelaar14Uit,Schakelaar14Aan"
    ",Schakelaar15Uit,Schakelaar15Aan"
    Type "ssssssssss"
    }
    Group {
    Name "Read4"
    Mode 3
    SQL "SELECT Schakelaar16Uit, Schakelaar16Aan, Schakela"
    "ar17Uit, Schakelaar17Aan, Schakelaar18Uit, Schakelaar18Aan, Schakelaar19Uit, S"
    "chakelaar19Aan, Schakelaar20Uit, Schakelaar20Aan FROM Schakelaars WHERE ID=1"
    Period 2
    Items "Schakelaar16Uit,Schakelaar16Aan,Schakelaar17Uit,S"
    "chakelaar17Aan,Schakelaar18Uit,Schakelaar18Aan,Schakelaar19Uit,Schakelaar19Aan"
    ",Schakelaar20Uit,Schakelaar20Aan"
    Type "ssssssssss"
    }
    Group {
    Name "Read5"
    Mode 3
    SQL "SELECT Schakelaar21Uit, Schakelaar21Aan, Schakela"
    "ar22Uit, Schakelaar22Aan, Schakelaar23Uit, Schakelaar23Aan FROM Schakelaars WH"
    "ERE ID=1"
    Period 2
    Items "Schakelaar21Uit,Schakelaar21Aan,Schakelaar22Uit,S"
    "chakelaar22Aan,Schakelaar23Uit,Schakelaar23Aan"
    Type "ssssss"
    }
    Group {
    Name "Read6"
    Mode 3
    SQL "SELECT SDimmer1Aan, SDimmer1Uit, SDimmer2Aan, SDi"
    "mmer2Uit, SDimmer3Aan, SDimmer3Uit, SDimmer4Aan, SDimmer4Uit, SDimmer5Aan, SDi"
    "mmer5Uit FROM Schakelaars WHERE ID=1"
    Period 2
    Items "SDimmer1Aan,SDimmer1Uit,SDimmer2Aan,SDimmer2Uit,S"
    "Dimmer3Aan,SDimmer3Uit,SDimmer4Aan,SDimmer4Uit,SDimmer5Aan,SDimmer5Uit"
    Type "ssssssssss"
    }
    Group {
    Name "Read7"
    Mode 3
    SQL "SELECT SDimmer6Aan, SDimmer6Uit, SDimmer7Aan, SDi"
    "mmer7Uit, SDimmer8Aan, SDimmer8Uit FROM Schakelaars WHERE ID=1"
    Period 2
    Items "SDimmer6Aan,SDimmer6Uit,SDimmer7Aan,SDimmer7Uit,S"
    "Dimmer8Aan,SDimmer8Uit"
    Type "ssssss"
    }
    Group {
    Name "Read8"
    Mode 3
    SQL "SELECT Dimmer1, Dimmer2, Dimmer3, Dimmer4, Dimmer"
    "5, Dimmer6, Dimmer7, Dimmer8, Dimmer9 FROM EntertainmentKnop WHERE Id=?10"
    Period 2
    Items "Dimmer1,Dimmer2,Dimmer3,Dimmer4,Dimmer5,Dimmer6,D"
    "immer7,Dimmer8,Dimmer9,ID"
    Type "sssssssssi"
    }
    Group {
    Name "Read9"
    Mode 3
    SQL "SELECT Dimmer10 FROM EntertainmentKnop WHERE Id=?"
    "2"
    Period 2
    Items "Dimmer10,ID"
    Type "si"
    }
    Group {
    Name "Read10"
    Mode 3
    SQL "SELECT SDimmer9Aan, SDimmer9Uit, SDimmer10Aan, SD"
    "immer10Uit, SDimmer11Aan, SDimmer11Uit, SDimmer12Aan, SDimmer12Uit, SDimmer13A"
    "an, SDimmer13Uit FROM Schakelaars WHERE ID=1"
    Period 2
    Items "SDimmer9Aan,SDimmer9Uit,SDimmer10Aan,SDimmer10Uit"
    ",SDimmer11Aan,SDimmer11Uit,SDimmer12Aan,SDimmer12Uit,SDimmer13Aan,SDimmer13Uit"
    Type "ssssssssss"
    }
    Group {
    Name "Read11"
    Mode 3
    SQL "SELECT SDimmer14Aan, SDimmer14Uit, SDimmer15Aan, "
    "SDimmer15Uit, SDimmer16Aan, SDimmer16Uit, SDimmer17Aan, SDimmer17Uit, SDimmer1"
    "8Aan, SDimmer18Uit FROM Schakelaars WHERE ID=1"
    Period 2
    Items "SDimmer14Aan,SDimmer14Uit,SDimmer15Aan,SDimmer15U"
    "it,SDimmer16Aan,SDimmer16Uit,SDimmer17Aan,SDimmer17Uit,SDimmer18Aan,SDimmer18U"
    "it"
    Type "ssssssssss"
    }
    Group {
    Name "Read12"
    Mode 3
    SQL "SELECT SDimmer19Aan, SDimmer19Uit, SDimmer20Aan, "
    "SDimmer20Uit, SDimmer21Aan, SDimmer21Uit, SDimmer22Aan, SDimmer22Uit, SDimmer2"
    "3Aan, SDimmer23Uit FROM Schakelaars WHERE ID=1"
    Period 2
    Items "SDimmer19Aan,SDimmer19Uit,SDimmer20Aan,SDimmer20U"
    "it,SDimmer21Aan,SDimmer21Uit,SDimmer22Aan,SDimmer22Uit,SDimmer23Aan,SDimmer23U"
    "it"
    Type "ssssssssss"
    }
    Group {
    Name "Read13"
    Mode 3
    SQL "SELECT ?2 FROM Schakelaars WHERE ID=1"
    Period 2
    Items "SchakelaarAanString,SchakelaarAan"
    Type "ss"
    }
    Group {
    Name "Write1"
    Mode 131
    SQL "UPDATE SchakelaarStatusNaam SET Status=?1 WHERE I"
    "d=1"
    Period 2
    Items "Schakelaar1Satus"
    Type "s"
    }
    Group {
    Name "Write2"
    Mode 131
    SQL "UPDATE SchakelaarStatusNaam SET Status=?1 WHERE I"
    "d=2"
    Period 2
    Items "Schakelaar2Satus"
    Type "s"
    }
    Group {
    Name "Write3"
    Mode 131
    SQL "UPDATE SchakelaarStatusNaam SET Status=?1 WHERE I"
    "d=3"
    Period 2
    Items "Schakelaar3Satus"
    Type "s"
    }
    Group {
    Name "Write4"
    Mode 131
    SQL "UPDATE SchakelaarStatusNaam SET Status=?1 WHERE I"
    "d=4"
    Period 2
    Items "Schakelaar4Satus"
    Type "s"
    }
    Group {
    Name "Write5"
    Mode 131
    SQL "UPDATE SchakelaarStatusNaam SET Status=?1 WHERE I"
    "d=5"
    Period 2
    Items "Schakelaar5Satus"
    Type "s"
    }
    Group {
    Name "Write6"
    Mode 131
    SQL "UPDATE SchakelaarStatusNaam SET Status=?1 WHERE I"
    "d=6"
    Period 2
    Items "Schakelaar6Satus"
    Type "s"
    }
    Group {
    Name "Write7"
    Mode 131
    SQL "UPDATE SchakelaarStatusNaam SET Status=?1 WHERE I"
    "d=7"
    Period 2
    Items "Schakelaar7Satus"
    Type "s"
    }
    Group {
    Name "Write8"
    Mode 131
    SQL "UPDATE SchakelaarStatusNaam SET Status=?1 WHERE I"
    "d=8"
    Period 2
    Items "Schakelaar8Satus"
    Type "s"
    }
    Group {
    Name "Write9"
    Mode 131
    SQL "UPDATE SchakelaarStatusNaam SET Status=?1 WHERE I"
    "d=9"
    Period 2
    Items "Schakelaar9Satus"
    Type "s"
    }
    Group {
    Name "Write10"
    Mode 131
    SQL "UPDATE SchakelaarStatusNaam SET Status=?1 WHERE I"
    "d=10"
    Period 2
    Items "Schakelaar10Satus"
    Type "s"
    }
    Group {
    Name "Write11"
    Mode 131
    SQL "UPDATE SchakelaarStatusNaam SET Status=?1 WHERE I"
    "d=11"
    Period 2
    Items "Schakelaar11Satus"
    Type "s"
    }
    Group {
    Name "Write12"
    Mode 131
    SQL "UPDATE SchakelaarStatusNaam SET Status=?1 WHERE I"
    "d=12"
    Period 2
    Items "Schakelaar12Satus"
    Type "s"
    }
    Group {
    Name "Write13"
    Mode 131
    SQL "UPDATE SchakelaarStatusNaam SET Status=?1 WHERE I"
    "d=13"
    Period 2
    Items "Schakelaar13Satus"
    Type "s"
    }
    Group {
    Name "Write14"
    Mode 131
    SQL "UPDATE SchakelaarStatusNaam SET Status=?1 WHERE I"
    "d=14"
    Period 2
    Items "Schakelaar14Satus"
    Type "s"
    }
    Group {
    Name "Write15"
    Mode 131
    SQL "UPDATE SchakelaarStatusNaam SET Status=?1 WHERE I"
    "d=15"
    Period 2
    Items "Schakelaar15Satus"
    Type "s"
    }
    Group {
    Name "Write16"
    Mode 131
    SQL "UPDATE SchakelaarStatusNaam SET Status=?1 WHERE I"
    "d=16"
    Period 2
    Items "Schakelaar16Satus"
    Type "s"
    }
    Group {
    Name "Write17"
    Mode 131
    SQL "UPDATE SchakelaarStatusNaam SET Status=?1 WHERE I"
    "d=17"
    Period 2
    Items "Schakelaar17Satus"
    Type "s"
    }
    Group {
    Name "Write18"
    Mode 131
    SQL "UPDATE SchakelaarStatusNaam SET Status=?1 WHERE I"
    "d=18"
    Period 2
    Items "Schakelaar18Satus"
    Type "s"
    }
    Group {
    Name "Write19"
    Mode 131
    SQL "UPDATE SchakelaarStatusNaam SET Status=?1 WHERE I"
    "d=19"
    Period 2
    Items "Schakelaar19Satus"
    Type "s"
    }
    }



  • Hi Martijn,

    in current REXYGEN version the total number of Groups in DB driver is limited to 32. It is a bug and it is fixed now. The fix will be present in next release version.

    Thank you for your report.

    Kind regards,
    Tomas


Log in to reply