Re: Getting the type of a field

Article View: borland.public.cppbuilder.database.ado

Article #2509

Back to borland.public.cppbuilder.database.ado Previous Next

#2509

From: Vladimir Afanasyev
Date: Fri, 06 Jun 2003 07:39

15 lines
1653 bytes

"Yassin" <urmail@yahoo.com> wrote:
>
>Hi,
>If I know the database name I can get the table names by calling GetTableNames. If I know the table name I can know the name of the fields by calling GetFieldNames(tableName, fields). My question is: how can I know the type (int, date, text,...) of a field if I know the name of the fiels and/or the name of the table?
>

Another idea (ADO -> Recordset -> Fields -> Field -> Type) 
is using Fields Collection.
Fields consists from set of Field that can be enumerated.
Field has a property Type (just type of data).
Sample for mdb-files:
http://codecentral.borland.com/codecentral/ccweb.exe/listing?id=19860

Vladimir.

Technical Details

Message-ID: <3ee0452d$1@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!sn-xit-08!supernews.com!priapus.visi.com!news-out.visi.com!petbe.visi.com!newsfeed.wirehub.nl!news.kweb.on.ca!KWeb!newsgroups.borland.com!not-for-mail

References: <3ede76d1$1@newsgroups.borland.com>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,858833551822127
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2003-06-06 00:44:36 PST
From: "Vladimir Afanasyev" <avv@systema.kiev.ua>
Sender: "Vladimir Afanasyev" <avv@systema.kiev.ua>
Reply-To: "Vladimir Afanasyev" <avv@systema.kiev.ua>
Subject: Re: Getting the type of a field
Newsgroups: borland.public.cppbuilder.database.ado
X-User-Info: 62.244.14.114 62.244.14.114    
X-Forwarded-For: 192.168.0.147
References:  <3ede76d1$1@newsgroups.borland.com>
NNTP-Posting-Host: 207.105.83.65
Message-ID: <3ee0452d$1@newsgroups.borland.com>
Date: 6 Jun 2003 00:39:25 -0700
X-Trace: newsgroups.borland.com 1054885165 207.105.83.65 (6 Jun 2003 00:39:25 -0700)
Lines: 17
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!sn-xit-08!supernews.com!priapus.visi.com!news-out.visi.com!petbe.visi.com!newsfeed.wirehub.nl!news.kweb.on.ca!KWeb!newsgroups.borland.com!not-for-mail

Reply to Parent Message