[Firebird-test] Opinion requested on alias use in FB 2

[russell <ru...@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

-- 
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.1.384 / Virus Database: 268.4.1/312 - Release Date: 14-04-2006