Navigation

    REXYGEN Community Forum

    • Login
    • Search
    • Categories
    • Recent
    • Tags
    • Popular

    Database Write

    REXYGEN Studio
    2
    2
    105
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • M
      martijnperdaan last edited by

      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"
      }
      }

      1 Reply Last reply Reply Quote 0
      • cechurat
        cechurat last edited by

        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

        1 Reply Last reply Reply Quote 0
        • First post
          Last post

        This is a community forum for REXYGEN users and fans. Detailed information can be found at REXYGEN homepage.

        There is also an outdated REXYGEN community forum.

        Powered by NodeBB.