Hello CJ,

I don't know whether this is just because of your script is just an
example, but you appear to be mixing DDL with DML in the same
transaction. That would explain various odd behaviours.

You should also really rewrite your select statement using SQL 92
syntax, and use table aliases everywhere. It removes ambiguity, and
makes it easier to read (hence maintain) by separating your real
conditions from the conditions only there to match the tables.


select FLD.FORM_NAME, FLD.FIELD_NAME, LAB.LABEL_NAME,
LAB.LAB_FONT_NAME, LAB.LAB_COLOR, LAB.LAB_BG_COLOR, FLD.FLD_FONT_NAME,
FLD.FLD_COLOR, FLD.FLD_BG_COLOR, FLD.FLD_WIDTH, LAB.FONT_SIZE
from FIELDS FLD
JOIN LABELS LAB ON (LAB.LAB_CAPTION_NO = FLD.LABEL_REC_NO)

Adam