I'm not sure what is causing it, but sql like this.
SELECT TOP 10 *
FROM dbname.vw.Invoices
WHERE [Open Invoice] = 'Y'
ORDER BY CAST([Invoice Amount] AS decimal(15,2)) DESC
Is throwing an error.
"Expected ], found Invoice, Line: 3, Col: 13"
My suspicion is that this library doesn't support spaces even though they are inside [ ]
I'm not sure what is causing it, but sql like this.
SELECT TOP 10 *
FROM dbname.vw.Invoices
WHERE [Open Invoice] = 'Y'
ORDER BY CAST([Invoice Amount] AS decimal(15,2)) DESC
Is throwing an error.
"Expected ], found Invoice, Line: 3, Col: 13"
My suspicion is that this library doesn't support spaces even though they are inside
[]