🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

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

Data returned by TADOStoredProcedure don't refresh

#5532
From: Jorge Bustos
Date: Fri, 06 Apr 2001 21:24
37 lines
2120 bytes
I'm trying to use an stored procedure to execute this Access 2000 query with
parameters.

SELECT Param.CustNo, Param.Type, Param.No, Param.Description, Param.HelpText
FROM Param
WHERE (((Param.CustNo)=[:CustNo]) AND ((Param.Type)=[:Type]));

The code is this:

CamposParamStProc->Close();
CamposParamStProc->Parameters->ParamByName("Type")->Value=Type;
// this Parameter is defined as a String, Size 1
CamposParamStProc->Parameters->ParamByName("CustNo")->Value=CustomerNo;
// this parameter is designed as a Long Integer
CamposParamStProc->Open();

Although the Type and CustomerNo do change, the values returned by the
Stored Procedure are always the same.

Why don't data refresh? What should I do to force a refresh? Do I forget
something?

(The query works perfectly on Access: is too simple to fail!)

Thanks in advance,
      Jorge Bustos.

P.S. While in the IDE the only way I have succeded to get the desired
records was this:
1) Set Active to false
2) Change the parameter values
3) Clear the Connection property
4) Set the Connection property to its previous value
5) Set Active to true

If I don't take steps 3 and 4 the data don't refresh... Why? I'm getting mad
about this!
Technical Details
Message-ID: <3ace33c7_2@dnews>
Path: arc1-ca.pugleaf.net!supernews.google.com!sn-xit-02!supernews.com!news.tele.dk!206.252.192.28!news.stealth.net!nntp1.njy.teleglobe.net!teleglobe.net!hub.org!hub.org!PeerFeed.KWeb.on.ca!dnews

Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,5a9baab9d72128c0,start
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2001-04-06 14:38:58 PST
Reply-To: "Jorge Bustos" <jbustos@teleline.es>
From: "Jorge Bustos" <jbustos@teleline.es>
Newsgroups: borland.public.cppbuilder.database.ado
Subject: Data returned by TADOStoredProcedure don't refresh
Date: Fri, 6 Apr 2001 23:24:04 +0200
Lines: 39
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2314.1300
X-MIMEOLE: Produced By Microsoft MimeOLE V5.00.2314.1300
NNTP-Posting-Host: 62.83.15.164
Message-ID: <3ace33c7_2@dnews>
X-Trace: dnews 986592199 62.83.15.164 (6 Apr 2001 14:23:19 -0700)
Path: arc1-ca.pugleaf.net!supernews.google.com!sn-xit-02!supernews.com!news.tele.dk!206.252.192.28!news.stealth.net!nntp1.njy.teleglobe.net!teleglobe.net!hub.org!hub.org!PeerFeed.KWeb.on.ca!dnews