Article View: borland.public.cppbuilder.database.ado
Article #5567Setting Parameter Values Using TADOStoredProc Generates AV Error.
From: Alan Lichtenstein
Date: Thu, 29 Mar 2001 18:37
Date: Thu, 29 Mar 2001 18:37
34 lines
2016 bytes
2016 bytes
Can anyone tell me why the code below works fine on Windows 98 however
generates an 'Access Violation' error when you try to set the parameter
values running on Windows NT Workstation. Using either 'Value' or
'ParamByName' generates the same AV error:
m_pStp->Close();
m_pStp->Parameters->CreateParameter("paramClient", ftString, pdInput,
20, NULL );
m_pStp->Parameters->CreateParameter("paramPoolno", ftString, pdInput,
20, NULL );
m_pStp->Parameters->CreateParameter("paramTaxid", ftString, pdInput,
20, NULL );
m_pStp->Parameters->Items[0]->Value =
m_pTbl->FieldByName("Client")->AsString;
m_pStp->Parameters->Items[1]->Value =
m_pTbl->FieldByName("PoolNo")->AsString;
m_pStp->Parameters->Items[2]->Value =
m_pTbl->FieldByName("Taxid")->AsString;
This fails too:
m_pStp->Parameters->Items[0]->Value = "1234";
m_pStp->Parameters->Items[1]->Value = "1994ABCD";
m_pStp->Parameters->Items[2]->Value = "123456789";
Thanx in advance for your help.........
Technical Details
Message-ID:
<3ac380ff$1_2@dnews>Path:
arc1-ca.pugleaf.net!supernews.google.com!sn-xit-03!supernews.com!news-out.usenetserver.com!news-out-sjo.usenetserver.com!news.tele.dk!130.133.1.3!fu-berlin.de!news.bnb-lp.com!dnews!198.62.209.10Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: 10698b,ff5d166d71cf3b3,start X-Google-Attributes: gid10698b,public X-Google-ArrivalTime: 2001-03-29 10:44:15 PST From: "Alan Lichtenstein" <alanl@sss.sungard.com> Newsgroups: borland.public.cppbuilder.database.ado Subject: Setting Parameter Values Using TADOStoredProc Generates AV Error. Date: Thu, 29 Mar 2001 13:37:52 -0500 Lines: 36 Organization: SunGard X-Newsreader: Microsoft Outlook Express 4.72.3110.5 X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3 NNTP-Posting-Host: 198.62.209.10 Message-ID: <3ac380ff$1_2@dnews> X-Trace: 29 Mar 2001 10:37:51 -0800, 198.62.209.10 Path: arc1-ca.pugleaf.net!supernews.google.com!sn-xit-03!supernews.com!news-out.usenetserver.com!news-out-sjo.usenetserver.com!news.tele.dk!130.133.1.3!fu-berlin.de!news.bnb-lp.com!dnews!198.62.209.10