Delete the data from the CursorSchema property in the Property Sheet. The fastest way is to download my CA VCX Builder from http://www.mctweedle.com then click the FoxPro Tools link. Run the CABuilder PRG file and connect to your SQL database. This builder will create a VCX of CAs for ALL the tables in your database. After it is done, edit any of the table-specific CAs in the generated VCX. You can copy-and-paste the code to populate the CursorSchema property from the _ca_dmlcode method. THis will populate the property at runtime.

The problem is the Property Sheet and not the CA.

>Hi everyone,
>
>I am playing with CA finally, having recently started with VFP8. All looks great. I have been reviewing threads on CA and trying to research as well; I have a pretty good handle on what I think I need to be doing.
>
>I have a VFP Front-End; SQL Back-End. Originally done with views I am not doing a two phased change:
> 1. Creating Stored Procedures on the SQL side.
> 2. Creating CA based on SQL Stored Procedures on the front-end side.
>
>I have created a data_products.vcx, cursor adapter. I have configured this class to call a store procedure 'gen_products' using a DSN connection. All works good.
>
>I created myForm, just based on VFP form. In the dataenvironment, I added my cursor adapter (after much sweat on trying to drag drop... hehehe). Anyway, I used the CA Builder and boom!!! I can build my CA from any defined CA in my project. Way to go!!! I have the properties, and the update all find. My select command (rem: we are using the builder) is 'gen_products'. Works like a charm. The schema gets generated perfectly.
>
>However, this is a very wide SQL table. So, when I try to save all my work from the builder, I get an error message "The CursorSchema property must be no longer that 255 characters'. This table must have all of the fields (110).
>
>What do I do?
>
>TIA
>
>Ric