PB version 2017 r3 build 1880

I'm doing maintenance on a window and hitting an item that has me a puzzled.

I haven't worked with a stored procedure based datawindow in almost 10 years, so apology if this is a stupid question.

I have a main datawindow with multiple dddw columns.

User selects dddw 1, based on a view.

In the itemchanged event, that value, plus other values are used to retrieve dddw 2, based on a stored procedure.

If the user selects a value in dddw 1 only once, dddw 2 retrieves correctly.

But for example, if the user realizes they chose the wrong item in dddw 1, and selects a new value, then the retrieve for dddw2 fails.

I've tried resetting dddw 2 ( the one based on the stored procedure, etc. ), but nothing is working. Running it through the debugger, the correct values are being passed for the 2nd retrieve, but I still get -1 as a result.

Thanks for any help,

John