[ISS Support Case] SQL Query Assistance

Description

Chat kept disconnecting : Looking for assistance writing a SQL query to access three databases. I have an existing Intouch application in 2023 R2 that I need to add some information on one of the windows. The information is contained in three different tables in a database on the network. I need to run a script in Intouch that contains the query below that I can run in the MS SSMS and I get the following results: I am trying to retrieve the Batch, Heat and the Description for the three Tanks. The following query returns those values from the three tables. select distinct p.Batch, p.Heat, loc.Description Tank from [dbo].[TransactionCurrentPieceLocation] t join [dbo].[Piece] p on p.PK_Piece = t.FK_Piece join [dbo].[location] loc on loc.PK_Location = t.FK_Location where 1=1 and t.FK_Location in (10,11,12) and t.FK_PieceType = 'B' and p.FK_PieceStatus = 'A' I know I need to create the Bindlist to return to values, but how can I run the SQLExecute with the long Query like that, there are 267 characters.

• Author: Kevin Modlin
• Published: October 17th, 2025

Details: