The reason to create cursor adapter for views is because we use Visual Promatrix Enterprise as framework, and we want to preserve most of the features and functionality of our current systems and also the VPM DD (Data Dictionary). Many of our software units, specially forms are designed over views. Promatrix provides a trick to handle cursor adapters and attach the properties from the DD of a table or view defined. In this way we don't have to change to much code and we can use the builders transparently.
I have used your script and has been adapted to this purpose.
The script is extrictly customized for our needs. But the key consists in extracting all properties of each view from database (SQL..), geting the view's fields, opening the database as dbf file and searching all fields, verifying wich are keyfields and updateable (this, to construct lists in Init Method). You have to keep in mind the views can be based on serveral tables in same or different database and also they can have parameters.. There are some adjustments to do when the cursor adapter is going to be used. But most of the job is completed.
Thanks for your support,
Précédent
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