title: Define variable and run a query using EXECUTE BLOCK
body: <p>I have a large query in Firebird (which I run using FlameRobin), using a parameter all over the place, but getting the query below to run will do:</p>
  
  <pre class="lang-sql prettyprint-override"><code>SELECT * FROM customers WHERE customerid = 1234;
  </code></pre>
  
  <p>I want to define <code>1234</code> as a variable, say <code>customerID</code>, so that I can easily replace it with something else.</p>
  
  <p>I've learned that I need to put this inside a <code>EXECUTE BLOCK</code>.</p>
  
  <pre class="lang-sql prettyprint-override"><code>EXECUTE BLOCK 
  AS
  DECLARE customerID INT = 1234;
  
  BEGIN
    SELECT * FROM customers WHERE customerid = :customerID
  END
  </code></pre>
  
  <p>If of any importance, the error I am getting is <code>Engine Message :
  Dynamic SQL Error
  SQL error code = -104
  Unexpected end of command - line 3, column 26</code></p>