topic Re: Selece Query.. in Application Development and Automation Discussions

Selece Query..

Former Member — Wed, 15 Aug 2007 15:25:19 GMT

Hi,

Is there any select statement <b>to select all the fields from a table xyz, except one field ???</b>

Thanks!!

Kode

Re: Selece Query..

RichHeilman — Wed, 15 Aug 2007 15:28:57 GMT

No, there is no syntax like that, but you could simply get all records, then delete the one that you don't want using the DELETE statement.

Regards,

Rich Heilman

Re: Selece Query..

Former Member — Wed, 15 Aug 2007 15:32:39 GMT

Get all the fields into an internal table and then do a modify blanking out just that one field that you don't want. Something like this.

select * from dbtab into itab where <...>.

clear itab-dontwantthisfield.

modify itab transporting dontwantthisfield where dontwantthisfield is not initial.

Re: Selece Query..

Former Member — Wed, 15 Aug 2007 15:33:18 GMT

HI Priya,

No it is not possible.

either u have to use select * or u use select field1 field2 .. to select the data from a table.

use the second option<b> select field1 field2 ..</b> if you really want to exclue one field

Thanks

Mahesh

Re: Selece Query..

former_member192429 — Wed, 15 Aug 2007 18:39:27 GMT

Hi Priya,

You can do this..

Create an internal table with all the fields required.

Write select * from dbtab into CORRESPONDING FIELDS OF TABLE ITAB

WHERE...

This avoid writing every field in the query.

Hope this solves your problem.

-Kriss

Re: Selece Query..

Former Member — Thu, 16 Aug 2007 20:03:19 GMT

This problem is solved ..Thanks to all.

Re: Selece Query..

former_member192429 — Thu, 16 Aug 2007 20:06:02 GMT

Please let me know how is it resolved. Award the points please..

-Kriss

Re: Selece Query..

Former Member — Thu, 16 Aug 2007 20:17:44 GMT

Hi Kriss,

Actually they changed the requirement a bit. So I didn't get a chance to use any of these solutions. But I got a very good information.

Anyways I will reward points..

Re: Selece Query..

former_member192429 — Thu, 16 Aug 2007 20:28:21 GMT

Thanks for the info and rewards!!!