Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
CA VCX Builder Note
Message
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Titre:
CA VCX Builder Note
Divers
Thread ID:
00789252
Message ID:
00789252
Vues:
50
My latest release of the CursorAdapter VCX Builder has some additional code for hooking into a Stored Procedures builder I am currently working on. It is no where near finished so it is not in the download.

However, I have added a new feature to the builder where you have an option to specify to use Date datatypes instead of DateTime fields for SQL databases. So when the CursorSchema is created, any DateTime columns from the SQL Database will be Date data types in the cursor. It works for Native data as well.

The other changes is I no longer include the PK columns in the Updatable fields or in the INSERT/UPDATE Cmd props. You can also specify other fields to exclude from these properties. For example, I exclude Updated_By and Last_Update columns because I have stored procedures [triggers] that automatically update these columns. Of course, this usually just applies to SQL databases.
Mark McCasland
Midlothian, TX USA
Répondre
Fil
Voir

Click here to load this message in the networking platform