Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
CA VCX Builder Note
Message
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Other
Title:
CA VCX Builder Note
Miscellaneous
Thread ID:
00789252
Message ID:
00789252
Views:
49
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
Reply
Map
View

Click here to load this message in the networking platform