Ability to stack Insert Column List and Value List with Columns Per Line
When formatting an Insert Statment, make the Column List and Value List Stacked with the user defining how many Columns Per Line is included before going to the next line with proper tabs and alignment.
Exampe of an insert statment being stacked with 4 colums per line in and select stacked:
INSERT INTO xTicketAudit
(LineType,OrderNbr,LineNbr,InvtID,
ImportQty,POQty,ImportUnits,Units,
SpecPrice,POPrice,LineIn,User1,
User2,User3,User4,User5,
User6,User7,User8)
SELECT 'D',xdp.OrderNbr,xdp.LineNbr,xdp.InvtID,
xdp.Qty,0,xdp.Units,'',
'','','','',
'',xdp.User3,xdp.User3,'',
'',xdp.User7,xdp.User8
FROM XTicketDetail xdp