Page 1 of 1

SQLServer: Incorrect syntax near 'integer in 6.4.15

Posted: Thu 10 Nov 2016 20:13
by FredS
This fails in 6.4.15 and works in 6.4.14 against SQLServer.

UniScript.SQL.Clear;
UniScript.SQL.Add('SET ANSI_NULLS ON');
UniScript.SQL.Add('GO');
UniScript.SQL.Add('SET QUOTED_IDENTIFIER ON');
UniScript.SQL.Add('GO');
UniScript.SQL.Add('ALTER PROCEDURE [dbo].[WhatNot]');
UniScript.SQL.Add('AS');
UniScript.SQL.Add('BEGIN');
UniScript.SQL.Add(' DECLARE @OfflineCount integer;');
UniScript.SQL.Add('END');
UniScript.Execute;

Re: SQLServer: Incorrect syntax near 'integer in 6.4.15

Posted: Fri 11 Nov 2016 09:15
by ViktorV
Thank you for the information. We have reproduced and fixed the issue. This fix will be included in the next build of UniDAC.