topic Re: insert into table corresponding fields - syntax in Application Development and Automation Discussions

insert into table corresponding fields - syntax

Former Member — Thu, 07 Sep 2006 07:24:12 GMT

Hi!

I have an structure with a lot of fields and I have a database table with less field. Some of the fields of the structure match the database table fields.

is there a way of doing an "INSERT INTO dtbase CORRESPONDING FIELDS FROM struct"??

Or do I have to move each field by:

dbase_table-field1 = struct-field1

dbase_table-field2 = struct-field2

dbase_table-field6 = struct-field6

and so on??

regards

baran

Re: insert into table corresponding fields - syntax

former_member404244 — Thu, 07 Sep 2006 07:28:02 GMT

HI Baran,

u can directly move the fields by writing

move : struct_field1 to dbtable_field1,

struct_field2 to dbtable_field2.

also u can use move-corresponding .

Regards,

Nagaraj

Re: insert into table corresponding fields - syntax

Former Member — Thu, 07 Sep 2006 07:28:11 GMT

I think the structure of datase table and internal table should be same while inserting , INTO CORRESPONDING will not work,

you have to go for ur second option

Re: insert into table corresponding fields - syntax

anversha_s — Thu, 07 Sep 2006 09:16:40 GMT

hi baran,

there is an easier way.

code like this.

______________________________________________

data : struct like database_structure.

*suppose there are 3 fields and we want to fill 2 *fields. ie field1 and field3.

struct-field1 = 'val1';

struct-field3= 'val3';

MODIFY data_base_table FROM struct.

_________________________________

this will work.

kindly award points, if u r comfortable with this.

for any clarification just mail me.

Regards,

Anversha.

anversha.shahul@wipro.com

mob 0984 66 77 531