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
|
