Devart Forums

Hello,

We set up a machine to test our application with ODAC 6.

we use many stored procs.

With ODAC 5 removing the StoredProcName value cleared the parameters.
Putting back the StoredProcName value forced ODAC to read again the parameters when clicking on Params.

This is broken in ODAC 6 and is not working anymore. The only way to get the parameters is to clic "execute" in the Params window. but then the OUT fields are no more null and the output values are stored in the DFM.

Thank you for investigating this issue

In the next ODAC build we'll add the 'Create SQL' button to the TOraStoredProc editor. This button can be used to recreate stored procedure parameters.

Good idea i agree

Thank you

Hello,

I'm now running ODAC 6.10.0.9

but i can't find the 'Create SQL' button in TOraStoredProc design-time editor.

ODAC revision history tells : Added 'Create SQL' button in TOraStoredProc design-time editor

Do you actually see the button ?

You can find the "Create SQL" button right after "Overload" splitter in the top right corner of the window.

Challenger wrote:You can find the "Create SQL" button right after "Overload" splitter in the top right corner of the window.

Oh yes thanks ! found it. I was searching in the parameters panel for a button with 'create sql' written on it. because when you click 'params' in the object inspector you get directly there.

Maybe the button shoud be visible in the parameters panel when the params list is empty ? not sure, just an idea.