Article View: borland.public.cppbuilder.database.ado
Article #4039Re: Ado Table Problem
From: Big Stew
Date: Tue, 23 Apr 2002 07:49
Date: Tue, 23 Apr 2002 07:49
29 lines
2024 bytes
2024 bytes
Using Builder 5 (Enterprise, update pack 1, ADOExpress update pack1) I followed your steps, and did not encounter any errors. Does the problem still occur when you open a different table? BigStew "Matt Morrisset" <matt@dreamersmind.com> wrote in message news:3cc45ef5$1_1@dnews... > 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:
<3cc5121f_2@dnews>Path:
arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-01!supernews.com!195.40.4.120.MISMATCH!easynet-quince!easynet.net!proxad.net!fr.clara.net!heighliner.fr.clara.net!newsfeed01.sul.t-online.de!t-online.de!dnewsReferences:
<3cc45ef5$1_1@dnews>Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: 10698b,d894be8222677abc X-Google-Attributes: gid10698b,public X-Google-ArrivalTime: 2002-04-23 01:09:57 PST From: "Big Stew" <Big_Stew@talk21.com> Newsgroups: borland.public.cppbuilder.database.ado References: <3cc45ef5$1_1@dnews> Subject: Re: Ado Table Problem Date: Tue, 23 Apr 2002 08:49:24 +0100 Lines: 31 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2600.0000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 NNTP-Posting-Host: 212.19.90.97 Message-ID: <3cc5121f_2@dnews> X-Trace: dnews 1019548191 212.19.90.97 (23 Apr 2002 00:49:51 -0700) Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-01!supernews.com!195.40.4.120.MISMATCH!easynet-quince!easynet.net!proxad.net!fr.clara.net!heighliner.fr.clara.net!newsfeed01.sul.t-online.de!t-online.de!dnews