Hi Cetin

I see the error in the code shown in my initial post but the actual code does not have any errors. It was a typo when I created this thread.

I have tested this many times the problem is not an error in the string because to test I cut and paste it into the getColumn1Text method and it works. So I just kept reducing the length of the string until it worked. I will have to do further testing but I know the limit is close to 220 characters after that it fails.


Simon


>Simon,
>Actually in documents it states 255 for max len literal strings (Capacities). Here with 240 chars I don't think it's char limit but an error in expression. Probably you wrote it right for your method. What happens if you put the controlsource in grid init like this :
>
>

>This.myColumnx.Controlsource = ;
>[(ThisForm.LongDate(AMSched.Date)+" "+]+;
>[ThisForm.GetTime(AMSched.Time)+]+;
>[" "+ThisForm.dCSeek(AMSched.Sport,"AMActvty","ID","AMActvty.Desc")+" "+]+;
>[ThisForm.dCSeek(AMSched.Opponent1,"AMMaster","ID","AMMaster.Id1")+" vs "+]+;
>[ThisForm.dCSeek(AMSched.Opponent2,"AMMaster","ID","AMMaster.Id1"))]
>

>Cetin
>
>>Hi
>>
>>There is no indication in the documentation of how long a string can be used in the controlsource of a column. However, I do know that if I put a long expression (240 Characters) in the controlsource nothing will be displayed in the grid and no error message will be given. Should this be considered a bug?
>>
>>The reason this is a problem is that I have an application where the user wants to see a list of game dates and opponents in a grid column. Since the opponents are stored as unique ID number I do a lookup to find the name to be displayed. The resulting controlsource looks as follows:
>>
>>

>>Column1.ControlSource=ThisForm.LongDate(AMSched.Date)+" "+;
>>ThisForm.GetTime(AMSched.Time)+;
>>" "+ThisForm.dCSeek(AMSched.Sport","AMActvty","ID","AMActvty.Desc")+" "+;
>>ThisForm.dCSeek(AMSched.Opponent1,"AMMaster","ID","AMMaster.Id1")+" vs "+;
>>ThisForm.dCSeek(AMSched.Opponent2,"AMMaster","ID","AMMaster.Id1")
>>

>>
>>The above code will not display anything in the grid. If I replace the code with the following everything works fine:
>>
>>

>>Column1.ControlSource=ThisForm.GetColumn1Text()
>>
>>Procedure ThisForm.GetColumn1Text
>>   Return ThisForm.LongDate(AMSched.Date)+" "+;
>>      ThisForm.GetTime(AMSched.Time)+;
>>      " "+ThisForm.dCSeek(AMSched.Sport","AMActvty","ID","AMActvty.Desc")+" "+;
>>      ThisForm.dCSeek(AMSched.Opponent1,"AMMaster","ID","AMMaster.Id1")+" vs "+;
>>      ThisForm.dCSeek(AMSched.Opponent2,"AMMaster","ID","AMMaster.Id1")
>>EndProc
>>
>>

>>
>>
>>Simon