hi
I have a question:
why when we call a stored procedure in delphi
that the return in Null (Example Not Match data with our Select)
Error occured?
Please help me .
thanks alot.bye.

hi Dear,
For Example If I have A Storedprocedure in SQL Server2000
that get a one Parameters and Return the result to Show in Grid in Delphi.

CREATE PROCEDURE show @id1 int AS
select * from mytbl where id=@id1

Now If i use this procedure with ADOStoredProc In "ADO Tab" Delphi
with this Format:

ADOStoredProc1.close;
ADOStoredProc1.Parameters.ParamByName('@id1').Valu e :=strtoint(edit1.text);
ADOStoredProc1.Open ;

It works Properly until I never use a ID that There is not in Table.
If I call this Stored Procedure with ID that the result of Select Is NULL,
for the next Time This Error Occured:

"Project raised exception class EOleException with message 'Either BOF or EOF is True,or the current record has been deleted .Requested operation requires a current record'.Process stopped.Use
Step or Run To continue.

If You Have a Sample Program That Work Properly Please Email me.
Thanks alot.
Goodluck.Terminator.