Table Maintanance

[Former Member]

Hi,

I've a problem related to Table maintanance, this is the snap shot...

My table structure & data

<b>Storage type</b> <b>Bintype</b>

S001 B001

S001 B002

S001 B003

in table maintance can we make it like this to user input?

S001 B001 B002 B003 ..........

(Single row)

if user enters B004 and save then it should be 4th row in my database table.

Plese let me know it is doable or not?

Thanks

-Pavan

[Former Member]

Hi Pavan,

It is possible if you can write a small program for this.

Thanks,

Amit

[Former Member]

Hi Amit,

Thanks for your reply, Could you please give me some more hints about this .. how to do?

if you have any sample code, it will be excellent..

Thanks a lot

Pavan

[Former Member]

Hey,

You can create a maintenance view for the table and mark the "Maintenance attribute" for the field Storage type as "S". Create a table maintenance for the view

While maintenance the user will have to enter Storage type in the initial screen and will be presented a table control for the Bintype field.

-Kiran

[Former Member]

When you have a table maintenance you can assign events to the table maintenance. These events have numbers assigned to them e.g, 2 for new Entry. You associate a subroutine with this new entry and within the subroutine write code to validate the new entries. If you look at the table maintenance screen options you will find the place where the events can be assigned. The table where the events are TVIMF , I think.