Devart Forums

Hi,
I face the problem that the length of filterSQL in TMytable is insufficient for me to doing table filtering.

If the filterSQL string is longer than 255 then will occur error of SQL statement. What is the way to solve my problem whereby extend the length of FilterSQL or may be as TMemo?

Thanks

We couldn't reproduce the problem.
Please send us (sdac*crlab*com) complete small sample to demonstrate it and include script to create server objects.

Hi,
I encountered where is the problem makes the the TmyTable.filtersql error. This cause by I'd use the Group_Concat function and the records to concat were too long.

I did not know the limit length of the Group_Concat function for mysql...
Is that consider a bug?

You should ask this question at the forums related to MySQL language.

PS: Pay attention to group_concat_max_len (see MySQL Reference for details)