topic Make new field table with default value in Application Development and Automation Discussions

Make new field table with default value

Former Member — Thu, 16 Oct 2008 14:35:50 GMT

It is possible, add a new field to a table in the dictionary and give it a default style PL / SQL

num_emple VARCHAR2 (15) DEFAULT 'Pedro'

And when you insert a new record, the field has num_emple values' Pedro '

Excuse my English, Thank you.

Re: Make new field table with default value

former_member156446 — Thu, 16 Oct 2008 19:46:04 GMT

if you can search the forum for Append structure.. I guess that will be your answer.

Re: Make new field table with default value

Former Member — Thu, 16 Oct 2008 20:09:32 GMT

Hi,

I don't think so that it is possible...

Re: Make new field table with default value

Former Member — Thu, 16 Oct 2008 21:28:21 GMT

its not possible

Re: Make new field table with default value

Former Member — Fri, 17 Oct 2008 06:44:53 GMT

no this is not possible.

You can assign F4/search help for a field.

Re: Make new field table with default value

christine_evans — Mon, 20 Oct 2008 10:00:05 GMT

> It is possible, add a new field to a table in the dictionary and give it a default style PL / SQL

num_emple VARCHAR2 (15) DEFAULT 'Pedro'

> And when you insert a new record, the field has num_emple values' Pedro '

> Excuse my English, Thank you.

You might be able to do something like this with conversion exits.

Re: Make new field table with default value

naveen_inuganti2 — Mon, 20 Oct 2008 11:07:16 GMT

Hi..

Most of the things can be possible at dictionary level and this too..

Let you know, before that, check below steps once..,

1. Add that new field to your table. with value range as your default value

and in one local progran write the syntax like following.,to update the new field in previous records.,

data: itab like yourtable occurs 0 with header line.
data: wa like line of itab.
select * from yourtable into corresponding fields of table itab.
loop at itab into wa.
 wa-newfield = 'TEST'.
 modify yourtablel from wa.
endloop.

2. And then modify the code from where your ztable is updating with this new field also, by giving the hard coded input as you want.

If this does not meets your reuirement, let me now reason why you are not able to use this procedure.

Because there you have to go for table control event level settings... get back to you.

Thanks,

Naveen.I

Re: Make new field table with default value

Former Member — Mon, 20 Oct 2008 12:03:28 GMT

Thank you all, I also believe that it is not possible.

Re: Make new field table with default value

naveen_inuganti2 — Mon, 20 Oct 2008 12:20:04 GMT

Sierra wrote: > Thank you all, I also believe that it is not possible.

But its possible, Dont comprimize with your reuirement., as we are working with forth generation language. As I already said most of the things can be possible here.

Anyway you already closed this thread.

All the best in your task,

Thanks,

Naveen.I