Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: OO4O preparing statements?
"Volker Hetzer" <volker.hetzer_at_ieee.org> wrote in message
news:dobfo4$ebh$1_at_nntp.fujitsu-siemens.com...
> Jim Kennedy wrote:
> > "Volker Hetzer" <volker.hetzer_at_ieee.org> wrote in message
> > news:do9c6c$5fu$1_at_nntp.fujitsu-siemens.com...
> >>I'd like to prepare all my statements before I start collecting data.
> >>However, ExecuteSQL and CreateSLQ both run the statement as soon as they
> >>are called.
> >>Is there any way to create a statement without executing it?
> > I usually wrap them in a procedure and the first time they are called
they
> > run and thereafter I call the refresh method.
> Yes, but I wanted to get rid of that this-is-my-first-call stuff...
> But it looks like I'm stuck with it.
>
> Lots of thanks nevertheless.
> Volker
You could search for something that can't exist. It will do the query, but
not return any rows.
Jim
Received on Wed Dec 21 2005 - 09:55:19 CST