🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

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

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

#3258
From: Stephane Baillargeon
Date: Thu, 07 Nov 2002 15:40
13 lines
1387 bytes
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: <3dca8990$1@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!c02.atl3!news.webusenet.com!news02.tsnz.net!newsfeed01.tsnz.net!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail

Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,9ecd8700c223124d,start
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2002-11-07 08:08:06 PST
From: "Stephane Baillargeon" <sbaillargeon@microids.com>
Newsgroups: borland.public.cppbuilder.database.ado
Subject: TMemo->Lines->Text ??? (varchar)
Date: Thu, 7 Nov 2002 10:40:11 -0500
Lines: 15
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: <3dca8990$1@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1036683664 216.208.130.66 (7 Nov 2002 07:41:04 -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!c02.atl3!news.webusenet.com!news02.tsnz.net!newsfeed01.tsnz.net!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail