Index: TAOR rework/TAOR rework/databases/Ardis/ArdisMapper.vb =================================================================== diff -u -r2095 -r2172 --- TAOR rework/TAOR rework/databases/Ardis/ArdisMapper.vb (.../ArdisMapper.vb) (revision 2095) +++ TAOR rework/TAOR rework/databases/Ardis/ArdisMapper.vb (.../ArdisMapper.vb) (revision 2172) @@ -358,7 +358,7 @@ LogBestandTextMapper.WriteToFile("Ardis", $"Opvragen van barcodes originele plankjes met info Partgroup, PartExt02, PartL: '{partgroup}' '{partExt02}' '{partL}'") 'Query opbouwen. - Dim query = $"select top 4 PartCalc from [VH_Ardis_TST].[dbo].[Parts] where partgroup='{partgroup}' and partext02='{partExt02}' and partl='{partL}' and partext01 like '%ZIJ-%' and (partext09 ='{Configs.sifonLadeGeefPartExt09GegenereerdeZijkantLinks()}' or partext09='{Configs.sifonLadeGeefPartExt09GegenereerdeZijkantRechts()}') order by partid desc" + Dim query = $"select top 4 PartCalc from [VH_Ardis_TST].[dbo].[Parts] where partgroup='{partgroup}' and partext02='{partExt02}' and partl='{partL}' and partext01 like '%ZIJ-%' and (partext09 ='{Configs.sifonLadeGeefPartExt09GegenereerdeZijkantLinks()}' or partext09='{Configs.sifonLadeGeefPartExt09GegenereerdeZijkantRechts()}') and PartRemark3='NoRework' order by partid desc" 'Query uitvoeren en resultaat retourneren. Dim result = ExecuteIntoListOfString(query) LogBestandTextMapper.WriteToFile("Ardis", $"Opvragen van barcodes originele plankjes met info Partgroup, PartExt02, PartL: '{partgroup}' '{partExt02}' '{partL}'", True)