Re: What to use for ADO parameter type and size

Set rs = .Execute( ,Array(arr2(i, 0)))

This does work, but is slightly slower than doing:

Set rs = .Execute( ,arr2(i, 0))

What is the reason for doing Array(arr2(i, 0)) ?


RBS

"Bob Barrows [MVP]" <reb01501@xxxxxxxxxxxxxxx> wrote in message news:O3hRrDG0HHA.3600@xxxxxxxxxxxxxxxxxxxxxxx
RB Smissaert wrote:
Thanks for the quick reply.

Yes, leaving off the Set was a typo, but it worked fine tough.

I think I do need the recordset as I need to move the data to a SQLite
table.

Now that I read your code again, i see that I skimmed over that line too quickly. Of course you are opening a recordset. My suggested alternative should be changed to:

Set rs = .Execute( ,Array(arr2(i, 0)))

Are you suggesting I should do this differently?

No, I was merely suggesting an alternative, since you didn't seem to be "happy" with what you had written.


I had read somewhere that specifically defining the parameter object
was faster, so
that is what I did.

Maybe a nanosecond faster. Plus it's more typesafe. But you're using a variant array to populate it so it seems you have no need for type safety.


--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"


.

Relevant Pages

  • Re: What to use for ADO parameter type and size
    ... Yes, leaving off the Set was a typo, but it worked fine tough. ... I think I do need the recordset as I need to move the data to a SQLite ... Maybe a nanosecond faster. ... This email account is my spam trap so I ...
    (microsoft.public.data.ado)
  • Re: Wanna any idea to generate an ID
    ... a recordset with a pessimistic lock (this is pretty much the ... ASP) can be used to retrieve and increment the value: ... CREATE TABLE NextID ... This email account is my spam trap so I ...
    (microsoft.public.inetserver.asp.db)
  • Re: ERROR with command text
    ... I'm not sure why you would think I would hate it. ... unnecessary recordset object when your run a query that returns no records ... This email account is my spam trap so I ...
    (microsoft.public.scripting.vbscript)
  • Re: Accessing data from an MS Access database on a remote web serv
    ... updatebatch statement there. ... simple update on the recordset in the calling page since it's disconnected ... disconnected your recordset in the first place. ... This email account is my spam trap so I ...
    (microsoft.public.inetserver.asp.db)
  • Re: MORE sql Query
    ... A single connection can be re-used ... The first field in the recordset has an ordinal position of zero, ... So you can use rsto refer to it. ... This email account is my spam trap so I ...
    (microsoft.public.inetserver.asp.general)