Thanks Mark!!! I have already downloaded the tool and have started playing with it. This looks great.

Can I still call a stored procedure in the CABuilder to generated my schema?

Ric

>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