Last beta version of TOAD ss 22.214.171.124, but it’s the same in last stable version 5.8 of it.
In attach a ZIP file. This file contains :
- A screenshot in JPG that show you dependiences screenshot of the stored procedure.
- A script SQL of the stored procedure.
If you see 2) you find at the end of the script these lines :
insert into requestitems
select newid(), 77,itemcode, 1, 60
set securitylevel = 1
where assortment in (19,20,21,23)
and securitylevel > 1
requestitems and items are tables of DB.
If you see 1) the screenshot tell me that dependiences is only one ITEMS.
For me the dependiences are two, ITEMS and REQUESTIMTEMS, not only - items -.
Items was updated and in requestimtems the procedure insert records.
I believe to see all these 2 tables in dependiences not only one, under section uses tables.
Are you agree ?
I stay tune for your answer.
toad.zip (263 KB)
toad.zip (11.2 KB)