on 12-08-2015 1:20 PM
Bom dia,
Estou tentando rodar a seguinte consulta no SAP:
DECLARE @DATA1 AS Date, @DATA2 AS Date
SET @DATA1 = '[%0]'
SET @DATA2 = '[%1]'
--## Purchasing ##
SELECT 'NF Entrada' as Tipo,DocEntry,Serial,DocDate,CardName,CANCELED,DocStatus FROM OPCH T0 WHERE DocDate between @data1 AND @DATA2 AND SeqCode = '27' union all
SELECT 'Devolução NF Entrada' as Tipo,DocEntry,Serial,DocDate,CardName,CANCELED,DocStatus FROM ORPC T0 WHERE DocDate between @data1 AND @DATA2 AND SeqCode = '27' union all
SELECT 'Devolução de mercadoria' as Tipo,DocEntry,Serial,DocDate,CardName,CANCELED,DocStatus FROM ORPD T0 WHERE DocDate between @data1 AND @DATA2 AND SeqCode = '27' union all
SELECT 'Recebimento de mercadoria' as tipo,DocEntry,Serial,DocDate,CardName,CANCELED,DocStatus FROM OPDN T0 WHERE DocDate between @data1 AND @DATA2 AND SeqCode = '27' union all
--## Sales ##
SELECT 'NFSaida' as Tipo,DocEntry,Serial,DocDate,CardName,CANCELED,DocStatus FROM OINV T0 WHERE DocDate between @data1 AND @DATA2 AND SeqCode = '27' union all
SELECT 'Entrega' as Tipo,DocEntry,Serial,DocDate,CardName,CANCELED,DocStatus FROM ODLN T0 WHERE DocDate between @data1 AND @DATA2 AND SeqCode = '27' union all
SELECT 'Devolução' as Tipo,DocEntry,Serial,DocDate,CardName,CANCELED,DocStatus FROM ORDN T0 WHERE DocDate between @data1 AND @DATA2 AND SeqCode = '27' union all
SELECT 'Devolução NF Saida' as Tipo,DocEntry,Serial,DocDate,CardName,CANCELED,DocStatus FROM ORIN T0 WHERE DocDate between @data1 AND @DATA2 AND SeqCode = '27'
No SQL Server essa consulta é executada com sucesso, já no SAP, está surgindo o seguinte erro:
1). [Microsoft][SQL Server Native Client 10.0]Invalid cursor state '' (SWEI)
Se eu mudar o DECLARE ele executa:
SET @DATA1 = '[%0]'
SET @DATA2 = '[%1]'
Vocês já tiveram esse problema?
Encontrei vários casos aqui, mas nenhum com uma solução que me auxilie.
Será que devo utilizar algum tipo de conversão ao passar as variáveis?
Att,
Maicon Macedo
SAP B1 9.0 PL10 HF 2
Amigos do SCN,
Eu descobri o problema: setar o valor na variável.
Estava usando assim:
SET @DATA1 = '[%0]'
SET @DATA2 = '[%1]'
Quando mudei para esse:
SET @DATA1 = /* T0.DocDate */ '[%0]'
SET @DATA2 = /* T0.DocDate */ '[%1]'
Ela funcionou
Att,
Maicon Macedo
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Olá Maicon,
Como você preenche essas datas?
Att,
Diego
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
104 | |
12 | |
11 | |
6 | |
6 | |
4 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.