Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Cursor Adapter - To->Mark McCasland
Message
De
22/12/2003 15:19:16
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00859557
Message ID:
00861397
Vues:
21
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
Fil
Voir

Click here to load this message in the networking platform