diegojmap Posted December 12, 2019 Share Posted December 12, 2019 Good night. When a unidbgrid does not have columns defined I use a variable SQL. What defines the width of the column? I have several cases where the field is truncated. Quote Link to comment Share on other sites More sharing options...
diegojmap Posted December 13, 2019 Author Share Posted December 13, 2019 ? Quote Link to comment Share on other sites More sharing options...
Sherzod Posted December 13, 2019 Share Posted December 13, 2019 On 12/12/2019 at 6:02 AM, diegojmap said: Good night. When a unidbgrid does not have columns defined I use a variable SQL. What defines the width of the column? I have several cases where the field is truncated. Hello, Sorry for the late reply. Which DB are you using? Quote Link to comment Share on other sites More sharing options...
diegojmap Posted December 13, 2019 Author Share Posted December 13, 2019 I use firebird with dbexpress, it happens on my inheritance screens. I would like to understand what Unigui uses to set the column width when it is not fixed. Quote Link to comment Share on other sites More sharing options...
Sherzod Posted December 13, 2019 Share Posted December 13, 2019 8 minutes ago, diegojmap said: I would like to understand what Unigui uses to set the column width when it is not fixed. The column width or field truncated!? Quote Link to comment Share on other sites More sharing options...
diegojmap Posted December 13, 2019 Author Share Posted December 13, 2019 I'm interested in not truncating the name of the title. Quote Link to comment Share on other sites More sharing options...
diegojmap Posted December 13, 2019 Author Share Posted December 13, 2019 Even if I have to configure manually, I tried to increase the nickname inside SQL to increase, it didn't work. Quote Link to comment Share on other sites More sharing options...
belo Posted December 13, 2019 Share Posted December 13, 2019 Disable UniDBGrid ForceFit and set the size of fields at run time for your Query, example: In OnCreate or OnShow.. Query.FieldByName('DESCRICAO').DisplayWidth := 10; Best Regards, Eduardo Belo Quote Link to comment Share on other sites More sharing options...
diegojmap Posted December 14, 2019 Author Share Posted December 14, 2019 Belo. Good idea. It was an output, I managed to create each column and determining the size. dbg1.Columns.clear; dbg1.Columns.add; dbg1.Columns [0] .FieldName: = 'INSCRICAO'; dbg1.Columns [0] .Alignment: = taLeftJustify; dbg1.Columns [0] .Width: = 200; dbg1.Columns [0] .Title.Caption: = 'Inscrição'; dbg1.Columns [0] .Title.Alignment: = taLeftJustify; dbg1.Columns.add; dbg1.Columns [1] .FieldName: = 'ENDERECO'; dbg1.Columns [1] .Alignment: = taLeftJustify; dbg1.Columns [1] .Width: = 200; dbg1.Columns [1] .Title.Caption: = 'Endereço'; dbg1.Columns [1] .Title.Alignment: = taRightJustify; Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.