I’ve been tasked with patching a Delphi software to work with a new database(mssql) structure.
In the previous database(mssql), all the columns being read were in the same table.
In the new version the file_name and class_name are in a different table from the quantity values.
In essence, we need to read from two tables, when previously, we were reading by only one.
I'm looking for someone who fix the issue by any means.
The entire Delphi code is available, and access to the MSSQL database is available by Remote Desktop Connection.