Devart Forums

Posted: **Thu 26 Apr 2018 11:44**

Hi,

when I create the following:

dbCon := TMSConnection.Create(NIL);
dbCon.DataBase := sDIC;
dbCon.LoginPrompt := FALSE;
dbCon.Password := 'abc2018#';
dbCon.Username := 'DDM-User';
dbCon.Server := msSQL_SRV;
dbCon.Name := 'DBmR' + IntToStr(DBmRNum);

and create a table also:

Code: Select all

dbPerso := TMSTable.Create(NIL);
Connection := dbCon;
dbPerso.Filtered := FALSE;
dbPerso.Name := 'PERSO' + IntToStr(DBmRNum);
dbPerso.TableName := 'PERSO';
dbPerso.KeyFields := 'PERS_ID';

and setting no other parameter, we have the problem that if i want to update the table with some values the system is waiting for something. Also any changes from SQL Server Mgm Studio are running endless, until i close the connection above. It looks like that the connection is blocking the whole table, but why ???

Using Delphi XE7 and the latest SDAC and MS SQL Server 2017

Thanks!

Posted: **Fri 27 Apr 2018 11:55**

We cannot reproduce the issue. Please specify whether it is reproduced on our SDACDemo demo project. It is located in the folder "Demos\SDACDemo\" relative to the path where the SDAC demo projects were installed.

If on our demo the issue is not reproduced, please compose a complete test project to demonstrate it and send it to us. In the project, also include the SQL script to create a test database, tables and fill them with test data.

Devart Forums

table locking - but why?

table locking - but why?

Re: table locking - but why?