TADOStoredProc


Using TADOStoredProc I usually write the following code:
SP1.Parameters.ParamValues['@Param'] := 20;
with SP1 DO
BEGIN
OPEN;
BLAH BLAH
CLOSE;
END;

My question is do I need to close the result set at the end and
should it be in a finally clause? I see others actually close before they open, is this needed? Will not closing cause performance issues?

Likewise for TADOQuery, do you have to set Active to false and close or is there no need to bother?

Many thanks and your help is much appreciated.

Paul
.

Relevant Pages

  • BSOD Kernel_data_inpage_error win32k.sys
    ... I get a BSOD saying Kernel_data_inpage_error and referencing ... blah blah something about shutting down in 60 seconds and then - ... shouldn't happen again but if it does to contact my hard disk manufacturer. ... I've already done a Repair install with my XP SP1 cd thinking that would fix ...
    (microsoft.public.windowsxp.general)
  • Re: TADOStoredProc
    ... with SP1 DO ... BLAH BLAH ... Likewise for TADOQuery, do you have to set Active to false and close or is there no need to bother? ... You can use the REQUERY method which is faster than Close/open ...
    (borland.public.delphi.database.ado)
  • Re: how to create button with image look like this one in the attached image
    ... like on mouse-rollover blah blah ... should we bother to try to decipher your request? ... and use them in Java programs. ...
    (comp.lang.java.programmer)
  • Re: how to create button with image look like this one in the attached image
    ... like on mouse-rollover blah blah ... should we bother to try to decipher your request? ... and use them in Java programs. ...
    (comp.lang.java.programmer)
  • Re: bachmann 57
    ... > I was going to comment on that but don't think I will bother (Peak ... > Forest blah blah blah) ...
    (uk.rec.models.rail)