title: Firebird random integer syntax
body: <pre><code>SET TERM ^ ;
  CREATE PROCEDURE ljudjee
  AS 
  DECLARE VARIABLE i integer=1;
  DECLARE VARIABLE d integer; 
  DECLARE VARIABLE e integer;
  DECLARE VARIABLE star integer;   
  BEGIN
  while (i &lt;= 1000000) do
  begin
    d=((rand()*99999)+1);
    e=((rand()*99999)+1);
    star=((rand()*50)+18);
    insert into ljudje values (:i,'Ime','Priimek',:star,:d,:e);
    i = i + 1;
    END
  END^
  SET TERM ; ^
  </code></pre>
  
  <p>Well i dont get any errors from this code when executing it. It seems like everything is ok but when i try to EXECUTE PROCEDURE it doesnt work. There are also no errors but procedure execution time takes forever and actually does nothing. It must be something wrong with rand() function which i probably didnt use correctly. Any ideas? Also no records are inserted into the table. None at all.</p>