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.Parameters.ParamByName('@id1').Valu e :=strtoint(edit1.text);
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.