ADOX reference

[Dave Navarro]

Can anyone point me to an online reference for ADOX?

I am trying to get deep into the datatypes in a table from within my ASP
page.

Thanks!

--Dave

[Aaron Bertrand [MVP]]

> Can anyone point me to an online reference for ADOX?

[url]http://msdn.microsoft.com/library/en-us/ado270/htm/adoddlo1.asp[/url]

> I am trying to get deep into the datatypes in a table

[url]http://www.aspfaq.com/2177[/url]

[Dave Navarro]

In article <OkHwdNTYDHA.536@TK2MSFTNGP10.phx.gbl>, [email]aaron@TRASHaspfaq.com[/email]
says...

> > I am trying to get deep into the datatypes in a table

>
> [url]http://www.aspfaq.com/2177[/url]

I started with your code, thanks!

Here's an updated function to return text for a data type:

Function GetDataType(ByVal dt)
Select Case dt
Case 0: GetDataType = "Empty"
Case 2: GetDataType = "SmallInt"
Case 3: GetDataType = "Integer"
Case 4: GetDataType = "Real"
Case 5: GetDataType = "Double"
Case 6: GetDataType = "Currency"
Case 7: GetDataType = "Date"
Case 8: GetDataType = "BSTR"
Case 9: GetDataType = "IDispatch"
Case 10: GetDataType = "Error Code"
Case 11: GetDataType = "Boolean"
Case 12: GetDataType = "Variant"
Case 13: GetDataType = "IUknown"
Case 14: GetDataType = "Decimal"
Case 16: GetDataType = "TinyInt"
Case 17: GetDataType = "Unsigned TinyInt (BYTE)"
Case 18: GetDataType = "Unsigned Small Int (WORD)"
Case 19: GetDataType = "Unsigned Int (DWORD)"
Case 20: GetDataType = "Big Int"
Case 21: GetDataType = "Unsigned Big Int"
Case 64: GetDataType = "FileTime"
Case 72: GetDataType = "Unique Identifier (GUID)"
Case 128: GetDataType = "Binary"
Case 129: GetDataType = "Char"
Case 130: GetDataType = "nChar"
Case 131: GetDataType = "Numeric"
Case 132: GetDataType = "User Defined (UDT)"
Case 133: GetDataType = "DBDate"
Case 133: GetDataType = "DBTime"
Case 135: GetDataType = "Small DateTime"
Case 136: GetDataType = "Chapter"
Case 138: GetDataType = "Automation (PropVariant)"
Case 139: GetDataType = "VarNumeric"
Case 200: GetDataType = "VarChar"
Case 201: GetDataType = "Text"
Case 202: GetDataType = "nVarChar"
Case 203: GetDataType = "nText"
Case 203: GetDataType = "VarBinary"
Case 205: GetDataType = "Image"
Case Else: GetDataType = dt
End Select
End Function