HOW TO FIX WARNING "SELECT QUERY"

[anilkumar_raina]

CAN SOMEBODY SUGGEST ME AN EASY SOLUTION............EXCEPT FETCH OR FIELD GROUP ONE.

I AM SELECTING 6 FIELDS FROM FEBEP TABLE INTO AN INTERNAL TABLE ,BUT THE PROBLEM IS THAT WHILE INSPECTING CODE I AM GETTING AN ERROR WARNING THAT FEBEP "TABLE IS TOO LARGE SPECIFY WHERE CONDITION".

HOW CAN I FIX THIS PROBLEM AS IT IS NOT POSSIBLE FOR ME TO SPECIFY WHERE CONDITION.

ANIL

[Former Member]

Hi Anil

Can you post your select stmt for better advices.

With the warning message, i guess it might be due to:

1. selecting individual fields into table work area

OR

2. Selecting the entries with out using WHERE condition(or with less number of paramters)

Kind Regards

Eswar

[Former Member]

HI,

U just maintain all primary keys in where condition.

May be this warning ur getting because of no of records with same data is in ur Db table.

One more thing is PERFORMANCE...

If useful reward ..

Regards,

Kishore.