I do not think this fix has been mentioned for Europa, but that does not mean the Team is not considering. This has been a frequent complaint that has always existed with the Property Sheet. Until the CA, the 255 char limit was a minimal factor.

Here is what I do. I create a dummy DBC with tables with exact same structure as the SQL tables. They are also named the same as the Alias property used in the CA. I drop the table in the DE along with the CA [there is no conflicting names either]. This allows me to drag-drop fields from the table onto the form. When I am done, I drop the table from the DE.

At runtime, I have method code that fires which populates these properties with the complete schema, *Cmd, etc.

I use my CA Builder to create the VCX of CAs of all my SQL tables. Then I have a companion PRG that will create the code needed to create the dummy DBC and all its tables. For the CA Builder, see the UT downloads - it is free and has all source code and documentation in the form of comments in the CABuilder PRG file.

If you are interested in the code I use to create the dummy DB, just let me know and I will post it.

>I have to create a cursor adapter for a SqlServer table that has many fields to be updated. When I try to save the CA properties (CA Builder), this message appears.
>Does anyone have an idea, suggestion,.. to handle this?... Do I have to wait for a service pack?... Europa?...
>
>Help!.
>
>
>Thanks.