Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Downloads
Add
Search: 
Search

CursorAdapter VCX Builder for VFP 9
Mark McCasland
This class is designed to connect to a DBC, Oracle or SQL Server, retrieve all tables in that database, then create a CursorAdapter subclass for each table. This class generates the code that is needed at runtime to populate the properties in each CA in order for VFP to auto-generate the Insert, Update, Delete SQL. You also have the option of using your own SQL code provided in one of the methods of each CA subclass just by setting the value of the lAutoGenerate property.
Created on
21 years ago
Downloads
4949
File type
Freeware
Rating
5.00/5.00
General information
URL:
CABuilder9.zip
Rating:
5.00/5.00 (4 rates) Rate this item
Description
This class is designed to connect to a DBC, Oracle or SQL Server, retrieve all tables in that database, and create a CursorAdapter subclass for each table. This class generates the code that is needed at runtime to populate the properties in each CA in order for VFP to auto-generate the Insert, Update, Delete SQL. You also have the option of using your own SQL code provided in one of the methods of each CA subclass just by setting the value of the lAutoGenerate property. The first step done by the builder is the creation of a Class Library [VCX] with a CursorAdapter baseclass. Then, all the Table-specific CursorAdapters are created as sub-classes of the CA baseclass. This allows you to set "common" properties at the baseclass level like a DataSource [connection handle] for example. Please keep in mind this is a design time UTILITY and is not intended to be "pretty" with respect to the UI. However, it does its intended job quite nicely.
Created by
Mark McCasland

Comments
Very Good, I used version 2.03, it helps a lot. Is it works for local views???... Alexander Cubillos, December 16, 2003

No. To create CAs to replace views in a DB would be much more work. Mark McCasland, December 24, 2003

Mark, do you have a step by step guide to generate CursorAdapters with CABuilder9...this my first time what i am using the tool. thanks a lot William Chavez, November 11, 2009

Add a comment
More downloads created from this member
DynaZip Class
Mark McCasland
Wrapper class for controlling all DynaZip operations. This class uses extensive use of _Access and _Assign methods, so VFP 6 is required. The class is heavily commented and is based on Chapter 5 of the DynaZip manual. Never has integrating DynaZip into your VFP apps been easier. This class works wit...
Created on
23 years ago
Downloads
2449
File type
Freeware
Rating
5.00/5.00
ODBC DSN Class
Mark McCasland
Modified to now be a class, generously commented, that provides a wrapper for creating, modifying and removing User DSN programmatically using all VFP code. Two functions have been added for creating a connection using a DSN or a string. This is a PRG based class and is free [public domain].
Created on
23 years ago
Downloads
4819
File type
Freeware