Traci
Yes in that case, (it was a simple example) but reporting against a sp
is very important where you can't
get the exact result set from a simple view or select statement (using
Crystal Reports for example)
PostgreSQL returns this by
CREATE OR REPLACE FUNCTION f_test() RETURNS SETOF tbl_mytest AS $$
DECLARE
myrec record;
BEGIN
FOR myrec IN SELECT id, foo FROM tbl_mytest LOOP
RETURN NEXT myrec;
END LOOP;
RETURN;
END;
$$ LANGUAGE 'plpgsql';
which is a little more tedoius but I do like "FOR myrec IN SELECT id,
foo FROM tbl_mytest LOOP"
which is far better than the equivalent in Transact SQL
DECLARE
@ID INT,
@Foo varchar(255)
DECLARE C Cursor LOCAL FOR
SELECT id, foo FROM tbl_mytest
OPEN C
FETCH NEXT FROM C INTO @ID, @Foo
WHILE @@FETCH_STATUS = 0 BEGIN
#do something here#
FETCH NEXT FROM C INTO @ID, @Foo
END
CLOSE C
DEALLOCATE C
Neven
Isn't that what views are for ;-)
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
On Behalf Of Berend de Boer
Sent: Friday, 23 March 2007 2:44 p.m.
To: NZ Borland Developers Group - Delphi List
Subject: Re: [DUG] SQL 2005 express
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
"Robert" == Robert martin <[EMAIL PROTECTED]> writes:
Robert> Hi I haven't used the others extensively (or at all in
Robert> some cases) but to say that selectable SPs are difficult
Robert> in Firebird (1.5) makes me wonder. I have found FB stored
Robert> procs very easy to write, especially select procedures.
Robert> The others must be wonderful !
MS SQL /My Sql it is simply:
create procedure hello as
select * from world
go
Almost every other dialect requires special magic as soon as you have a
select statement inside a stored procedure.
- --
Live long and prosper,
Berend de Boer
PS: This email has been digitally signed if you wonder what the strange
characters are that your outdated email client displays.
PGP public key: http://www.pobox.com/~berend/berend-public-key.txt
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.3 (GNU/Linux)
Comment: Processed by Mailcrypt 3.5.8 <http://mailcrypt.sourceforge.net/>
iD8DBQFGAz7nIyuuaiRyjTYRAq1WAKClwyTYaTp+K4tlj2dybQlcMiq8RQCdGplo
V+zD+VyR2+SVsLrqqtO9e4U=
=Cf0F
-----END PGP SIGNATURE-----
_______________________________________________
Delphi mailing list
Delphi@ns3.123.net.nz
http://ns3.123.co.nz/mailman/listinfo/delphi
_______________________________________________
Delphi mailing list
Delphi@ns3.123.net.nz
http://ns3.123.co.nz/mailman/listinfo/delphi
_______________________________________________
Delphi mailing list
Delphi@ns3.123.net.nz
http://ns3.123.co.nz/mailman/listinfo/delphi
