Article View: borland.public.cppbuilder.database.ado
Article #3297Re: TADOStoredProc
From: Arnie Mauer
Date: Thu, 17 Oct 2002 14:41
Date: Thu, 17 Oct 2002 14:41
54 lines
3230 bytes
3230 bytes
Arun,
Please see below in your code.
- Arnie
"Arun Kumar" <arunpv@optonline.net> wrote in message
news:3dae1667$1@newsgroups.borland.com...
> Hi
>
> I have a multithreaded application, i want to dynamically create a
> TADOStoredProc and Add Data,
> i have a stored procedure on SQL Server 2000.
> Also this stored procedure requires parameters.
> this is how my code looks.
>
> if (ADOStrdProc != NULL)
> {
// How do you know what's in ADOStrdProc? Was it ever
initialized to zero?
// Further, set it to zero when you delete it at the end of this
routine.
> delete ADOStrdProc; // it stops here and never returns.
> }
> ADOStrdProc = new TADOStoredProc(NULL);
> ADOStrdProc->Close();
> ADOStrdProc->Connection = Poll->pADOCon1; // this is the
> adoconnection for thread Poll.
> ADOStrdProc->Parameters->Items[0]->Value = trans->priority;
> ADOStrdProc->Parameters->Items[0]->Value = trans->cattype;
> ADOStrdProc->Parameters->Items[0]->Value = trans->stno;
> ADOStrdProc->Parameters->Items[0]->Value =
> DateTimeToStr(trans->SysDate);
> ADOStrdProc->Parameters->Items[0]->Value = trans->number;
> ADOStrdProc->Parameters->Items[0]->Value = trans->xstat;
> ADOStrdProc->Parameters->Items[0]->Value = trans->xfac;
> ADOStrdProc->Parameters->Items[0]->Value = trans->id;
> ADOStrdProc->Parameters->Items[0]->Value = trans->sType;
> ADOStrdProc->Parameters->Items[0]->Value = trans->sDesc;
> ADOStrdProc->Parameters->Items[0]->Value = trans->sName;
> ADOStrdProc->Parameters->Items[0]->Value = trans->nArch;
> ADOStrdProc->Parameters->Items[0]->Value = trans->nOper;
> ADOStrdProc->Parameters->Items[0]->Value = DateTimeToStr(Now());
> ADOStrdProc->Parameters->Items[0]->Value = trans->bPend;
> ADOStrdProc->Parameters->Items[0]->Value = trans->Resp;
> ADOStrdProc->Parameters->Items[0]->Value = trans->Sphere;
> ADOStrdProc->Parameters->Items[0]->Value = trans->Tag;
> ADOStrdProc->ExecProc();
> delete ADOStrdProc;
>
> can someone help what i am doing wrong.
>
> Thanks in Advance
>
> Arun
>
>
Technical Details
Message-ID:
<3daecc33$1@newsgroups.borland.com>Path:
arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-03!sn-xit-01!sn-xit-04!supernews.com!telocity-west!TELOCITY!news.stealth.net!news.stealth.net!nntp-relay.ihug.net!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mailReferences:
<3dae1667$1@newsgroups.borland.com>Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: 10698b,4fe79d591c20775c X-Google-Attributes: gid10698b,public X-Google-ArrivalTime: 2002-10-17 07:50:01 PST From: "Arnie Mauer" <amauer@vrms.com> Newsgroups: borland.public.cppbuilder.database.ado References: <3dae1667$1@newsgroups.borland.com> Subject: Re: TADOStoredProc Date: Thu, 17 Oct 2002 10:41:15 -0400 Lines: 56 Organization: VRMS X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2720.3000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 NNTP-Posting-Host: 24.151.50.11 Message-ID: <3daecc33$1@newsgroups.borland.com> X-Trace: newsgroups.borland.com 1034865715 24.151.50.11 (17 Oct 2002 07:41:55 -0700) Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-03!sn-xit-01!sn-xit-04!supernews.com!telocity-west!TELOCITY!news.stealth.net!news.stealth.net!nntp-relay.ihug.net!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail