delphivcltdbgrid

Use rpad in delphi grid

Use rpad in tdbgrid not working correctly. In sql devleper work fine. Any solution for this problem.

Select rpad('Lionel Messi',20,'.') as COL_1 from dual
union all
Select rpad('Cristiano Ronaldo',20,'.') as COL_1 from dual
union all
Select rpad('Pele',20,'.') as COL_1 from dual

Example:

enter image description here

Solution

  • Looks like your Sql developer is using a fixed-pitch font, whereas your DBGrid isn't. Set your DBGrid to use a fixed-pitch font like Courier New.

    In any case, for future reference, it is not very sound practice to use SQL on your SQL Server to do output formatting by using e.g. RPad(), especially when it is applied to every single row of a result set - it pointlessly consumes server resources and network bandwidth for something that should be left to the client to do.