AND and beautifier

fidelfs

Member³
I tried different combinations but this is what I got from beautifier:

SELECT a.Invoice_Id
INTO v_Invoice_Id
FROM Ap_Invoices a,
Po_Vendors b
WHERE a.Invoice_Num = v_Invoice_Number AND a.Vendor_Id = b.Vendor_Id AND b.Segment1 = TRIM(i.Gps_Vendor_Number);

I would like to see the AND and OR per line (one item per line) and aligned by the SELECT.
 
This is currently not possible, but we have had this request before and will add an option for this.

------------------
Marco Kalter
Allround Automations
 
Yeap, I've also found the AND a bit inconsistent, with sometimes two on a single line
- even when I've set to "One item per line"
 
Back
Top