|
|
Home » Visual Basic » Article
Data Shaping and And Data Object Information Using ADODB and ADOX
|
| Article by: | Brian Gillham (8/24/2002) |
|
| Sponsored by: |
Neil Matthews Hypnotherapy, Wilmslow |
| Summary: | his class allows you to obtain information about a database using ADOX, Microsoft's new extensions to ADO that allow you to set and read information about database objects such as tables, fields, and indexes. |
|
| Viewed: 5861 times |
Rating (10 votes): |
|
1.4 out of 5 |
|
|
|
Download Now 19Kb
This class allows you to obtain information about a database using ADOX, Microsoft's new extensions to ADO that allow you to set and read information about database objects such as tables, fields, and indexes. It also includes a function that returns a shaped recordset (a recordset that includes a child recordset as a column) without you having to write the complex SQL syntax for Shaping.
According to Microsoft's documentation, the Access JetOLEDB provider is the only one that fully supports ADOX. However, most of the the functions in the class have been tested with SQL Server 7.0, where they work fine. They should work with other providers (current and future) to the degree that they support the ADOX functionality included in this class.
Reviewing and using this class is an excellent way to familiarize yourself with Shaping and ADOX, which will undoubtedly soon become widely adopted technologies.
Download Now 19Kb
|
|
View highlighted Comments
 User Comments on 'Data Shaping and And Data Object Information Using ADODB and ADOX'
|
|
|
|
To post comments you need to become a member. If you are already a member, please log in .
 
| RELATED ARTICLES |
Generate License Keys (such as CD keys on Microsoft software)
by Brian Gillham
This class allows you to generate license keys, such as the CD keys on the case of most Microsoft software |
 |
Visual Basic Read and Modify the Registry
by Kenneth Ives
Perform the four basic functions to the Windows registry. Add, change, delete, and query. Allows you to to read registry values, and modify both keys and values.
|
|
Communicating with the Database (Using ADO)
by Chaudhary Pradeep K. Roy
Using ADO to get connected with the database. |
|
Generate an Array of Unique Random Numbers
by Brian Gillham
This function will generate an ARRAY of TRULY random numbers. |
|
Beginning Resource Files in Visual Basic
by Kenneth Ives
Have you ever wanted to use graphics, such as icons, bitmaps, cursors, and AVI files? How about sound or even message box text? This can be an enormous amount of overhead. These are all examples of more files to keep track of when you distribute an application, DLL, or OCX. Lets find out how resource files can help.... |
|
Visual Basic Compact/Repair Access Database Utility
by Kenneth Ives
This utility will compact and repair the access database you select. It is actually more convenient to use this utility than do the same task with Access, because you don't have to save the database with a different name and then delete the old database when you are done: here, a temporary copy of the database is automatically created and deleted. |
|
Creating a watermark in Excel with VBA
by Kenneth Ives
Adding a watermark to an Excel spreadsheet using VBA. |
|
Generate your own Random Numbers
by Thaha Hussain
This simple program generates random numbers using the basic mathematical methods. |
|
Change Cursor to Hour Glass
by Brian Gillham
A simple script to change the cursor to an hour glass. |
|
Analog Clock
by Thaha Hussain
This program demonstrates Thaha Hussain's Clock Work Formula to paint an Analogue Clock. |
|
| |
