Ado Table Problem

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

Article #4030

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

#4030

From: Matt Morrisset
Date: Mon, 22 Apr 2002 19:02

19 lines
1704 bytes

I have a simple form that displays a single table (Select * from t_table)
from a SQL server 7 database.
1.)Created a new Project.
2.)Added an ADOTable Object set the connection string and table name.
3.)Added a DataSource and set it's dataset to the ADO Table
4.)Then Added the DBGrid and set it's datasource to the datasource.
5.)Set all of 'em to active and the data was shown in the dbgrid (design
time)
6.)I run the application and get the following error and no data is shown.
    exception class EVariantTypeCastError with message 'Could not convert
variant type (NULL) into type (String)'...

I tried replacing the ADOTable with ADOQuery and it worked fine.
Am I misusing the Table Object or is this a bug that someone else can
replicate.

Thanks
<matt>
matt@dreamersmind.com

Technical Details

Message-ID: <3cc45ef5$1_1@dnews>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-01!supernews.com!newsfeed.online.be!feed1.news.be.easynet.net!skynet.be!skynet.be!newsfeed01.tsnz.net!newsfeeds.ihug.co.nz!ihug.co.nz!dnews

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,d894be8222677abc,start
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2002-04-22 12:10:17 PST
Reply-To: "Matt Morrisset" <matt@dreamersmind.com>
From: "Matt Morrisset" <matt@dreamersmind.com>
Newsgroups: borland.public.cppbuilder.database.ado
Subject: Ado Table Problem
Date: Mon, 22 Apr 2002 12:02:37 -0700
Lines: 21
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2462.0000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2462.0000
NNTP-Posting-Host: 64.30.196.122
Message-ID: <3cc45ef5$1_1@dnews>
X-Trace: dnews 1019502325 64.30.196.122 (22 Apr 2002 12:05:25 -0700)
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-01!supernews.com!newsfeed.online.be!feed1.news.be.easynet.net!skynet.be!skynet.be!newsfeed01.tsnz.net!newsfeeds.ihug.co.nz!ihug.co.nz!dnews