Jump to content

How to manipulate max. celltext length in an UniDBGrid

Recommended Posts

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?


Perhaps this is due to your SQL query.

Can you provide your SQL query?

Link to post
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. 


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 post
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 post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...