Re: Stored procedure

Are you trying to Create the Stored Procedure or Execute it?

// Create
AdoQuery.SQL.Text :=
'create PROCEDURE Demo_Search AS select * from table1';

AdoQuery.ExecSQL ;

// Execute with a result
AdoQuery.SQL.Text := 'Exec Demo_Search' ;
AdoQuery.Open ;

// Execute without a result
AdoQuery.SQL.Text := 'Demo_Search' ;
AdoQuery.ExecSQL ;

// Using TADOStoredProc

ADOStoredProc1.ExecProc ;

I generally don't use TADOStoredProc to return a result set.

-Steve-

"Alan" <alanpltseNOSPAM@xxxxxxxxxxxx> wrote in message
news:447d3ac2@xxxxxxxxxxxxxxxxxxxxxxxxx
create PROCEDURE Demo_Search
AS
select * from table1


SQLADOConnection.Connected := FALSE;
SQLADOConnection.Connected := TRUE;
ADOStoredProc1.Open;

I got an error: "No such interface supported"




.

Relevant Pages

  • Re: why cant i get the data
    ... You didn't describe 3 tier in your original request. ... However, tADOStoredProc ... It will only execute a stored procedure. ... stored procedure has a "select" statment in it, it doesn't matter, the VCL ...
    (borland.public.delphi.database.ado)
  • Re: why cant i get the data
    ... Yeah, my stored procedure has a "select" statement in it, and use the Method ... tADOStoredProc ... It will only execute a stored procedure. ...
    (borland.public.delphi.database.ado)
  • RE: SQL stored procedure executing twice
    ... I wasn't aware that DLookupwould execute the "domain" more than once. ... caused the stored procedure to execute twice. ... Dim stDocName As String ... My pass-thru query properties ...
    (microsoft.public.access.modulesdaovba)
  • Re: SQLserver and the WHERE x IN y
    ... to a stored procedure - that would only work if you introduced subtyping into ... the temp table from the calling procedure (the temp table is still in scope, ... INSERT INTO #MyTempTable EXECUTE YourPopulateProc 123 ... INSERT INTO @MyTableVar VALUES ...
    (microsoft.public.sqlserver.programming)
  • RE: SQL stored procedure executing twice
    ... caused the stored procedure to execute twice. ... from one parent record to another. ... Dim stDocName As String ... The table tempCount does not change until I execute the VBA code line: ...
    (microsoft.public.access.modulesdaovba)