SQL to help with the sequence of the fields in the layout:
SELECT * FROM (
SELECT A.FLDFIELDNAME, A.FLDSTART,
(SELECT COUNT(*) FROM PSFLDFIELDDEFN
WHERE FLDDEFNNAME = A.FLDDEFNNAME
AND FLDSTART < A.FLDSTART) + 1 CORRECT_SEQ,
A.FLDSEQNO ACTUAL_SEQ
FROM PSFLDFIELDDEFN A
WHERE A.FLDDEFNNAME = '<File Layout Name>'
) B
WHERE B.CORRECT_SEQ <> B.ACTUAL_SEQ
ORDER BY B.FLDSTART
Unfold
SQL to help with the sequence of the fields in the layout: by 
RahulAgrawal, 06 Feb 2010 23:38
