🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

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

Setting Parameter Values Using TADOStoredProc Generates AV Error.

#5567
From: Alan Lichtenstein
Date: Thu, 29 Mar 2001 18:37
34 lines
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.10

Show 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