topic Re: Logical database in Application Development and Automation Discussions

Logical database

Former Member — Thu, 16 Nov 2006 13:17:09 GMT

Hi there. I'm using ADA logical database to perform data selection. After I select data from certain table, I have to restrict the result with another selection. How can I select the max value from table ANEP?

Re: Logical database

Former Member — Thu, 16 Nov 2006 13:19:14 GMT

u get data to variable/internal table. now loop this and using another data selection u can restrict the values.

Re: Logical database

Former Member — Thu, 16 Nov 2006 13:22:08 GMT

Select max(Fieldname here) from ANEP into WORK_AREA where MENTION_CONDITION

I hope it helps.

Best Regards,

Vibha

*Please mark all the helpful answers

Re: Logical database

amit_khare — Thu, 16 Nov 2006 13:22:31 GMT

Hi,

You may go like this -

Get <struct/tab>.

if tab-field <= v_value. (to select values greater than v_value.

reject.

End-of-selection.

Regards,

Amit

Re: Logical database

Former Member — Thu, 16 Nov 2006 13:31:30 GMT

Thanks.