Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

Logical database

Former Member
0 Likes
536

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?

1 ACCEPTED SOLUTION
Read only

Former Member
0 Likes
515

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

4 REPLIES 4
Read only

Former Member
0 Likes
515

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

Read only

Former Member
0 Likes
516

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

Read only

amit_khare
Active Contributor
0 Likes
515

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

Read only

Former Member
0 Likes
515

Thanks.