Ann W. Harrison wrote:

>
> There should be no problem with the internal references in
> procedures ...

unless they use regular identifiers and the tool has made the
identifiers delimited.

create table myTable (myField varchar(20));

create procedure myProcedure (returns maxMyField varchar(20))
as begin
select max (myField) from myTable;
end;

becomes

create table "myTable" ("myField" int);
create procedure "myProcedure" (returns "maxMyField" varchar(20))
as begin
select max (myField) from myTable;
end;


Then the procedure fails. It would be possible of course to add
a new field for the system table that would be used for /show/ and
/describe/ that is case preserving and let the tools continue to use
the old field. The problem is that tools that work with other
databases sometimes issue show statements and parse the results to
get metadata.


Regards,


Ann