Re: Subselect questions

"MD" <md_at_md.com> wrote in message news:93e1g.16555$IZ2.7238_at_dukeread07...
: Hi Mark,
:
: I believe the variable is in scope.
: I have :
:
: BEGIN
: Declare vTripStartDate date
:
: BEGIN
: Select Into vTripStartDate
: END;
:
: SQL STATEMENT
:
: END;
:
:
: One thing I didnt mention is that this is an Update statement.
: update table
: set (var1, var2, var3) = ( Select Statement )
:
:
: So does it lose the scope because of the update select?
:

it does not lose scope because of the update statement

please post a complete example including error messages

++ mcs Received on Wed Apr 19 2006 - 04:19:35 CDT