TADOStoredProc return no recordset at runtime

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

Article #2059

Back to borland.public.cppbuilder.database.ado Previous Next

#2059

From: Erwin Alberts
Date: Thu, 27 Nov 2003 15:50

18 lines
1351 bytes

hi

I'm using TADOStoredProc in BCB6 (sp in MSSQL2k) which should return a
recordset depending on some input parameters.
setting these parameters at disign time returns the rs, but nothing returns
when the parameters are set at run time.

code:
ADOStoredProc1->Active = true;
ADOStoredProc1->Parameters->ParamByName("@lat_pech")->Value = dLatitude;
ADOStoredProc1->Open();

I'm using the default settings of the TADOStoredProc and tried everything
else too.

How can I get this to work?

Erwin

Technical Details

Message-ID: <3fc61d4c@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news2.google.com!news.maxwell.syr.edu!newsfeed.wirehub.nl!news.kweb.on.ca!newsgroups.borland.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,ba76b4b6d2206645,start
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2003-11-27 08:01:50 PST
From: "Erwin Alberts" <albertsatperdotnl>
Newsgroups: borland.public.cppbuilder.database.ado
Subject: TADOStoredProc return no recordset at runtime
Date: Thu, 27 Nov 2003 16:50:29 +0100
Lines: 20
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: 213.84.24.192
Message-ID: <3fc61d4c@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1069948236 213.84.24.192 (27 Nov 2003 07:50:36 -0700)
Path: arc1-ca.pugleaf.net!archiver1.google.com!news2.google.com!news.maxwell.syr.edu!newsfeed.wirehub.nl!news.kweb.on.ca!newsgroups.borland.com!not-for-mail