[Firebird-test] Opinion requested on alias use

[Russell B. <st...@be...>]

I am requesting an opinion on the use of aliases in FB 2. Having read the 
new rules for SQL aliases in FB2.0 (RC1) release noes I am not sure I 
understand how they apply to my cloning case below.

INSERT statements do not allow the use of an alias by my reading of 
descriptions of the INSERT statement (FB Ref Guide).

In the following an existing objects contents are referenced by 
"source_nmds_ID" and the cloned objects contents by "newnmdsid".

The following code works (compiles and when run gives expected results) in 
FB 1.5.3 and FB 2.0 (RC1).

Will the following code work in FB 2.x versions?


  /* copy the data from the source NMDS to the new NMDS */
  for select NMD.Field_Name,NMD.FIELD_TYPE_ID, NMD.Data
  from NAMED_MATTER_DATA NMD
  where (NMD.NMDS_ID=:source_nmds_ID)
  into :FName, FTypeID, :FData do
  begin
    insert into NAMED_MATTER_DATA
    (NMDS_ID, FIELD_NAME, FIELD_TYPE_ID, DATA)
    values
    (:newnmdsid,
    cast(:FNAME as varchar(48)),
    cast(:FTYPEID as varchar(18)),
    :FDATA);
  end

Thanks
Russell Belding