Is there any limitation how many Synonyms you can have for one Style?


>>

>>create cursor stylelist (style c(10),synonyms m)
>>select styles
>>scan
>>  select synonyms
>>  lcSynonym = ""
>>  scan while fk = styles.pk
>>   lcSynonyms = m.lcSynonyms + iif(empty(m.lcSynonyms),"",",") + synonyms.synonym
>>  endscan
>>  if _Tally > 0
>>    lcSynonyms = "("+m.lcSynonyms+")"
>>  endif
>>  select styles
>>  insert into stylelist values (styles.style,m.lcSynonyms)
>>endscan
>>select stylelist
>>browse
>>

>
>I forgot to mention that the result as to be also with the OleDb provider. Thus, one big SQL to achieve all that.