Is there a limit to the capacity of Query Window to accept code?
Hi,
I seem to have filled the Query Window to the max.
I am writing longer and longer queries in notepad, and paste them to the Query Window.
My queries are long mainly because:
(1) I use a kind of menu system so as to simplify the life of users. It means my queries in fact hold many queries inside.
I use GOTO to branch to the appropriate query selected by the user. So, my staff have all related queries in one place.
(2) I have still not developed sufficient proficiency in stored procedures, UDF, etc which can shorten codes.
From time to time, I do shorten my codes.
I got a bad surprise today.
My existing code is already very long – about 17 pages A4 (not too crowded) and has served me well.
Now I added about 10 more pages….
Query Window won’t accept anymore!
Could anyone tell me what is happening?
Is there a limit to how long you can run Queries in Query Window?
Of course I know I must shorten my codes, but I did not expect SAP to limit the size of queries
one can write.
Suppose an expert wrote a query (say 50 pages A4), which cannot be shortened anymore.
How would he proceed to run his query to generate reports from SAP?
Thanks
Leon Lai
Hello,
Just an idea.
Why don't you create a view in SQL server? You can refer these view from SAP as a single querry...in sql server i dont think such limitation exists...
Regards,
Ottó
Hi,
The limitation for query in SAP B1 is 64000 characters,you need to use stored procedure or view in SQL server to accommodate your requirement