Article View: borland.public.cppbuilder.database.ado
Article #4262Re: Determining types of fields in ADOTable
From: amatcan
Date: Thu, 24 Jan 2002 12:22
Date: Thu, 24 Jan 2002 12:22
24 lines
1444 bytes
1444 bytes
You can use:
SELECT name FROM YourDB.dbo.systypes
where xtype in (select xtype from YourDB.dbo.syscolumns )
Alex
"Chris Buys" <chris@h-a-s.co.za> escribi๏ฟฝ en el mensaje
news:3c4fe499_1@dnews...
> Hi Everyone!
>
> Can one determine the type of a field in a database table through an
> ADOTable-component?
> If so, how?
>
>
>
> --------------------------------------------------------
> Chris Buys
> Development
>
> HAS Software (Pty) Ltd
>
>
>
Technical Details
Message-ID:
<3c4ffb0a_1@dnews>Path:
arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!supernews.com!newsfeed.direct.ca!look.ca!logbridge.uoregon.edu!hub1.nntpserver.com!news-out.spamkiller.net!propagator-la!news-in-la.newsfeeds.com!news-in.superfeed.net!newsfeed01.tsnz.net!newsfeeds.ihug.co.nz!ihug.co.nz!dnewsReferences:
<3c4fe499_1@dnews>Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII X-Google-Thread: 10698b,ff38677e82a96692 X-Google-Attributes: gid10698b,public X-Google-ArrivalTime: 2002-01-24 04:20:51 PST From: "amatcan" <amatcan@yahoo.es> Newsgroups: borland.public.cppbuilder.database.ado References: <3c4fe499_1@dnews> Subject: Re: Determining types of fields in ADOTable Date: Thu, 24 Jan 2002 13:22:20 +0100 Lines: 26 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 5.50.4522.1200 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200 NNTP-Posting-Host: 213.9.186.202 Message-ID: <3c4ffb0a_1@dnews> X-Trace: dnews 1011874570 213.9.186.202 (24 Jan 2002 04:16:10 -0800) Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!supernews.com!newsfeed.direct.ca!look.ca!logbridge.uoregon.edu!hub1.nntpserver.com!news-out.spamkiller.net!propagator-la!news-in-la.newsfeeds.com!news-in.superfeed.net!newsfeed01.tsnz.net!newsfeeds.ihug.co.nz!ihug.co.nz!dnews