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