topic Re: error in select statement in Application Development and Automation Discussions

error in select statement

Former Member — Mon, 04 Jun 2007 19:42:27 GMT

select kostl from csks into table incsks

where csks-datbi =< sstdate

and csks-datab => snddate

and csks-kosar in ('i','p') .

it is giving the following error.what can be the reason.

Error: Field "CSKS-DATBI" unknown.

RichHeilman — Mon, 04 Jun 2007 19:46:27 GMT

Try this. You don't need table name in WHERE clause.




select kostl from csks into table incsks
         where datbi =< sstdate
           and datab => snddate
           and kosar in ('i','p') .

Regards,

RIch Heilman

Former Member — Mon, 04 Jun 2007 19:48:02 GMT


select kostl 
into table incsks
from csks 
where datbi LE sstdate
and datab GE snddate
and kosar in ('i','p') .

Greetings,

Blag.

Former Member — Mon, 04 Jun 2007 19:52:36 GMT

yeah,

i realised, how could i be so dumm to do this error.

thanks a lot.