Information générale
Titre:
Creating CA - Too Much Schema
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
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement