>Hi, could someone please remind me how to overcome the limitation of 255 characters in the RowSource property of a grid when using an SQL statement.
>
>Thanks in advance
>Petras
To overcome the limitation of 255 char you can set the property by code in the Init() or Load() event. In code you can overcome any 255 chat limitation creating a string as sum of string
LOCAL lcStr1, lcStr2, lcSTR3
lcStr1 = < fist part of your select >
lcStr2 = < second part of your select >
lcStr3 = < third part of your select >
yourGrid.RowSource = lcStr1 + lcStr2 + lcStr3
The limitation is a problem of the Form Designer I think not of foxpro language
bye