🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

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

EXCEPTION: Cannot perform this operation on closed dataset

#3274
From: Gautam Kachru
Date: Fri, 11 Oct 2002 09:17
38 lines
2038 bytes
The following is a code fragment ... am getting an Exception as indicated
below...
The connection seems ok ( have checked if its open ). Obviously I'm missing
something.
If anyone has a clue and maybe needs some more information ... I'd be more
than glad to provide it!

Regards,
Gautam

.
.
.
// Database Connection already establisted using TADOConnection
//

  // StoredProc is an object of TADOStoredProc
  StoredProc->Parameters->Items[1]->Value = UserName; // AnsiString
  StoredProc->Parameters->Items[2]->Value = PickStatus; // int
  StoredProc->ExecProc();

  if (StoredProc->Parameters->Items[0]->Value != 1)
  {
   Screen->Cursor = crDefault;
   MessageDlg("Error reading database!", mtError, TMsgDlgButtons() << mbOK,
0);
  }
  else
  {
   ShowMessage(StoredProc->RecordCount);
// EXCEPTION: Cannot perform this operation on closed dataset
   }

/** Stored Procedure declaration
create Procedure USP_EBS_GETARTTICLELIST(@UserId as Varchar(5),@Status as
Tinyint)
Returns 1 if successful
*/
Technical Details
Message-ID: <3da69734@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-out.spamkiller.net!propagator2-maxim!news-in.spamkiller.net!news02.tsnz.net!newsfeed01.tsnz.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,cc69731dde3be146,start
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2002-10-11 02:24:02 PST
From: "Gautam Kachru" <gkachru@hotmail.com>
Newsgroups: borland.public.cppbuilder.database.ado
Subject: EXCEPTION: Cannot perform this operation on closed dataset
Date: Fri, 11 Oct 2002 14:47:59 +0530
Lines: 42
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2600.0000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
NNTP-Posting-Host: 203.122.35.209
Message-ID: <3da69734@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1034327860 203.122.35.209 (11 Oct 2002 02:17:40 -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-out.spamkiller.net!propagator2-maxim!news-in.spamkiller.net!news02.tsnz.net!newsfeed01.tsnz.net!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail