?
Solved

Visual Basic Data Dictionary using ADO or DAO

Posted on 2003-02-19
7
Medium Priority
?
271 Views
Last Modified: 2013-11-25
I am looking to further detail data dictionary code to show the field's precision and scale.  How do I do this using ADO & DAO?  I have code to pull table name, field name, field type but need the two additional characteristics.  code look like this:

rst.AddNew
rst!TableName = tdf.Name
rst!TableType = "Field"
rst!Name = Fld.Name
rst!PropertyName = prp.Name
rst!FieldType = PropertyValueFormat(prp) - calls Case statement function
rst!FieldScale = ??
rst!fieldPrecision = ??
rst.Update
0
Comment
Question by:augustamg
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
7 Comments
 
LVL 16

Expert Comment

by:twalgrave
ID: 7985388
0
 

Author Comment

by:augustamg
ID: 7988369
how about with dao?
0
 

Author Comment

by:augustamg
ID: 7988594
how about with dao?
0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
LVL 16

Accepted Solution

by:
twalgrave earned 200 total points
ID: 8000293
0
 

Expert Comment

by:CleanupPing
ID: 8901420
augustamg:
This old question needs to be finalized -- accept an answer, split points, or get a refund.  For information on your options, please click here-> http:/help/closing.jsp#1 
Experts: Post your closing recommendations!  Who deserves points here?
0
 
LVL 16

Expert Comment

by:twalgrave
ID: 8903969
recommendation: answered by twalgrave
0
 
LVL 49

Expert Comment

by:DanRollins
ID: 8959706
Moderator, my recommended disposition is:

    Accept twalgrave's comment(s) as an answer.

DanRollins -- EE database cleanup volunteer
0

Featured Post

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction While answering a recent question about filtering a custom class collection, I realized that this could be accomplished with very little code by using the ScriptControl (SC) library.  This article will introduce you to the SC library a…
Most everyone who has done any programming in VB6 knows that you can do something in code like Debug.Print MyVar and that when the program runs from the IDE, the value of MyVar will be displayed in the Immediate Window. Less well known is Debug.Asse…
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question