I have an application that queries a couple of different SQL tables and returns the results to an Ignition Table.
Everything returns 2 decimal places by default. I know that you can go to table properties and set each column for 3 decimal places, but the problem is that every time you run the query you may get back different column. How to I change it so that all columns come back 3 decimal places no matter what the columns are??? Yes the data in SQL is 3 decimal places.