Inscrit le: 28 Sep 2017
|Posté le: Mar 14 Nov - 09:24 (2017) Sujet du message: Firedac Locks MS SQL Server 2012 and 2014
After stepping through an indexed FireDac Table when a subsequent query is run that alters any records that have been stepped through this Locks the Table on the SQL Server.
The problem does not occur if the table is not indexed or of a MSAcc connection is used instead of an MSSQL connection. Affects both 32 and 64 bit.
Can anyone throw any light on this problem?
I didn't find the right solution from the Internet.
explainer video company