Article View: borland.public.cppbuilder.database.ado
Article #3289TADOStoredProc
From: Arun Kumar
Date: Thu, 17 Oct 2002 01:52
Date: Thu, 17 Oct 2002 01:52
43 lines
2767 bytes
2767 bytes
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)
{
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:
<3dae166c$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!news.maxwell.syr.edu!newshosting.com!news-xfer1.atl.newshosting.com!uunet!dca.uu.net!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mailShow Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: 10698b,4fe79d591c20775c,start X-Google-Attributes: gid10698b,public X-Google-ArrivalTime: 2002-10-16 19:04:00 PST From: "Arun Kumar" <arunpv@optonline.net> Newsgroups: borland.public.cppbuilder.database.ado Subject: TADOStoredProc Date: Wed, 16 Oct 2002 21:52:00 -0400 Lines: 46 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2800.1106 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106 NNTP-Posting-Host: 24.47.37.187 Message-ID: <3dae166c$1@newsgroups.borland.com> X-Trace: newsgroups.borland.com 1034819180 24.47.37.187 (16 Oct 2002 18:46:20 -0700) Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-03!sn-xit-01!sn-xit-04!supernews.com!news.maxwell.syr.edu!newshosting.com!news-xfer1.atl.newshosting.com!uunet!dca.uu.net!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail