Example: Find the Name and Tabbing Sequence Number of Fields on a Form
This query finds the name and tabbing sequence number of every simple field and table field on form “empform” (empform is owned by user “susan”).
select form=o.object_name, f.fldname, f.flseq,
f.fltype
from ii_objects o, ii_fields f
where o.object_class = 1601
/* object_class 1601 = "form" */
and o.object_name = 'empform'
and o.object_owner = 'susan'
and o.object_id = f.object_id
and (f.fltype = 0 or f.fltype = 1)
/* simple field or table field */
order by flseq