Length of TMyTable FilterSQL is insufficient

kenny · Post by **kenny** » Wed 16 Mar 2005 08:08

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

Ikar · Post by **Ikar** » Wed 16 Mar 2005 08:16

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.

kenny · Post by **kenny** » Fri 18 Mar 2005 09:19

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?

Ikar · Post by **Ikar** » Fri 18 Mar 2005 15:09

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)