Hello all,
Many years ago we had an ERP program made then several years ago the coders and project manager has been died and the company has gone down.So I am fixing the problems by making some changes in sql database or making small apps using python or smth to make sql querries automatically.But now I had a problem that I need to get in the Sql querries in the program.Shortly my problem is,when I open orders page it may take even 1 minute because in Sql querry tries to list all datas in the table before filtering.The inital querry when I open the order page is "SELECT * FROM ORDERS" and I need to add something like list only top 100 item.So I have many .bpl files which are lib files of program as I understand.So I couldnt look the .bpl files.So is it possible to make changes by bpl files?If yes how, what program?