Re: Any way to keep TADOStoredProc parameters

From: Alan (NOSPAMalan_pltse_at_yahoo.com.au)
Date: 02/18/05


Date: Fri, 18 Feb 2005 17:01:11 +1100

I think I need to manually re-create Parameters again because I do not
connect the TADOStroedProc component to the database at design time. I only
connect the component at run time, so the dropdown list box of the procedure
name property in Object Inspector does not have the available stored
procedure names populated.
I only type in the name of the stored procedure into the box.

> You can Refresh the parameters so that they are read from the stored
procedure
> or just create them.



Relevant Pages

  • Re: Set Excel column names on destination with SSIS pacakge
    ... One way i can see to do this is at design time you go to the advanced editor and change the names of the columns. ... I'm exporting data using SSIS from a stored procedure call to an EXCEL ... I can set the Excel column names to the names of the ... Can any on help on how to set these destination column names? ...
    (microsoft.public.sqlserver.dts)
  • Oracle Stored Proc problem
    ... Is there any way to declare a variable in stored procedure that should ... hold --- length of text which is not known at design time. ... inSubFKey in varchar ... In the above example If I use vDupTxt VARCHAR, ...
    (comp.databases.oracle.server)
  • Oracle Stored Proc issues
    ... Is there any way to declare a variable in stored procedure that should ... hold --- length of text which is not known at design time. ... inSubFKey in varchar ... In the above example If I use vDupTxt VARCHAR, ...
    (comp.databases.oracle.misc)
  • Re: Oracle Stored Proc problem
    ... hold --- length of text which is not known at design time. ... While executing the stored procedure at runtime, ... PL SQL variables are limited to 32K. ...
    (comp.databases.oracle.server)