ADOStoredProc and ACCESS Query

[BuilderSpec]

Hi

Is there a way to make the ADOStoredProcedure control dynamically pick up the parameters from the query defined in Access database ?



Hope this helps!

Regards

BuilderSpec

 

[2ffat]

IF I understand you correctly, I suspect that you can. I've not used stored procedures. I prefer to use queries and data sets. I pretty sure you could use them.

Where are you getting stuck?


James P. Cottingham
-----------------------------------------
^{I'm number 1,229!
I'm number 1,229!}

 

[BuilderSpec]

Hi

In Access you can create a query and define the parameters.

In C++ Builder you can use an ADOTable or ADOQuery etc, but I am trying to find a way that the component can be made aware itself of any parameters.

ADOQuery is easy enough since that uses SQL, you could copy the SQL and the parameters are inherent in the SQL. But if all I know is the name of the query in Access , how do I dynamically a) pick up it's associated SQL and/or b) pick up it's parameters ?

Hope that made it clearer..

Hope this helps!

Regards

BuilderSpec