Re: TMemo->Lines->Text ??? (varchar)

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

Article #3259

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

#3259

From: Stephane Baillargeon
Date: Thu, 07 Nov 2002 16:57

23 lines
1847 bytes

It was my stupid mistake.  Since there are over 30 params to put into this
SQL INSERT I forgot 1 of them so the type was not the same....

Sorry for the inconvienience of my really dumb mistake :) :P

"Stephane Baillargeon" <sbaillargeon@microids.com> wrote in message
news:3dca8990$1@newsgroups.borland.com...
> I was wondering why TMemo->Lines->Text property fails to insert itself in
a
> SQL Server 7 varchar type field
>
> adoQueryTask->Parameters->Items[16]->Value = memComment->Lines->Text;
> ///////////
> Gives a wrong type value exception
> ///////////
>
> However, this one works:
>
> adoQueryTask->Parameters->Items[8]->Value = txtName->Text;
>
> Both ->Text properties return an AnsiString
>
>

Technical Details

Message-ID: <3dca9bab@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-03!sn-xit-06!sn-xit-04!supernews.com!64.152.100.70.MISMATCH!sjc70.webusenet.com!news.webusenet.com!newsfeed.news2me.com!newsfeed.icl.net!newsfeed.fjserv.net!proxad.net!fr.clara.net!heighliner.fr.clara.net!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

References: <3dca8990$1@newsgroups.borland.com>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,9ecd8700c223124d
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2002-11-07 09:14:09 PST
From: "Stephane Baillargeon" <sbaillargeon@microids.com>
Newsgroups: borland.public.cppbuilder.database.ado
References: <3dca8990$1@newsgroups.borland.com>
Subject: Re: TMemo->Lines->Text ??? (varchar)
Date: Thu, 7 Nov 2002 11:57:26 -0500
Lines: 25
Organization: Microids Canada Inc.
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: 216.208.130.66
Message-ID: <3dca9bab@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1036688299 216.208.130.66 (7 Nov 2002 08:58:19 -0800)
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-03!sn-xit-06!sn-xit-04!supernews.com!64.152.100.70.MISMATCH!sjc70.webusenet.com!news.webusenet.com!newsfeed.news2me.com!newsfeed.icl.net!newsfeed.fjserv.net!proxad.net!fr.clara.net!heighliner.fr.clara.net!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

Reply to Parent Message