topic Re: Table Maintanance in Application Development and Automation Discussions

Table Maintanance

Former Member — Fri, 21 Jul 2006 16:07:28 GMT

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

Re: Table Maintanance

Former Member — Fri, 21 Jul 2006 16:11:41 GMT

Hi Pavan,

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

Thanks,

Amit

Re: Table Maintanance

Former Member — Fri, 21 Jul 2006 16:12:43 GMT

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

Re: Table Maintanance

Former Member — Fri, 21 Jul 2006 16:17:27 GMT

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

Re: Table Maintanance

Former Member — Fri, 21 Jul 2006 18:16:49 GMT

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.