topic Insert record into DB - record with data only in Application Development and Automation Discussions

Insert record into DB - record with data only

Former Member — Wed, 12 Mar 2008 02:02:55 GMT

Hi gurus,

I tried to insert data from itab into db.

When there is no data from itab, there is still one row of record as such

00000

0000

in this case, the above record went into my db.

Since, there is really no data, how can i avoid this data into my db?

Many thanks.

Former Member — Wed, 12 Mar 2008 02:41:28 GMT

Hi,

Simply check in the internal table.

LOOP AT itab.

IF itab IS INITIAL.

DELETE itab.

ENDLOOP.

Regards,

Atish

Former Member — Wed, 12 Mar 2008 02:45:37 GMT

Hi,

I managed to solve it this way too.

IF NOT itab_voc IS INITIAL.

INSERT zeuc127_v FROM itab_voc[].

endif.

Thanks for your help too

Former Member — Wed, 12 Mar 2008 02:58:07 GMT

resolved.

Former Member — Wed, 12 Mar 2008 03:01:26 GMT

hi,

do this way ....


loop at itab.
  if not itab IS INITIAL.
    INSERT ztable FROM itab.
  endif.
endloop.

Regards,

Santosh