Neil Conway wrote:
> On Thu, 2003-01-09 at 22:48, Christopher Kings-Lynne wrote:
> > With prepared statements being all well and good, how do I know if the query
> > has not yet been prepared in the backend? Or is this simply a situation
> > where I can't win?
>
> Try the EXECUTE; if it fails, run the PREPARE and then rerun the
> EXECUTE.
Erm...won't the failed EXECUTE boot you out of the middle of a
transaction? The documentation doesn't make it clear what happens in
that case, and I don't have 7.3.x running to check for myself...
--
Kevin Brown kevin(at)sysexperts(dot)com