topic Re: Table Fetching in Application Development and Automation Discussions

Table Fetching

Former Member — Thu, 31 Jan 2008 09:59:29 GMT

Without using SELECT *, is there any way to pick all the fields of a table?

Re: Table Fetching

Former Member — Thu, 31 Jan 2008 10:03:12 GMT

hi,

there is no other way to pick other than select*

Re: Table Fetching

former_member404244 — Thu, 31 Jan 2008 10:05:02 GMT

Hi,

If u want all the fields from the data base table then SELECT * is the best way..Thre is no other way...else u have to spcify all the fields.

Regards,

nagaraj

Re: Table Fetching

Former Member — Thu, 31 Jan 2008 10:29:10 GMT

Re: Table Fetching

Former Member — Thu, 31 Jan 2008 10:29:12 GMT

Re: Table Fetching

former_member404244 — Thu, 31 Jan 2008 10:31:28 GMT

Hi santo,

U didn't give points to both of us??

Reagrds,

Nagaraj

Re: Table Fetching

RemiKaimal — Thu, 31 Jan 2008 12:37:31 GMT

Hello,

You can, without explicitly writing a select statement using Logical databases.

As you must be knowing your LDB name can be specified in Goto->attributes in Attributes group :

Specify F1S (for BC: Planned flights, flights and bookings)

save and activate your report pgm.

Check out this sample code :


NODES: spfli, sflight.

FIELD-GROUPS: header, flight_info, flight_date.

START-OF-SELECTION.
  INSERT: spfli-carrid spfli-connid sflight-fldate
          INTO header,
          spfli-cityfrom spfli-cityto
          INTO flight_info.

GET spfli.
  EXTRACT flight_info.

GET sflight.
  EXTRACT flight_date.

END-OF-SELECTION.
  SORT STABLE.
  LOOP.
    AT FIRST.
      WRITE / 'Flight list'.
      ULINE.
    ENDAT.
    AT flight_info WITH flight_date.
      WRITE: / spfli-carrid , spfli-connid, sflight-fldate,
               spfli-cityfrom, spfli-cityto.
    ENDAT.
    AT flight_date.
      WRITE: / spfli-carrid , spfli-connid, sflight-fldate.
    ENDAT.
    AT LAST.
      ULINE.
      WRITE: cnt(spfli-carrid), 'Airlines'.
      ULINE.
    ENDAT.
  ENDLOOP.

Also note usage of LDB has slower performance than a normal select statement

Regards,

Remi

Re: Table Fetching

Former Member — Thu, 31 Jan 2008 12:45:54 GMT

select * is the best way. else you have to specify all the fields in your select statement.

Kishore.