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>


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

Original text of this message