ACCEPT statement

From: <dennishancy_at_eaton.com>
Date: Fri, 16 Jul 1999 17:41:48 GMT
Message-ID: <7mnqsp$ltj$1@nnrp1.deja.com>

declare
  username char(6);
begin
  accept username prompt 'Please enter a username right here: ';   select field
    from table
   where usr = &username;
end;

This is just a portion of my sql script. When I run it, the first thing I see is this:

Enter a value for username:

I'm assuming this is the generic prompt that comes from the &username part of the where statement.

Why does this run before my "accept" statement?

Dennis Hancy
Eaton Corporation
Cleveland, OH

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Fri Jul 16 1999 - 12:41:48 CDT