Length of TMyTable FilterSQL is insufficient

Length of TMyTable FilterSQL is insufficient

Postby 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
kenny
 
Posts: 43
Joined: Mon 15 Nov 2004 08:48
Location: Malaysia

Postby 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.
Ikar
 
Posts: 1693
Joined: Thu 28 Oct 2004 13:56

Postby 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?
:o
kenny
 
Posts: 43
Joined: Mon 15 Nov 2004 08:48
Location: Malaysia

Postby 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)
Ikar
 
Posts: 1693
Joined: Thu 28 Oct 2004 13:56


Return to MySQL Data Access Components