Welcome to dbForumz.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Identifying every field type in a table programmably

 
   Database Forums (Home) -> ODBC RSS
Next:  Search Script Stopped Working  
Author Message
Hyun-jik Bae

External


Since: Nov 17, 2009
Posts: 1



(Msg. 1) Posted: Tue Nov 17, 2009 11:08 pm
Post subject: Identifying every field type in a table programmably
Archived from groups: microsoft>public>sqlserver>odbc (more info?)

I want to retrieve every field type in a table in a program.

We tried this by "select top 0 * from Table" with ADO recordset and found
that many types can be identified by reading Fields[].Type value.
However, some field types show incorrect results, for example, Date type in
SQL Server is shown as VarWChar in ADO Fields[].Type value.
How can I retrieve correct field type list of a table?

Thanks in advance.

 >> Stay informed about: Identifying every field type in a table programmably 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
bcp_bind and SQL DATETIME type - Hi all, I'm working on a simple ODBC API bulk load application and I've run into a problem. I am binding variables in memory and sending the rows as prescribed in the ODBC 3.0 API Reference and on MSDN. Everything works fine for SQL VARCHAR and SQL..

Cursor type changed error - We have an old app running RDO. We are running into the following error: Rdo Error: 0 :: [Microsoft][ODBC SQL Server Driver]Cursor type changed This is happening only intermittently. Is the resultset still valid with a different cursor type? Or do we...

problem trying to save a date field - Hi there, right now i'm working with a VB6 project that connects to a SQLSERVER 2000 using a System DSN. I discovered a problem that, i hope you can help me. The problem is that, when i try to save a record with a date field - the date saved in..

Unable to update text field - Dear Group, I'm using Access with SQL Server via ODBC. One of the fields in a table is defined as datatype Text. I'm running into a problem updating data in this field in Access. After I write data into the field and try to save the record, I get an..

problem tryig to save a date field - Hi there, right now i'm working with a VB6 project that connects to a SQLSERVER 2000 using a System DSN. I discovered a problem that, i hope you can help me. The problem is that, when i try to save a record with a date field - the date saved in..
   Database Forums (Home) -> ODBC All times are: Pacific Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]