Table maintainance generator for view-masking the field and inserting value

[Former Member]

Hi

I created the table maintainance generator for maintaince view. it consists of 7 filelds.i.e.absent type,sequence no,enddate,start date,points ,scale,weightage,higher limit. Now my problem is i want to mask the field sequence no. to avoid the user entries in this field and i have to insert numbers 1,2.3....Based up on entries and it has to increment. for this i have to add the code in the screen.can anyone suggest on this and what code have to write??

[Former Member]

DATA: lw_max(4).

SELECT single max( SEQ ) from ZTBL into lw_max.

After that, increase every new entry by 1 before inside into database table.

[Former Member]

Hi eugenecctan

where exactly i have to insert this code. when i trying to insert the code in PAI events it is giving an error.Can u suugest where exactly have to use and how to call?

[Former Member]

As long as squnr is 1 of the key fields in your table, you don't need to control the value.

[Former Member]

sorry..I'm not getting your point. can u explain more clear?? and give me the suggestion finally what i have to do.