How to use FireTrigger option on TMsLoader

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
Christophe
Posts: 1
Joined: Mon 13 Mar 2017 16:52

How to use FireTrigger option on TMsLoader

Post by Christophe » Mon 13 Mar 2017 16:59

Hi everybody,

I try tu use the option FireTrigger on a TMsloader. (sdac version trial 7.3.16 21-Nov-16)

When i put data, i receive the following exception message :
Project xxx raised exception class EMSError with message 'Incorrect syntax near 'FIRE_TRIGGER'.

On the msdn documentation page : https://msdn.microsoft.com/en-us/library/ms188365.aspx
=> the SQL Server option for bulk import with triggers is FIRE_TRIGGERS

Anyone can help me please ?
Thank you for your help

azyk
Devart Team
Posts: 1119
Joined: Fri 11 Apr 2014 11:47
Location: Alpha Centauri A

Re: How to use FireTrigger option on TMsLoader

Post by azyk » Tue 14 Mar 2017 11:06

Thank you for the information. We fixed this bug and included it in next UniDAC build.

Please send to andreyz*devart*com RAD Studio you are using and we will send UniDAC trial with this fix.

Post Reply