Database Write

martijnperdaan · 3 Nov 2020, 15:52

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

cechurat · 9 Nov 2020, 21:23

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