set records to blank

Discussions about editing and cleaning data
Post Reply
etuser
Posts: 88
Joined: September 3rd, 2019, 5:57 am

set records to blank

Post by etuser »

Dear Sir,
I found out a single record ( which have more than 50 items both numeric and alpha) needs to be blank. I wrote a batch program , that failed to work because of an error message. I just copied they program form "Delete function" , from the Cspro help . Is there any other alternative solution ? I used Cspro 8.0


if Catagory in 4,5,6 then
delete(SECTION_101);
Endif;

Error message
ERROR(SECTION_101_EDT, 15): Record, group or multiple item name expected

Checked

1. I checked the record name in the dictionary and it is correct,
2. Change the required for YES to NO , both failed to work
Gregory Martin
Posts: 1803
Joined: December 5th, 2011, 11:27 pm
Location: Washington, DC

Re: set records to blank

Post by Gregory Martin »

Have you tried to use the "group" name instead of the record name? That is, delete SECTION_101_EDT instead of SECTION_101. Although the error message says that you should be able to delete a record, the record modification functions (insert/delete/sort/etc.) should generally be used on the group.

I generally handle all inserts/deletes in the level preproc, so, assuming that Catagory is a single-occurring item, I would likely write:
PROC YOUR_LEVEL_NAME

preproc

    if
Catagory in 4,5,6 then
        delete
(SECTION_101_EDT);
    endif;
Post Reply