🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

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

TADOStoredProc

#3290
From: Arun Kumar
Date: Thu, 17 Oct 2002 01:51
43 lines
2727 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: <3dae1667$3@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!nntp.abs.net!uunet!dca.uu.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,4fe79d591c20775c
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:51:55 -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: <3dae1667$3@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1034819175 24.47.37.187 (16 Oct 2002 18:46:15 -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!nntp.abs.net!uunet!dca.uu.net!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail