Jump to content

How to manipulate max. celltext length in an UniDBGrid


Kattes

Recommended Posts

Hi,

When I use a UniDBGrid and feed it with data from an external MySQL server, cell text gets limited i.e. truncated after 30 characters (as shown in the figure below). Is there any property which controls this behavior?


truncatedCellText.jpg.04af525483d065d717a0fa6c886196eb.jpg

Link to comment
Share on other sites

On 1/16/2019 at 11:07 PM, Kattes said:

When I use a UniDBGrid and feed it with data from an external MySQL server, cell text gets limited i.e. truncated after 30 characters (as shown in the figure below). Is there any property which controls this behavior?

Hi,

Perhaps this is due to your SQL query.

Can you provide your SQL query?

Link to comment
Share on other sites

The SQL statement I used in the first case was quite simple: select * from schools

I made a lot of further tests and finally found out that the reason for the behavior must come from uniDBGrid. For whatever reason the Grid truncates text, which is in the second column of the grid (and longer than 32 characters). After changing the order of columns in the grid by manipulating the sql statement to: select Ort, Email, Name,  Id_School from schools the email column now was affected by this effect. School names, which were truncated before are complete now - only by shifting them to a different column. 

truncatedCellText2.jpg.e6256dac0006977a49fbe651ab473198.jpg

I am pretty sure that this is not somehow related to SQL DB and that this effect can be reproduced with any kind of DB.

Are there some settings in uniDBGrid to change / stop this behavior?

Link to comment
Share on other sites

I am currently running a bit out of time with my project and unfortunately all DB examples, which get shipped with uniGui do not work under XE5 and crash my IDE. At the moment I just changed the columns order as an interim solution. But please keep an eye on this bug for any of the next planned updates.

Link to comment
Share on other sites

Please sign in to comment

You will be able to leave a comment after signing in



Sign In Now
×
×
  • Create New...