🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

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

Re: Ado Table Problem

#4039
From: Big Stew
Date: Tue, 23 Apr 2002 07:49
29 lines
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!dnews
References: <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