SAP WebIDE Database explorer - Can not modify tables with more than 1000 entries

[WinterIT]

Hello,

we have a running database with a number of tables visible in the database explorer. It is possible to change/modify/add entries in tables with few entries (such as customizing tables) with the "Open Data" Feature in the Database explorer, however we can not modify any data in tables with large amounts of data (cut-off seems to be 1000 rows of data).

We can modify those datasets via the inbuilt SQL Editor but not via the "Open Data" Feature.

Has anyone got an idea why and how to solve this issue?

Thankyou in advance for any ideas.
Regards,
Max

[emna_benbrahim]

hello ,

i'm interested if you find the solution ?

BR

Ema

[braghavendra_rao]

Hi

In menu option Tools->Preferences, select 'SQL Console' under Global Preference section.

Set 'Max number of rows to display' as per your requirement.

This fetches the resultset accordingly if you fire a query from SQL console.

I guess it works for 'Open Data' as well.

Regards

Raghavendra

[WinterIT]

Hey, thank you for your idea but sadly this does not work.

It fetches the correct number of results but even if i set it to higher than the lines of data in the table, changes to the data are not being properly saved.