DB Connnector - Graphical Mode issue

Submitted by rafael.vianna on Mon, 02/10/2014 - 13:27
1
0
-1

Hi community,

I'm having a 'bad time' with an Oracle connector. Seems like I can't get the option for graphical mode with my select. I just can't figure it out. The following select just give me the option for 'script mode', setting my values to a resultset (which I don't want to use).

SELECT 'I', '100', PESSOA.CD_CLIFOR, PESSOA.DS_NOME FANTASIA,
PESSOA.DS_ENDERE ENDERECO,
PESSOA.DS_BAIRRO BAIRRO,
CIDADE.DS_CIDADE CIDADE,
ESTADO.CH_UF UF,
PAIS.DS_PAIS PAIS,
PESSOA.CH_CEP CEP,
PESSOA.CH_TELEF1 TELEFONE,
PESSOA.CH_TELFAX FAX,
PESSOA.DS_EMAIL EMAIL,
PESSOA.CH_CNPJ CNPJ,
PESSOA.DS_INSEST IE,
PESSOA.DS_OBSERV,
PESSOA.CH_PESSOA F_J,
PESSOA.DS_CLIFOR RAZAO,
CASE WHEN ESTADO.CH_UF = 'EX' THEN
'1' ELSE '0' END AS MERCADO
FROM CONSYSTEC5.SICLIFOR PESSOA,
CONSYSTEC5.SICIDADE CIDADE,
CONSYSTEC5.SIESTADO ESTADO,
CONSYSTEC5.SIPAIS PAIS
WHERE PESSOA.CD_CIDADE = CIDADE.CD_CIDADE
AND ESTADO.CD_ESTADO = CIDADE.CD_ESTADO
AND CIDADE.CD_PAIS = PAIS.CD_PAIS
ORDER BY PESSOA.CD_CLIFOR

What am I missing?

Thanks in advance.

1 answer

Submitted by rafael.vianna on Mon, 02/10/2014 - 13:37
1
+2
-1
This one is the BEST answer!

Ok, I've answered it myself. The problem is that when I paste my code with 'Tab' into the Bonita, it doesn't understand as a code. I had to take off all the 'Tabs' in my code and make it in a single (long long) line.

That solved my problem.

Notifications