Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2004
    Posts
    4

    Unanswered: Delphi & Stored Procedure

    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.

  2. #2
    Join Date
    Jan 2004
    Posts
    4

    Thumbs up Comment (Please Answer)

    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •