🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

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

Re: 'Could not convert variant of type (Null) into type (String)'

#635
From: Mike Shkolnik
Date: Fri, 13 Jan 2006 14:02
36 lines
2066 bytes
Somewhere in your code you read the Value property for field and applied to
AnsiString variable.
Just use the AsString for your field instead Value and no error will be
raised

--
With best regards, Mike Shkolnik
EMail: mshkolnik@scalabium.com
http://www.scalabium.com

"Kura" <kurakusmaximus@poczta.onet.pl> wrote in message
news:43c78184@newsgroups.borland.com...
> In borland C++ builder 6 I add ADOTable and set up
> ConnectionString on value:
> Provider=MSDASQL.1;Password=masterkey;Persist Security Info=True;User
> ID=sysdba;Data Source=ConnectFbServer;Mode=ReadWrite
>
>
> I connecting with Firebird, I have OLE DB driver from
> Firebird website.
>
>
> In propertise for ADOTable  "table name" I choose my table,and set active
on
> true
> When i compiling the program i get an exception:
> Project "Name.exe" raised exception class EVariantTypeCastError with
> message 'Could not convert variant of type (Null) into type (String)'.
>
>
> I don`t have any others components then Form and ADOTable.
>
> I'll be greatfull for any suggestions.(Sory for my Englisch!)
>
>
>
Technical Details
Message-ID: <43c7b22c@newsgroups.borland.com>
Path: arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!news2.google.com!proxad.net!212.101.4.254.MISMATCH!solnet.ch!solnet.ch!newsfeed.freenet.de!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail
References: <43c78184@newsgroups.borland.com>

Show Full Headers
Complete Article Headers
X-Google-Thread: 10698b,675aba66c3209cb7
X-Google-Attributes: gid10698b,public
X-Google-Language: ENGLISH,ASCII-7-bit
From: "Mike Shkolnik" <mshkolnik2002@ukr.net>
Newsgroups: borland.public.cppbuilder.database.ado
References: <43c78184@newsgroups.borland.com>
Subject: Re: 'Could not convert variant of type (Null) into type (String)'
Date: Fri, 13 Jan 2006 16:02:02 +0200
Lines: 38
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1106
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
NNTP-Posting-Host: 62.244.34.86
Message-ID: <43c7b22c@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1137160748 62.244.34.86 (13 Jan 2006 05:59:08 -0700)
Path: arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!news2.google.com!proxad.net!212.101.4.254.MISMATCH!solnet.ch!solnet.ch!newsfeed.freenet.de!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail