Maybe someone has an idea what's I'm seeing.

I can access a record via a form. However, when I use the system editor to look at the record, I don't see the key listed in the list of available keys, but I can bring the record up into the editor.

I've tried looking for invisible characters. I don't see anything strange. I have done a recordcopy and this doesn't change anything.

Does anyone have an explanation? Or what to do to remedy this? I stumbled on this, because this record was not showing in a xref search. I have also listed (rlist) the file and this record does not show on the list.

Hmmm, this is strange…

Thanks,

Ray Chan

Hi Ray,

I was getting a similar response. Try doing a refresh on the window that lists the keys. My key didn't show through two independent sessions, when I refreshed the keys, it showed.

Jeremy

Ray,

Did you check for GFEs in your table? This could prevent your key list from populating competely. An embedded Char(0) could also prematurely stop the key list from populating.

[email protected]

SRP Computer Solutions, Inc.

Is there an out of date %RECORDS% on the file?

[email protected]

The Sprezzatura Group Web Site

World Leaders in all things RevSoft

Thanks for all the response.

I haven't used a Quickdex in a longtime. It was a bad %Records%. I removed the Quickdex, removed the index, put the index back on, now everything is hunkey dorey!.

Thanks again. In case anyone needs to know how to remove a quickdex, here' how (took me a few minutes to research this, maybe this will save someone some time).

At the system editor or system monitor, type:

run Set_MFS "your file name", "QUICKDEX.MFS", "5"

Note: "5" is the remove switch.

Ray

Ray-

I believe that in the Table Builder in 7.0.1 and above there is a menu choice for adding or removing Quickdexes and Rightdexes.

Cool!

View this thread on the Works forum...