> Some other questions: What database server are you using?
Sorry, it must be my growing frustration. Forgot to say I'm using Oracle 8i
> Also, are you
> connecting using the BDE or ADO or something else?
BDE
> If the BDE, does the stored proc work when you execute is
> through the SQL
> Explorer?
Just tried it and it works through Explorer! Still doesn't work through the
app though.
> > to add them manually.
>
> Sounds like something's not right... Can you select the
> stored proc from the
> list available in the property inspector? You'd have to hook up a live
> connection to get this list first.
Yes, I can. But when I go to params collection, it doesn't pick up the
parameters and I add them manually.
At design time TStoredProced is hooked to a TDatabase with Connected set to
True. I even put a TDBGrid hooked to the same database component to see if
it works and I can see the data through the grid.
At run time I use this dummy code to run the test procedure:
var
bResult : Boolean;
begin
try
with StoredProc1 do begin
ParamByName('FIRST_PARAM').AsBoolean := True;
ParamByName('SECOND_PARAM').AsBoolean := True;
Prepare;
try
ExecProc;
bResult := ParamByName('THIRD_PARAM').AsBoolean;
if bResult then
ShowMessage('True')
else
ShowMessage('False');
finally
UnPrepare;
end;
end;
except
on E:Exception do
ShowMessage('Exception: ' + E.Message);
end;
end;
Best regards,
Sergei
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
To UnSub, send email to: [EMAIL PROTECTED]
with body of "unsubscribe delphi"
Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/
