Incorrect syntax near 'with'

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
Marcin Ł.
Posts: 1
Joined: Wed 09 Nov 2016 17:16

Incorrect syntax near 'with'

Post by Marcin Ł. » Wed 09 Nov 2016 17:45

Hello

Recently I updated SQL Server Data Access Components to version 7.3.
After the update scripts executed by TMSScript unfortunately stopped working.

Example:

Code: Select all

CREATE TRIGGER [dbo].[TrInsSelfTest] ON [dbo].[SelfTest]
WITH EXECUTE AS CALLER
FOR INSERT
AS
DECLARE
     @ID			int,
     @Position	int,
     @ParentID	int
BEGIN
	SET NOCOUNT ON

	-- .......................

END
When I try to execute then I get the message:
Incorrect syntax near 'with'.
Please let me know what I need to do to make it work again.

Regards
Marcin

ViktorV
Devart Team
Posts: 2299
Joined: Wed 30 Jul 2014 07:16

Re: Incorrect syntax near 'with'

Post by ViktorV » Thu 10 Nov 2016 11:25

Thank you for the information. We have reproduced and fixed the issue. This fix will be included in the next build of SDAC.

Post Reply