Hi !
I´m have a SQL query (for Oracle 10g):
SELECT a.cod_resp,SubStr(p.nome_completo,1,150),SubStr(p.nome_completo,1,50),
'F','I','','N','','',p.cpf,p.end_logradouro,p.end_complemento,'',p.end_cep,p.end_cep,
c.bairro_1,c.LOCAL,uf.abrev_uf,1458,p.end_tel_numero,'',p.email,a.cod_resp,'sistema','01/07/2010','00:00',
'A','N','N','S','S','S','N','N','N','N','N','N','N','',p.end_numero,1
FROM
FINANCEIRO_PARCELA par,alunos al,tb_correspondencia_fin c,tb_aluno a,tb_parente p, cep c,uf
WHERE
par.ano=2010
AND par.parcela=8
AND al.cod_aluno=par.cod_aluno
AND c.cod_aluno=al.cod_aluno
AND c.flag_corresp = 1
AND length(p.cpf) < 12
AND a.cod_aluno = al.cod_aluno
AND p.cod_parente = a.cod_resp
AND p.end_cep = c.cep8
AND uf.cod_uf = c.cod_uf
The preview show the records perfect, but in te validator screen on press "Process Data" the error "Access Violation..." occured.
Tanks
