You can use a subfield to split the string up again within a loop and then rebuild it.
1. set up a rowno() count in the field's table
2. load this table in during a loop with a where clause testing for this rowno() field being less then 100, 200, 300 ad infinitum
3. use you concatenate() function to build up the comma seperated string
The "resulting string" I need to run sql statement "script query at another db with extention control..." , which "DB settings" to not accept more than 100 values in a string.
I have to break/split the original string (normal contat), and formatting it precisely so
(value1, value2, value3, value100);(valeu101,value102,value200); ...
I can not possible modify the load script...
My problem is being able to break a string created by a CONCAT expr too extensive.
I wish I could create a text string where every 1000 values submit the following digit value " );( "...
NORMAL CONCAT: (1,2,3,4,5,6,7,... 211000) no good! many long...
Here is the solution ...
thank you anyway
'T' as OT,
'OBJECT' & RowNo() as OBJECTID,
RowNo() as OBJECTIDPOS
$(vClass)=Mid(replace(Class(Aggr(Rank(Sum(OBJECTIDPOS)*-1),OBJECTID),vSoglia),'<= x',''), Index(replace(Class(Aggr(Rank(Sum(OBJECTIDPOS)*-1),OBJECTID),vSoglia),'<= x',''),'< ')+2,10)
=concat(OBJECTID & if(Aggr(Rank(Sum(OBJECTIDPOS)*-1),OBJECTID)=$(vClass)-1 or Aggr(Rank(Sum(OBJECTIDPOS)*-1),OBJECTID)=Count(TOTAL DISTINCT OBJECTID),');(')