ADOExpress Stored procedure parameters (TeamB - any ideas?) - Thread - go-pugleaf

Thread View: comp.lang.pascal.delphi.databases

2 messages

[T] Back to Threads [V] Tree View [G] Group Articles

2 total messages Started by pittsje Fri, 10 Sep 1999 00:00

ADOExpress Stored procedure parameters (TeamB - any ideas?)

#191

Author: pittsje
Date: Fri, 10 Sep 1999 00:00

16 lines
1337 bytes

I am trying to reverse-engineer the method that Delphi 5 (ADO,
preferably) uses to populate the Parameters collection for a
TADOStoredProc component at design for my own use at run time. So far,
my options are to directly call sp_procedure_params_rowset and parse
those results. The preferred method would be to reuse Borland's method.

Yes, I am aware of the potential performance hit associated with this
action - my design includes cacheing the results for later use if
necessary.

Any ideas?



Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't.

Re: ADOExpress Stored procedure parameters (TeamB - any ideas?)

#190

Author: pittsje
Date: Wed, 15 Sep 1999 00:00

33 lines
2092 bytes

Question restated - Is there an ADO method call to retrieve the
parameters for a stored procedure?
Or, what am I doing wrong here: (is it possible that this is only valid
for ADO 2.5 beta?)
rs := OpenSchema( adSchemaProcedureParameters,
['salesdata', 'dbo', 'sp_Cleanup', ''],
nil )

this call tells me that a parameter is incorrect.
Help, anyone?

In article <7rbrd7$upm$1@nnrp1.deja.com>,
  pittsje@my-deja.com wrote:
> I am trying to reverse-engineer the method that Delphi 5 (ADO,
> preferably) uses to populate the Parameters collection for a
> TADOStoredProc component at design for my own use at run time. So far,
> my options are to directly call sp_procedure_params_rowset and parse
> those results. The preferred method would be to reuse Borland's
method.
>
> Yes, I am aware of the potential performance hit associated with this
> action - my design includes cacheing the results for later use if
> necessary.
>
> Any ideas?
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.
>

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't.

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads