Re: PROCEDURE WITH CURSOR PROBLEM

From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Sun, 17 Jun 2007 11:48:38 +0200
Message-ID: <f5301i$odh$1@news1.zwoll1.ov.home.nl>

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Guilherme wrote:

> sql := 'select * from table';
> IF p1 IS NOT NULL THEN
> sql := sql||'WHERE id = '||p1;
> END IF
> OPEN ret FOR sql;

Please don't.

It won't scale.
It won't scale.
It won't scale.
It won't scale.

It's a horror to tune, and did I mention it won't scale? - --
Regards,
Frank van Bortel

Top-posting is one way to shut me up...
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (MingW32)

iD8DBQFGdQN2Lw8L4IAs830RAnU0AJ9M2Xt7BALCF8wBVQm7G40l82wRvACfR1iJ ALuW7n15irV8SUmoTZUT4D0=
=EfVC
-----END PGP SIGNATURE----- Received on Sun Jun 17 2007 - 04:48:38 CDT