SELECT INTO question
From: Saad Ahmad <sahmad_at_mfa.com>
Date: 22 Dec 1994 14:46:00 GMT
Message-ID: <3dc3f8$jc9_at_homer.alpha.net>
Date: 22 Dec 1994 14:46:00 GMT
Message-ID: <3dc3f8$jc9_at_homer.alpha.net>
In a SELECT INTO, is the whole query executed before doing the
INTO.?
eg.
if I say:
"SELECT 'X' INTO :sql_dummy FROM tbl WHERE fld_1 like 'A%'",
would
"SELECT 'X' FROM tbl WHERE fld1 like 'A%'"
execute first, returning potentially a lot of rows; or the presence of
INTO causes the query to be executed till a single row is returned
and if there are more rows the error is set, but the query aborts?
-- ************************************************************** * Saad Ahmad * * E-Mail: sahmad_at_mfa.com * **************************************************************Received on Thu Dec 22 1994 - 15:46:00 CET