Re: Non initialized Cmd Parameter Collection via ASP vs SQL Server

Bob Barrows [MVP] wrote:
Lars-Erik wrote:

As a sidenote.. .Refresh does really not seem to be necessary. I've
ran the code without it on my client computer running Vista, and as
long as the command is given type 4, an open connection (or a string,
which is bad practice :P ), and a command name, the roundtrip is made
as soon as you try to access the parameters.

Not in my testing. Of course, I don't have a Vista machine to test it
on, but I'm not really sure why that would make a difference.


Now I have to eat my words. It is right there in the documentation:

If you have not defined your own Parameter objects and you access the
Parameters collection before calling the Refresh method, ADO will
automatically call the method and populate the collection for you.

I'm not sure at what version of ADO this started happening (not that it
matters ...), but it was not the case in earlier versions and I simply
did not notice when it changed.

--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.


.

Relevant Pages

  • Re: Refresh command question
    ... "Ken Snell (MVP)" wrote: ... DoCmd.DoMenuItem acFormBar, acRecordsMenu, 5,, acMenuVer70 ... likely enough time passes before the refresh routine is called. ...
    (microsoft.public.access.modulesdaovba)
  • Re: CDrom will not refresh
    ... remembering old CP/M commands, did you tryed to do a CTRL C command under a ... Bienvenidos al sitio de MVP de Microsoft ... > Just the XP does not refresh it, I need to totally reboot> to read in a new cd. ...
    (microsoft.public.windowsxp.hardware)
  • Re: Update blocking internet access/Removing D/L updates
    ... PA Bear [MS MVP] wrote: ... I already posted that indeed, upon refresh, the links are now available on ... only the silly workarounds. ...
    (microsoft.public.windowsupdate)
  • Re: ISA 2006 Proxy
    ... dann macht der Browser einen Refresh und der Webserver konfiguriert die Postfilter passend. ... Frank Carius MS Exchange MVP ...
    (microsoft.public.de.german.isaserver)