A. System Catalogs : Extended System Catalogs : Sample Queries for the Extended System Catalogs for SQL : Example: Find the Name and Tabbing Sequence Number of Fields on a Form
 
Share this page                  
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