GopiKrishna B
asked on
Delphi Getting hanged while opening 'parameter' property in "Tstoredproc" component
Hi Team, I am trying to open "Tstoredproc" component - Parameter property by clicking on "...". Once I did this activity its(Delphi) getting hanged.
I just want to define one new parameter in to that component.
Please suggest, What Can i do.
I just want to define one new parameter in to that component.
Please suggest, What Can i do.
Agree with Geert. Avoid TStoredProc.
Execute stored procedure in TQuery (or in TAdoCommand, TAdoConnection if use Ado). Just make plain string representing sql procedure call.
Execute stored procedure in TQuery (or in TAdoCommand, TAdoConnection if use Ado). Just make plain string representing sql procedure call.
This question needs an answer!
Become an EE member today
7 DAY FREE TRIALMembers can start a 7-Day Free trial then enjoy unlimited access to the platform.
View membership options
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
it's inherently slow
a TStoredProc (or a component of that storedproc type) does a syntax check and waits for the return ...
and then executes the procedure
if you use a TQuery, it just executes the procedures
the parse/syntax check happens on the database as part of the execution process, not separate