Subject | Prepare confusion |
---|---|
Author | Scronkey |
Post date | 2002-08-21T00:43:29Z |
Hi there.
I'm still a little confused about the use of prepare/unprepare.
Are these only needed on paramterized queries?
My scenario is that I have a query which most of the time uses one
where clause, but occasionally I need to do a sqlWhere.Clear and use
a different where clause.
Do I need to unprepare/prepare in this case?
I am finding that it works fine without using prepare at all, but
I'm not sure if it is correct (ie speed)
When is an unprepare explicitly needed? Always before a prepare?
Thanks for any info.
Rgds,
-Ryan
I'm still a little confused about the use of prepare/unprepare.
Are these only needed on paramterized queries?
My scenario is that I have a query which most of the time uses one
where clause, but occasionally I need to do a sqlWhere.Clear and use
a different where clause.
Do I need to unprepare/prepare in this case?
I am finding that it works fine without using prepare at all, but
I'm not sure if it is correct (ie speed)
When is an unprepare explicitly needed? Always before a prepare?
Thanks for any info.
Rgds,
-Ryan