Invalid item id?

[Scott Clift]

When selecting all the items in a file, and then saving the results of the select,  there is a item ID that looks odd.

The ID appears as .4................ in the list.

Looks like jbase tries to open item number 4, which doesn't exist.

Any ideas on how to delete this seemingly junk item?

[Richard Kann]

Is it possible you have a bad item id in the file containing revered control characters? If you do a list of the file do any odd looking id's show? You may not be able to edit them too just as an fyi as the select may only be pulling part of the bad id if due to control chars like vlaue marks, attr marks, orctr-J ctrl-L etc.

--
--

--

Richard Kann

Comp-Ware Systems, Inc.
phone: 800-494-7671
email: rk...@comp-ware.net
www.comp-ware.net

[bdeck...@gmail.com]

This code might be helpful.  It is run as check_keys <fileName>

sentence=CHANGE(@SENTENCE,SPACE(1),@AM)
PROMPT \\
i=0
fileName=sentence<2>
OPEN fileName TO hdl.fileName ELSE STOP 201, fileName
SELECT hdl.fileName TO cursor
done = @FALSE
LOOP UNTIL done DO
   READNEXT id.fileName FROM cursor THEN
      i++
      IF id.fileName NE OCONV(id.fileName, \MCP\) THEN
         CRT \Bad: HEX(id)=\:OCONV(id.fileName, \MX0C\):\ | MCP(id)=\:OCONV(id.fileName,\MCP\):\ -- DELETE?\:;INPUT yn
         IF OCONV(yn[1,1],\MCU\) EQ \Y\ THEN
           DELETE hdl.fileName, id.fileName
           CRT \deleted.\
         END
      END
   END ELSE
      done = @TRUE
   END
UNTIL done DO REPEAT
CRT i:\ keys checked\

[Scott Clift]

Yes, the name of the ID is probably somethin else, but there are over 8,000,000 records in the file, so it might be tough to catch by listing the items.

My only other thought is to select the whole file, and remove this item from the list, and then copy all other items to a new file.

[Scott Clift]

The program idea was great, thanks!

I got it sorted out based on that.

[bdeck...@gmail.com]

Glad it helped.