topic Re: Question reg. 'Select' statement on date in Application Development and Automation Discussions

Question reg. 'Select' statement on date

Former Member — Thu, 08 Feb 2007 16:34:14 GMT

I want to select records from a database table based on a certain date if it is initial.

When I wrote "select so and so where date is initial' it gives me syntax error "The operator IS can only be used in "f is NULL" or "f is NOT NULL"

Please help to correct this error and how to choose the records based on that date is initial.

Thanks.

Message was edited by:

Krishen

Former Member — Thu, 08 Feb 2007 16:38:48 GMT

hi Krishen,

please try the following logic:

select * from <table name> where <date field> = space.

or if the above statement does not work, try the following code:

select * from <table name> where <date field> = '00000000'.

hope this helps,

Sajan Joseph.

Former Member — Thu, 08 Feb 2007 16:41:30 GMT

Something like:


SELECT * FROM bkpf
  WHERE aedat = '00000000'.

Rob

Former Member — Thu, 08 Feb 2007 16:57:46 GMT

this is the code to select the record from sflight table with date equal to what you have given in the screen

copy the code and alter the table name what you want

DATA: WA_SPFLI TYPE SFLIGHT.

PARAMETERS: P_DATE TYPE sflight-fldate.

SELECT * FROM SFLIGHT INTO CORRESPONDING FIELDS OF WA_SPFLI WHERE

FLDATE = P_DATE .

WRITE : / wa_spfli-fldate,

wa_spfli-planetype.

ENDSELECT.

hope this will help you

with regards

Vinayaka