libgda change the following sql statement
SELECT p.pr_cod_prat, p.pr_prat_num1, p.pr_prat_num2, p.pr_prat_num3,
p.pr_dat_fin, pr.gi_num_provv2, pr.gi_dat_ini,
COALESCE (p.pr_prat_desc || '\n', '') || COALESCE (n.pr_prat_note1,
'') || COALESCE (n.pr_prat_note2, '') || COALESCE (n.pr_prat_note3,
'') || COALESCE (n.pr_prat_note4, '') AS note,
s.gi_dat_ini AS data_vendita,
r.gi_dat_sca
FROM m1_tabpr_prat p
LEFT JOIN gi_tab_stopr s ON p.pr_cod_prat = s.pr_prat_succ
LEFT JOIN m1_tabpr_note n ON p.pr_cod_prat = n.pr_cod_prat
LEFT JOIN gi_tab_provv pr ON p.pr_cod_prat = pr.pr_cod_prat
LEFT JOIN gi_tab_provril r ON pr.gi_num_provv1 = r.gi_num_provv1
AND pr.gi_num_provv2 = r.gi_num_provv2 AND pr.gi_num_provv3 = r.gi_num_provv3
WHERE p.pr_prat_num1 IN ('AMB', 'IAMB')
AND s.pr_cod_prat IS NULL
AND (pr.gi_num_provv1 = 'AUTAM' OR pr.gi_seq_provv IS NULL)
ORDER BY p.pr_prat_num3, p.pr_prat_num2
removing parenthesis on penultimate line
i'm using libgda from git branch 4.2
thanks in advance
_______________________________________________
gnome-db-list mailing list
[email protected]
https://mail.gnome.org/mailman/listinfo/gnome-db-list
