The 255 character limit is an issue with all character properties in the Property Sheet. It just has not been as big of a problem until CursorAdapters came out.

The easiest way is to get my free [with source code] CA VCX Builder. This builder will create a CA subclass for all your tables. You can then drop the CA subclass in the DE of a form. If the CursorSchema is longer than 254 characters, it will populate that property with as many fields in the table as possible without exceeding that limit. At runtime, this property will be populated with the complete schema using code.

After you download the builder, unzip it and MODI COMM CABuilder and read the comments at the top of the PRG file. To build the VCX all you have to do is issue DO CABUILDER from the Command Window. You will get a builder form to specify how to build the class lib.

There is also a couple of sample files you can download. Just click the FoxTools link at:

http://www.mctweedle.com


>Hi all
>
>i'm facing a problem with cursor adapter that, when i build the Adapter and selects the table and built a Vfp cursor schema but the table containts about 40 columns due to this the Vfp cursor schema property's length is long and when is save the adapter then it shows that the CursorSchema property of Cursoradapter must not be longer than 250 characters.
>
>wut is possible solution to alter this problem