%RECORD% in data portion of table#
We've had an ongoing issue with a select against the PAYRUN table returing fewer records that is the case
header#
Still don't quite understand how/why/where the index was created, however using the b/s OI table builder added no value
So to check and remove the index, do it manually
RUN ATTACH_TABLE "d:\databases\{CUSTOMER}\mmsoi\MMSDATA","REVMEDIA"
edit the "REVMEDIA","PAYRUN" record shows this:
REV26431
RIGHTDEX.MFS
MMS
the fix#
remove the