Skip to Content
0
R S
Aug 20, 2023 at 04:48 PM

Incorrect Syntax near Tabela

35 Views

Hi

In below code i am getting above error

DECLARE @TipoObjeto VARCHAR(10)

DECLARE @DocEntry INT

DECLARE @Comando VARCHAR(MAX)

DECLARE @Tabela VARCHAR(3)

SET @TipoObjeto = '{Pm-?ObjectId@}'

IF @TipoObjeto = '112' -- Draft

BEGIN

SET @Tabela = 'DRF' -- Draft/Rascunhos - ODRF

END

ELSE

BEGIN

SET @Tabela = 'INV' -- Pedido de compra - O[TABELA]

END

SET @COMANDO =''

SELECT

CONVERT(VARCHAR,O[TABELA].DOCDATE,105) DOCDATE,

CONVERT(VARCHAR,O[TABELA].DocDueDate,105) DocDueDate,O[TABELA].ObjType

FROM

O[TABELA] INNER JOIN [TABELA]1 ON O[TABELA].DOCENTRY=[TABELA]1.DOCENTRY

SELECT @COMANDO = REPLACE(@COMANDO, '[TABELA]', @Tabela)

SELECT @COMANDO = REPLACE(@COMANDO, '@DocEntry', @DocEntry)

EXEC(@COMANDO)

Thanks