Very Computer

I am using following code to display Field Name and Field Value from
table.

******************
sqlQuery = "SELECT * FROM tblTableName WHERE ID =" & intRecordID
Set Table = Conn.Execute(sqlQuery)
intFieldCount = Table.Fields.Count - 1

For i = 0 To intFieldCount
        strName = Table(i).Name
        strValue = Table(i).Value

        Response.Write(strName & " : " & strValue & "<br>")
Next
*******************

But beside this I would also like to display Filed Description, Filed
Data Type (Text, Memo, Number) and other Filed Properties (Filed
Size, Default Value, etc)

How can I accomplish this?

Thanks ahead, John.

Hi,

Try to use OpenSchema method of ADO connection. It returns
different information about fileds and tables

Val

Quote:>-----Original Message-----
>I am using following code to display Field Name and Field
Value from
>table.

>******************
>sqlQuery = "SELECT * FROM tblTableName WHERE ID =" &
intRecordID
>Set Table = Conn.Execute(sqlQuery)
>intFieldCount = Table.Fields.Count - 1

>For i = 0 To intFieldCount
>    strName = Table(i).Name
>    strValue = Table(i).Value

>    Response.Write(strName & " : " & strValue & "<br>")
>Next
>*******************

>But beside this I would also like to display Filed
Description, Filed
>Data Type (Text, Memo, Number.) and other Filed
Properties (Filed
>Size, Default Value, etc.)

>How can I accomplish this?

>Thanks ahead, John.
>.

Properties, Methods, and Events
http://msdn.microsoft.com/library/

Anything like "Description" might be in the Properties collection but is provider dependent.

--
Michael Harris
Microsoft.MVP.Scripting
--

You will find an very useful tool for OpenSchema at this link,
http://www.adoanywhere.com/download/aaBrowse2_7.zip

--
Michael Collier Bsc (Hons) Comp Sci
ADO Support Tools.
Fully Working 15-Day Trial...
http://www.adoanywhere.com/download/aaBrowse2_7.zip
Home Page
http://www.adoanywhere.com

Quote:> Hi,

> Try to use OpenSchema method of ADO connection. It returns
> different information about fileds and tables

> Val

> >-----Original Message-----
> >I am using following code to display Field Name and Field
> Value from
> >table.

> >******************
> >sqlQuery = "SELECT * FROM tblTableName WHERE ID =" &
> intRecordID
> >Set Table = Conn.Execute(sqlQuery)
> >intFieldCount = Table.Fields.Count - 1

> >For i = 0 To intFieldCount
> > strName = Table(i).Name
> > strValue = Table(i).Value

> > Response.Write(strName & " : " & strValue & "<br>")
> >Next
> >*******************

> >But beside this I would also like to display Filed
> Description, Filed
> >Data Type (Text, Memo, Number.) and other Filed
> Properties (Filed
> >Size, Default Value, etc.)

> >How can I accomplish this?

> >Thanks ahead, John.
> >.

Have you tried the Field properties Description, Type, Size, DefaultValue?

Quote:> I am using following code to display Field Name and Field Value from
> table.

> ******************
> sqlQuery = "SELECT * FROM tblTableName WHERE ID =" & intRecordID
> Set Table = Conn.Execute(sqlQuery)
> intFieldCount = Table.Fields.Count - 1

> For i = 0 To intFieldCount
> strName = Table(i).Name
> strValue = Table(i).Value

> Response.Write(strName & " : " & strValue & "<br>")
> Next
> *******************

> But beside this I would also like to display Filed Description, Filed
> Data Type (Text, Memo, Number.) and other Filed Properties (Filed
> Size, Default Value, etc.)

> How can I accomplish this?

> Thanks ahead, John.