Cursor not returned from query

[Karen99]

I am using D7 and Sql Server 2000. When I run the store procedure in Sql Server, everything works fine. I am running through a cursor and inserting records. But if I do it from Delphi during runtime using execproc nothing happens. It does not give me an error, but it also doesn't insert any record.

And if I active = true during design time I get the following error : Cursor not returned from query

My code are:

spProcCopyUserTables.ParamByName('userid').AsInteger
:=userid;
spProcCopyUserTables.Prepared := true;
spProcCopyUserTables.ExecProc;

Could anybody please help ?

Thank you
Karen

 

[Karen99]

Don't worry, I've got my own answer. I did something stupid. But can somebody still reply to my other post "Stored Procedures with DbExpress"

Thank You

Karen