Subject | Prepare - Params question |
---|---|
Author | Ryan Nilsson-Harding |
Post date | 2003-07-17T04:33:24Z |
Hi all,
In the IBO help, it states that if you access the ParamByName
method, a Prepare is automatically called (if needed), but if you
access the Params array, you must explicitly ensure the query is
prepared, before accessing the array.
Is there any other issues with using ParamByName?
I have been using Params (with a preceding check on Prepared), but I
am thinking I may go to ParamByName, but would like to know about
any other little things, if there are any.
I'm asking because I'm aware using FieldByName has more overhead
than the Fields array.
Is it similar with ParamByName?
Rgds,
-Ryan
In the IBO help, it states that if you access the ParamByName
method, a Prepare is automatically called (if needed), but if you
access the Params array, you must explicitly ensure the query is
prepared, before accessing the array.
Is there any other issues with using ParamByName?
I have been using Params (with a preceding check on Prepared), but I
am thinking I may go to ParamByName, but would like to know about
any other little things, if there are any.
I'm asking because I'm aware using FieldByName has more overhead
than the Fields array.
Is it similar with ParamByName?
Rgds,
-Ryan