Devart Forums

Hi,

I have a huge application written using the BDE that I'm porting to ODAC.

I've used your "BDE Migration Wizard" to replace BDE controls with ODAC replacements.

As a result all the parameters in the Params property are lost for TStoredProc's.

When using TStoredProc (BDE) after setting the package name the Params are filled automagically - as soon as you set the SP name.

When using TORAStoredProc I need to click the "Execute" button (on the stored proc "editor") or set Activate to true at design time.

Is there a way to grab parameters without the need to "Execute" every single SP?

p.s.
To make it even more complicated ... in reality all SPs are connected to client datasets over dataset providers.

Thus, I'm opening CDS's *not* SPs.

You don't need to execute TOraStoredProc component. There is special button 'Create SQL' in TOraStoredProc editor. It is located on the right side of the editor window, after overload number edit. This button has 'new document' picture.

If you change the name of stored procedure in the editor, parameters are also created automatically when you move focus to another control.

Hi,

Plash wrote:You don't need to execute TOraStoredProc component. There is special button 'Create SQL' in TOraStoredProc editor. It is located on the right side of the editor window, after overload number edit. This button has 'new document' picture.

Ah I see, thanks. This works.

Plash wrote: If you change the name of stored procedure in the editor, parameters are also created automatically when you move focus to another control.

I'm changing (cut, paste) the name of the StoredProcName property directly in the Object Inspector - in that way parameters are *not* created.

The real situation is that I have the names of stored procedures already specified in the "StoredProcName" property (in ObjectInspector).

Is there a way to somehow select ALL TORAStoredProc controls on the form (data module) and "execute" the "create SQL" action at design time in the IDE (not to have to do that by hand for each and every one)?

In the next ODAC build we'll add feature of creating parameters automatically when you change StoredProcName in Object Inspector.

There is no easy way to create procedure call SQL for all components on the from at once.

Plash wrote:In the next ODAC build we'll add feature of creating parameters automatically when you change StoredProcName in Object Inspector.

Any info on when this will be?

Plash wrote:There is no easy way to create procedure call SQL for all components on the from at once.

Is there a non-manual hard way ?