|
code
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Trying to access tabledef infoI am tying to get the column attributes on a table named charges.
Can someone point me to a tutorial or to some sample code on how to do this. What objects (DAO or ADO) do I need to use this? Thanks. "Bookreader" <bookreader***@yahoo.com> wrote in message For ADO, look up the OpenSchema method of the Connection object. Pass it news:defqt15idf3icqve5gq839vm4croumtb4t@4ax.com... >I am tying to get the column attributes on a table named charges. > > Can someone point me to a tutorial or to some sample code on how to do > this. > > What objects (DAO or ADO) do I need to use this? the adSchemaColumns constant. See ADO's Help on the OpenSchema method and the SchemaEnum constants for a list of the information returned. Note that this method returns a recordset. -- Mike Microsoft MVP Visual Basic
Show quote
Hide quote
On Sun, 29 Jan 2006 20:17:16 -0500, "MikeD" <nob***@nowhere.edu>
wrote: > >"Bookreader" <bookreader***@yahoo.com> wrote in message >news:defqt15idf3icqve5gq839vm4croumtb4t@4ax.com... >>I am tying to get the column attributes on a table named charges. >> >> Can someone point me to a tutorial or to some sample code on how to do >> this. >> >> What objects (DAO or ADO) do I need to use this? > > >For ADO, look up the OpenSchema method of the Connection object. Pass it >the adSchemaColumns constant. See ADO's Help on the OpenSchema method and >the SchemaEnum constants for a list of the information returned. Note that >this method returns a recordset. Thanks. 
Other interesting topics
How to best resize a form?
Using Control Array in User Control Why sending email programmatically must be so complicated? VB 2005 Express..NOT OT...really! File Copy Without Win Buffering Why Randomize() won't work? Proper way to resize a Form VB6---.NET Passing data from a dll to the main VB program Problems with vbCtrlMask |
|||||||||||||||||||||||
