We have an n-Tier production application, developed with Delphi 7 along with SDAC latest version.
We try to upgrade the application server tier under Delphi XE5 with the corresponding DACs on Windows 7 64 bit OS.
We encounter 2 problems:
1. Regardless build platform, when trying to update a multiple master-detail structure.
Adding a new record in a detail table - the generated insert query is ok - the detail table is updated;
after that we send a DataRequest to the master table to retrieve the updated structure (master and details); the query which has to get the inserted/updated records from details, doesn't appear immediately, but after 40", and then after each minute; therefor, on the client side it looks like there isn't any modification. The identical source code in Delphi 7, works on production.
Here are the queries from SQL Server Profiler:
Code: Select all
--insert the record into DOCVLN1 table (detail)
BEGIN TRANSACTION
[...]
exec sp_executesql N'insert into dbo.DOCVLN1
(LINEORD, DOCID, ITEMID, CCOSTID, DVLN1QTY, DVLN1PUNIT, PRCTVA, DVLN1PUNITDEV, VALTVADEV, UMID, UMFACTOR, XLNID, PVA)
values
(@P1, @P2, @P3, @P4, @P5, @P6, @P7, @P8, @P9, @P10, @P11, @P12, @P13)',N'@P1 int,@P2 int,@P3 int,@P4 int,@P5 float,@P6 float,@P7 float,@P8 float,@P9 float,@P10 int,@P11 float,@P12 int,@P13 float',2,11652,567,NULL,1,5,24,5,1.2,1,1,0,0
[...]
COMMIT TRANSACTION
--DataRequest from DOCHD (master table)
SELECT * FROM dbo.DOCHD
WHERE DOCID=11652
RPC:Completed exec sp_executesql N'SELECT * FROM dbo.DOCVHD
WHERE DOCID = @P1 ',N'@P1 int',11652 52 2014-10-19 18:14:44.857 0 SferaAppServer.exe
RPC:Completed exec sp_executesql N'SELECT * FROM dbo.DOCVLN1
WHERE DOCID = @P1
ORDER BY DOCID,LINEORD',N'@P1 int',11652 52 2014-10-19 18:14:44.870 0 SferaAppServer.exe
RPC:Completed exec sp_executesql N'SELECT * FROM dbo.DOCVHD
WHERE DOCID = @P1 ',N'@P1 int',11652 52 2014-10-19 18:15:44.890 0 SferaAppServer.exe
RPC:Completed exec sp_executesql N'SELECT * FROM dbo.DOCVLN1
WHERE DOCID = @P1
ORDER BY DOCID,LINEORD',N'@P1 int',11652 52 2014-10-19 18:15:44.893 0 SferaAppServer.exe
RPC:Completed exec sp_executesql N'SELECT * FROM dbo.DOCVHD
WHERE DOCID = @P1 ',N'@P1 int',11652 52 2014-10-19 18:16:44.890 0 SferaAppServer.exe
RPC:Completed exec sp_executesql N'SELECT * FROM dbo.DOCVLN1
WHERE DOCID = @P1
ORDER BY DOCID,LINEORD',N'@P1 int',11652 52 2014-10-19 18:16:44.903 0 SferaAppServer.exe
RPC:Completed exec sp_executesql N'SELECT * FROM dbo.DOCVHD
WHERE DOCID = @P1 ',N'@P1 int',11652 52 2014-10-19 18:17:44.903 0 SferaAppServer.exe
RPC:Completed exec sp_executesql N'SELECT * FROM dbo.DOCVLN1
WHERE DOCID = @P1
ORDER BY DOCID,LINEORD',N'@P1 int',11652 52 2014-10-19 18:17:44.917 0 SferaAppServer.exeIt appears that problem is related with one similar on ODAC section.
2. Trying to deploy a 64 bit build test platform to a customer on a windows 2003 x64 bit server, we've got an "Error loading MIDAS.dll", although, we replace the old midas.dll with the 64 bit counterpart; uninstalling the old one, installing the new one no effect.
The 32 bit build has no such error.
Any help would be a big step forward.
Thank you,
Radu B.