Article View: borland.public.cppbuilder.database.ado
Article #5532Data returned by TADOStoredProcedure don't refresh
From: Jorge Bustos
Date: Fri, 06 Apr 2001 21:24
Date: Fri, 06 Apr 2001 21:24
37 lines
2120 bytes
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!dnewsShow 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